Support Board
Date/Time: Fri, 01 Nov 2024 00:08:25 +0000
Spreadsheet Problem
View Count: 1088
| [2019-08-29 10:38:55] |
| user58907 - Posts: 83 |
|
The formulas I enter in column Z keep getting wiped out every time I close and save. I have opened backup spreadsheets and the formulas are intact, but even if I open a backup chartbook, the formulas get wiped. I did not change any settings so it is still 16 formula columns and 0 blank columns before first study. Tried moving and renaming backup spreadsheet files, same thing happens. Everything worked fine yesterday so I'm at a loss as to how to proceed. Appreciate your help on this one. |
| [2019-08-29 11:07:15] |
| user58907 - Posts: 83 |
|
I've tried writing formulas in other columns, they too get wiped out when I save and exit.
|
| [2019-08-29 11:09:57] |
| |
|
Check this Input setting with the Spreadsheet study: Spreadsheet Study Inputs: Formula Source Sheet Number 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 |
| [2019-08-29 11:52:14] |
| user58907 - Posts: 83 |
|
When I migrated to the new spreadsheets, I set the Chart Data Output Specification Type to "By Name", and the Formula Source Sheet Number I set manually to match the Chart Number, as there is no option to select By Name. These Settings are still unchanged from before, but it is behaving as indicated in the documentation titled Formulas Getting Erased. |
| [2019-08-29 12:11:47] |
| user58907 - Posts: 83 |
|
One thing I've just noticed which might help pinpoint the problem, the software has created a full set of numbered sheets, which do not exist on the backup copy of the spreadsheet. Deleting them does not make them go away, they are re-created automatically. As these sheets have no formulas on them, it might explain why they get erased on the designated sheet.
Date Time Of Last Edit: 2019-08-29 12:14:10
|
| [2019-08-30 08:28:55] |
| user58907 - Posts: 83 |
|
I have managed to resolve this. When I created the spreadsheet, I worked through the chart tabs from L to R, numbering the sheets sequentially. On 28th I updated from v1941 to v1978 and in the process all formula source sheet numbers defaulted to the chart number, and an equivalent number of Sheet#s were created as formula source sheets. I've changed "Always Set Formula Source Sheet Number to Output Sheet Number" from Yes to No, and created the required formula source sheets. This has allowed me to delete the extraneous Sheet#s. |
| [2019-08-30 18:22:44] |
| |
|
Ok this is good. We were going to ask for your Chartbook and spreadsheet but now that it is resolved, then that is good.
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 |
To post a message in this thread, you need to log in with your Sierra Chart account: