Login Page - Create Account

Support Board


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



Post From: References to Other Sheets within a Spreadsheet and different Spreadsheet windows

[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.