Home >> Support Board

Support Board

Date/Time: Wed, 05 Feb 2025 14:11:08 +0000

How to Post a Message for Support

[Programming Help] - Spreadsheet programming question

View Count: 1014

[2020-03-15 04:01:13] #1 [Go To First Post]
User183724 - Posts: 191
Whats the maximum number of Formula Columns? The default is 16 but I heard that was changing and I can't find the actual number anywhere. thanks Tim

[2020-03-15 12:30:54] #2 [Go To First Post]
Sawtooth - Posts: 4167
The max is 60 columns. Spreadsheet Study Inputs: Number of Formula Columns

[2020-03-15 19:18:05] #3 [Go To First Post]
User48838 - Posts: 121
Tom The columns to the right of the the 60th one you refer to can be used also, no?

[2020-03-16 03:56:07] #4 [Go To First Post]
Sawtooth - Posts: 4167
The columns to the right of the highest Formula Column setting are where the study's outputs will appear. They will overwrite any user entries. Why do you need to use those columns?

[2020-03-16 09:24:15] #5 [Go To First Post]
User48838 - Posts: 121
If the spreadsheet calculation is complex, you need those columns, I guess I was referring to the columns to the right of where the study data is written. I have a spreadsheet that goes out to column DE or or so. I just didn't use the columns that had study data in them. The only anomaly i see with the columns past the study data is that only row 4 is populated.

[2020-03-16 13:41:37] #6 [Go To First Post]
Sawtooth - Posts: 4167
You could use the columns to the right of all study outputs, with these caveats: - If you add any studies, formulas in those columns would be overwritten by study outputs. - Formulas in row 3 will not auto-populate to rows below, as Formula Columns do. IOW, these rows and cells are static. Workaround: If you need more than 60 Formula Columns that auto-populate, you can Duplicate the spreadsheet study on the same chart, and set its 'Chart Data Output Sheet Number' to an unused Sheet#, and use/reference the Formula Columns that will be on that sheet. But there are cautions with this also. If you need a static sheet that is safe from being overwritten, you can add a sheet that is not associated with a chart: Go to Spreadsheet >> Add Sheet and give it a unique name so that it's not confused with a chart's sheet.

[2020-03-16 14:13:31] #7 [Go To First Post]
User48838 - Posts: 121
TY, those are helpful for me.

To post a message in this thread, you need to log in with your Sierra Chart account: