Support Board
Date/Time: Wed, 27 Nov 2024 22:40:26 +0000
[User Discussion] - Cell Referance
View Count: 967
| [2014-10-16 19:38:03] |
| User20702 - Posts: 13 |
|
How do you reference a cell in a different spreadsheet, that is in the same chartbook? IE: =Q3 from 2nd spreadsheet. Thanks Dave |
| [2014-10-16 21:10:18] |
| Sawtooth - Posts: 4120 |
|
Press = in the destination cell, then focus the source cell in the other spreadsheet and press Enter. It will look like this in the destination cell: ='[Source.scwbf]Sheet1'!$Q$3 You can then remove the $ absolute references, if needed. BTW, you cannot do this with the New Spreadsheets. Date Time Of Last Edit: 2014-10-16 21:11:52
|
| [2014-10-16 21:19:52] |
| |
|
Do you want to reference another Sheet within the same Spreadsheet window or a completely separate Spreadsheet window? We do not recommend references between Spreadsheets when using Old Spreadsheets because those are no longer supported with New Spreadsheets. This is an unsupported feature we will not help with. 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 |
| [2014-10-17 00:25:17] |
| User20702 - Posts: 13 |
|
Thanks Tom I am working with the new spreadsheet, so I need the same information you gave except for the new spreadsheets. Is there more documentation yet on the new spreadsheet? Thanks again Dave |
| [2014-10-17 00:50:49] |
| Sawtooth - Posts: 4120 |
|
You cannot reference another spreadsheet in the New Spreadsheets, but you can reference a cell on another sheet in the same spreadsheet, but you have to type it out: =Sheet2!Q3 Date Time Of Last Edit: 2014-10-17 00:51:00
|
| [2014-10-17 02:31:02] |
| |
|
Refer to the documentation here for cell references: https://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#CellandRangeReferences 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: