Support Board
Date/Time: Thu, 28 Nov 2024 18:35:28 +0000
How to remove a study in a spreadsheet without distorting the formulas?
View Count: 319
| [2023-04-12 16:11:27] |
| User38606 - Posts: 106 |
|
Hi there, Have studies on the chart and correspondingly in the spreadsheet study. Let's say 10 studies. The Spreadsheet study sheet has all sort of calculations in the cells (various columns) linked to those studies (data cells) which feed in as well. I am cleaning it up and want to remove say study 3. When I am deleting it - entire spreadsheet gets distorted. What is the workaround about it? Please, note that I spreadsheet settings all set up right way: recalculate the chart when a formula column is changed >>>> YES Reference Modification when inserting and deleting rows or columns: Update references to match cells |
| [2023-04-13 01:02:10] |
| Sawtooth - Posts: 4120 |
|
What is the workaround about it?
The solution is to use this study reference method, instead of column/row study references:Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study |
To post a message in this thread, you need to log in with your Sierra Chart account: