Support Board
Date/Time: Sun, 24 Nov 2024 02:51:00 +0000
Post From: Can spreadsheet columns H and J be made to follow the Formula Source Sheet Number?
| [2013-09-03 22:35:01] |
| Sawtooth - Posts: 4118 |
|
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. |