Login Page - Create Account

Support Board


Date/Time: Sat, 04 May 2024 02:58:03 +0000



[Programming Help] - Spreadsheet programming

View Count: 492

[2020-04-11 15:21:29]
User183724 - Posts: 183
My comments are disappearing when i exit / reenter SC. Any text in line 1 doesn't save either. Anyone know of a fix. thx tim
[2020-04-11 15:35:41]
Sawtooth - Posts: 3993
Check this setting:
Spreadsheet Study Inputs: Formula Source Sheet Number

Only work on the sheet that matches this setting.

By default, this setting matches the chart number, except if the chart has been duplicated.
[2020-04-11 16:45:26]
User183724 - Posts: 183
thanks. i did all that and still have the problem. also have formulas that won't populate the column - only row 3. i've been copying the formulas to notepad, deleting the sheet and repopulating a new sheet. guess it's time.
[2020-04-11 18:06:29]
Sawtooth - Posts: 3993
If you are on the sheet# that matches the Formula Source Sheet Number, try Chart >> Recalculate.

You also must be in a Formula Column that is within the Number Of Formula Columns setting.
[2020-04-12 16:49:41]
User183724 - Posts: 183
Thanks. I had put the formula in a column O3 just to make sure there was a problem. I think there was an issue with something I had done but couldnt find it or maybe a problem with the sheet itself. Either way, it cleared up when i deleted the sheet and repopulated the new one. thanks for your assistance
Date Time Of Last Edit: 2020-04-12 16:50:03

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account