Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 21:20:27 +0000



References to Other Sheets within a Spreadsheet and different Spreadsheet windows

View Count: 1309

[2013-11-27 14:35:30]
User61342 - Posts: 2
hello

i read this on your web site
(see below )
now i use
References to Other Sheets within a Spreadsheet and different Spreadsheet windows

i write in a cell
for exemple
='[EUR IND FX.scwbf]IND EUR FX'!$AF$9
it works well

you said
In approximately July 2013, Sierra Chart will be releasing new high-performance spreadsheet functionality which will not support references between different Spreadsheet windows.

but now it works well

will you stop this posibility LATER ?
because now i would like to create multiple spreadsheet with crossed reference
and would like to know if i will be able to use my spreadsheets later with next SIERRA CHART Version


thank you



-----------------------------------------------------------
References to Other Sheets within a Spreadsheet
[link] - [Top]

Sierra Chart Spreadsheets support references to cells in other Sheets within the same Spreadsheet window. To reference cells in a particular Sheet in the same Spreadsheet, use the following format. Remember that references are used in formulas and formulas begin with an =.

Format: SheetName!CellReference
Examples:

=Sheet1!A1
References to Other Spreadsheets Windows

References between Sheets among different Spreadsheet windows are not officially supported. In approximately July 2013, Sierra Chart will be releasing new high-performance spreadsheet functionality which will not support references between different Spreadsheet windows.

[2013-12-01 20:48:37]
Sierra Chart Engineering - Posts: 104368
We have been delayed with officially releasing the new spreadsheet functionality.

The new spreadsheets are in our non-CLR version of Sierra Chart . The new spreadsheets in the non-CLR version do not support references between Spreadsheet windows. Only among the different Sheets within a Spreadsheet.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account