Support Board

Date/Time: Tue, 07 May 2024 10:30:38 +0000

Post From: Additional formula columns in existing spreadsheet

[2015-08-13 14:37:08] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
Given an existing spreadsheet (new style), is there a way to add additional formula columns to the spreadsheet such that the existing formulas and columns don't get messed up? Unfortunately, no. If you had used the ID#.SG# reference (instead of a column reference) when the spreadsheet was first built, you could increase the Number of Formula Columns and the references would be retained, but this assumes you didn't delete that study and add another that took the same ID#. http://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#ReferencesStudySubgraphColumnsSpreadsheetStudy Can I just use existing columns starting after the study columns? You can only use columns to the right of the study output columns as non-repeating cells; they won't autofill below. And if you add any study, it's output appears in those columns.