Home >> Support Board

Support Board

Date/Time: Tue, 14 May 2024 21:51:50 +0000

How to Post a Message for Support

Post From: Spreadsheet Commentary

[2013-11-19 00:51:28] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3996
I've used the standalone spreadsheets as 'master sheets'. This avoids having to use a dummy chart to hold open a sheet number. And it avoids overwriting a sheet when duplicating a chart that uses a Chart Data Output Sheet Number greater than 0. Duplicating a chart with a spreadsheet study will retain the Chart Data Output Sheet Number and Formula Source Sheet Number options. If you don't realize this, you can create trouble for yourself. Sheet numbers (tab positions) are currently completely assignable, using the Chart Data Output Sheet Number and Formula Source Sheet Number options. What I struggle with are problems that arise when sharing a custom spreadsheet study: 1) You can save a Study Collection (with a '-' after the name) of the spreadsheet study and supporting studies, but if the user applies it to a chart number other than the one you used to create it, parameters in non-repeating cells will not follow to the new sheet, e.g. columns H and J. 2) If the user has existing spreadsheet studies on a chart, applying it with the study collection (with a '-' after the name) could overwrite sheet data on the existing spreadsheet. 3) Supporting studies used in a custom spreadsheet study, applied with a study collection (with a '-' after the name) to a chart with existing studies, will not be in output columns that the formulas expect. The user must either move the studies (in the correct order) to the top of the Studies to Graph list, or edit the formulas. The new ID#.SG# referencing does not solve this (it is a handy feature otherwise). Date Time Of Last Edit: 2013-11-19 13:31:31