Date/Time: Thu, 21 Oct 2021 14:06:42 +0000
Post From: References Between Spreadsheets
Sierra Chart Engineering - Posts: 98266
We have been developing our own new high-performance spreadsheet functionality in Sierra Chart. This is going to replace the .NET spreadsheet component we currently use.
One thing that the new spreadsheet functionality we are developing does not have, is the ability to reference between spreadsheet windows.
Now we know some of you are using this kind of functionality, but really there should be an alternative way for you to accomplish what you want by putting all of the data into a single spreadsheet window just using the available Sheets. When using the Spreadsheet Studies, you do have the ability to output the data to any sheet within a Spreadsheet. There is the Chart Data Output Sheet Number input for this. By doing this, you can output all of the data to a single Spreadsheet and use whatever references you need between the different sheets. This is the preferred way.
We have a help topic that explains creating a table of Study Values and we are going to update it to use this new suggested method.
For those of you are making references between different Spreadsheets, we want to understand why you are doing this, and suggest alternatives. Because it is a much more solid solution for you to make references within a particular Spreadsheet among the Sheets. References outside of a Spreadsheet window just inherently get complex and there is not a proper calculation order and it should be avoided.
So therefore, we feel the best solution, is to work on solid alternatives that users will have to migrate to rather than relying on references between Spreadsheets. We believe alternatives are reasonable and should be implemented. And for those, who just do not want to implement alternative, or find it very very difficult, We will see how best to help you, or we would suggest that you just continue to use an older version of Sierra Chart when the new version comes out that supports the new spreadsheet functionality.
Sierra Chart Support - Engineering Level
Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2013-06-05 22:10:43