Support Board
Date/Time: Sun, 11 May 2025 19:51:28 +0000
Spreadsheetsystemfortrading - referencing ranges
View Count: 705
| [2016-03-06 20:33:44] |
| User553714 - Posts: 184 |
|
Hi, 1) I was trying to work out how "References to Other Sheets within a Spreadsheet" work, in standard excel format "=sum(Sheet1!E3:E6)" in SC brings up a "#REF!" error? This seems to be the formatting suggested by the documentation but a range example isn't specifically given; http://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#ReferencesOtherSheets After playing around with the formatting "=sum(Sheet1!E3:Sheet1!E6)" seems to be the format supporting by SC? Is this correct and is this double referencing of the cell range in different sheets supported by all the functions in SC? Is it safe to use this formatting? Wouldn't be better to allow the standard excel formatting? Either way can you please update the documentation. 2) Also, I don't think the functionality referenced for true/false is supported anymore? http://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#TrueAndFalseValues Regards |
| [2016-03-07 20:21:09] |
| |
|
We are checking on these.
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 |
| [2016-03-16 08:56:42] |
| User553714 - Posts: 184 |
|
Hi, I did you get a chance to look at this, I don't think the behaviour has changed in SC 1380. REgards |
| [2016-03-16 16:57:10] |
| |
|
1. We will be working on this, this week. 2. This is now done. 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: