Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 19 May 2024 03:36:39 +0000
Spreadsheet results disappear
View Count: 683
| [2019-03-25 12:59:27] |
| RonW - Posts: 103 |
|
I have a Chartbook with 5 charts open. I have one spreadsheet study open. Each of the 5 charts has the spreadsheet study added to it. I added a sheet to the spreadsheet. I have calculations on the sheet that reference the other sheets (i.e. the ones associated with each chart). Everything was working great. It became desirable for me to change the organization of the new sheet so that the information I needed from it was in one place and easier to see. To do this, I cut and pasted some cells, and I deleted a couple of rows and columns that were not being used. All of a sudden, a number of the formula results stopped displaying. I changed the "Number Format" back to Default and the Cell Properties back to Automatic for Text and Background. I still can't see the formula results. The formulas are still in the cells. Even if I go in to the cell and edit them, it takes the edits, but no answer is displayed. |
| [2019-03-25 18:30:05] |
| |
|
Attach that spreadsheet following the instructions here: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile And tell us one of the Sheets and cell that you do not see the formula result in. Just one only. 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 Date Time Of Last Edit: 2019-03-25 18:30:30
|
| [2019-03-28 12:45:06] |
| RonW - Posts: 103 |
|
It appears my problem is at least partially related to Global Settings/Spreadsheet Settings: Reference Modification defaults to "do not update". If I change it to update, I'm getting better results; I'm not sure if the problem is fully resolved yet. Is there a reason in Sierra Chart why the option not to update references exists? It seems a little counterintuitive relative to my experience with Excel, but maybe I am missing something? Thanks |
| [2019-03-28 17:04:38] |
| |
|
Sometimes there is a reason just to disable this. It depends upon what a user is intending to do.
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: