Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 06 May 2024 10:05:32 +0000
Saving Sheet
View Count: 582
| [2020-04-03 09:08:18] |
| User20202020 - Posts: 18 |
|
Hi, When I have multiple sheets within a Spreadsheet and save specific values to each of the sheets, it will not save the specific changes. When I save and re-open, it opens the saved value from Sheet1 and opens the exact same values in all other sheets. Please see the attached screenshots of the specific values that are different in each sheet. After it is re-opened (after being saved), the values in cell AB3 go back to 1,000. Sheet1 should be 1,000 sheet 2 should be 2,000 sheet 3 should be 3,000 and sheet 4 should be 4,000. Is there a way that I can save specific values to each sheet and have it re-open with those values in each sheet? Thank you for your help. |
 ScreenShots 4.2.20.png / V - Attached On 2020-04-03 09:01:01 UTC - Size: 25.07 KB - 213 views |
| [2020-04-04 08:41:14] |
| |
|
The cells you are referring to are set by the Spreadsheet Study since they are study output columns. So you cannot expect those values to remain as you set them. They are automatically set by the Spreadsheet Study. It is pointless to change them. They are going to get overwritten.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-04-04 13:18:07] |
| Sawtooth - Posts: 3993 |
|
If the Number Of Formula Columns is set to 18 or higher, columns AA and AB will not be overwritten by study outputs. Spreadsheet Study Inputs: Number of Formula Columns The overwriting of those cells is more likely due to the Formula Source Sheet Number setting. IOW, set the Formula Source Sheet Number to match the Chart#. Spreadsheet Study Inputs: Formula Source Sheet Number |
To post a message in this thread, you need to log in with your Sierra Chart account: