Support Board

Date/Time: Wed, 08 May 2024 16:05:11 +0000

Post From: Can spreadsheet columns H and J be made to follow the Formula Source Sheet Number?

[2013-09-03 22:35:01] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
In your new spreadsheets, can formulas and values in spreadsheet columns H and J be made to follow the Formula Source Sheet Number? (Specifically, only the read/write (not read-only) cells in column J, and additionally, cells I1:J2). Justification: - Frequently I reference column H, and cells I1:J2, for user parameters, but when sharing a custom spreadsheet study saved as a Save-Single Study Collection, the Formula Source Sheet Number does not transfer the formulas/values in those columns/cells. - Read/write cells in column J are also frequently referenced, and the formulas/values in those cells don't transfer either. If you do this upgrade, please do not transfer the column J read-only cells. All charts in a chartbook are frequently not the same symbol or bar period. If they were then the Chart Data Output Sheet Number option could be used.