Support Board
Date/Time: Wed, 27 Nov 2024 14:20:32 +0000
Post From: Problem with formulas in spreadsheet after duplicating chart
| [2023-08-09 14:16:49] |
| John - SC Support - Posts: 36310 |
|
There is no bug here. You have to keep in mind how the system handles the sheet numbering and the formula sheets. In particular, when you duplicated the chart, the new chart number created a new sheet within the Spreadsheet Study (say you had Chart #1 originally, which would have Sheet1 in the Spreadsheet Study, then when you duplicate the chart to Chart #2, that chart would be associated with Sheet2 in the Spreadsheet study). But, the Formula sheet does not change. Therefore, the formula sheet stays as Sheet1. When you then change the name of the spreadsheet study, that formula sheet is now blank. Since the main sheet is referencing a different formula sheet, the columns do not automatically fill-in. Yes, this is complicated, but it allows for more power with the spreadsheets by allowing you to have a single formula source for multiple sheets. Refer to the information here: Spreadsheet Study Inputs: Formula Source Sheet Number For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |