Support Board
Date/Time: Tue, 13 May 2025 13:39:59 +0000
Post From: Spreadsheetsystemfortrading - referencing ranges
| [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 |