Support Board
Date/Time: Sun, 24 Nov 2024 21:03:40 +0000
Post From: Spreadsheets Are Often Maddening
| [2024-05-02 12:01:49] |
| Sawtooth - Posts: 4120 |
|
I don't want to duplicate the chart, I want to duplicate only the spreadsheet.
Then create a Study Collection of only the spreadsheet study, and apply it to the new chart.However, you may need to change the name of the spreadsheet. - If you want the same settings, and use the same formulas on another chart in the same chartbook, you would just dupe the original chart. A new sheet will be created whose number matches the new chart's number. The Formula Source Sheet Number will be the same but you'll need to change the symbol. If you don't change the symbol, they could interact and cause undesired issues. - If the new chart is in the same chartbook, and you are using different formulas than the original, change its Formula Source Sheet Number to match the new chart#. - If you want the same settings, and use the same formulas on another chart that is not in the same chartbook, the new spreadsheet file should have a unique name. If both chartbooks are open at the same time, using the same-named spreadsheet, the formulas could interact causing unwanted issues. In summary: - By default, the Sheet# matches the Chart#. - The Formula Source Sheet Number setting is a critical setting. - The spreadsheet of the same formulas needs a unique name if simultaneously used in another chartbook. |