Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 02 May 2024 01:11:49 +0000
Inserting Columns / Formulas all get distorted
View Count: 556
| [2019-09-27 12:53:56] |
| User38606 - Posts: 80 |
|
Hi. When I insert columns in new spreadsheet studies, all formulas are getting distorted in the spreadsheet. There is no parallel shift like in a real excel spreadsheet or old spreadsheet studies. (i.e. I have study in many columns....but i need more space to insert new studies. i am trying to shift entire study to the right. Insert columns and all gets out of order. Cut and paste does not work either.....it is losing links to columns to the left and shifts as well....please, advise....don't tell me that I have to populate every formula cell again to regain space. That is way too time consuming.
|
| [2019-09-27 13:16:04] |
| |
|
From our perspective it is not clear exactly what you are doing and what you are intending and what exactly the issue is. You should not be doing an actual Spreadsheet >> Insert Column when using the Spreadsheet Study. If you are referring to references to Studies outputted to the study columns, then refer to: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study 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-09-27 13:17:26
|
| [2019-09-27 14:49:58] |
| User38606 - Posts: 80 |
|
Ok I think I got it. You need to go to Global Settings >>>> Spreadsheet Studies and Update References To Match Moved Cells. Also click on recalculate there and it works perfect. So now u can insert columns and it still works great as required. Thank u
Date Time Of Last Edit: 2019-09-27 14:50:46
|
| [2019-09-27 15:04:52] |
| |
|
Yes this is explained here: Working with Spreadsheets: Inserting and Deleting Rows and Columns 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: