Support Board
Date/Time: Sat, 05 Jul 2025 11:55:42 +0000
Post From: ID#.SG#@Row# format fails to realign references.
| [2024-11-24 19:52:38] |
| Sawtooth - Posts: 4232 |
|
I built a system with 60 Formula Columns, but only used 28 so I reduced the setting to 30 Formula Columns. ID1.SG1@3 was in column BS, but now is in column AO, as expected. Everything appears correct. However, when starting a Replay Chart, the displayed subgraphs are not where they belong. If the Formula Columns setting is returned to 60, all is well. A workaround fix for this to work with 30 Formula Columns: - change O3 from =ID1.SG1@3 to =AO3 (references resumed proper alignment) - then change O3 from =AO3 back to =ID1.SG1@3 (references retained proper alignment) Please advise. Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study |