search

FrozenTundraTrader / sierrachart

Sierra Chart Custom Studies
100 stars 45 forks source link

'Note' column only displays numeric characters #10

Closed buckrogerss closed 6 months ago

buckrogerss commented 6 months ago

This may be a feature but the presence of any text/alpha characters in the 'Note' column displays nothing in the label in SC. Numeric values display normally.

FrozenTundraTrader commented 6 months ago

@buckrogerss please provide the URL to your spreadsheet, I will take a look and try to reproduce on my end. First I've heard of an issue like this.

buckrogerss commented 6 months ago

hey, thanks for getting back to me. in looking back over this today, I found the issue, and it appears to be the sheet auto-formatting. all the values I have been using in 'Note' are currently numbers, and even though they're converted to strings in python, google sheets converts them back to numbers, even with leading/trailing spaces or a leading apostrophe. for some reason, if there are x number of number-formatted values in the column, it won't output the text-formatted value in SC. if I have all alpha-based strings in Note, it works fine.

link to a sheet I'm using: https://docs.google.com/spreadsheets/d/1W7d1pZ6R97WnrbBmg0laZyNL4xuTHkdpVsyhlYK2RZg/edit?usp=sharing

FrozenTundraTrader commented 6 months ago

Souds good, thanks for closing the loop. Closing out this issue.