Home >> Support Board

Support Board

Date/Time: Mon, 06 May 2024 15:57:10 +0000

How to Post a Message for Support

Conversion to Non-CLR Spreadsheets

View Count: 1496

[2014-08-14 17:02:38] #1 [Go To First Post]
user58907 - Posts: 83
I think we need detailed instructions on how to convert. Examples, =text(a3,"dd-mm-yy") returns #NAME? =$A$22+TIME(C17,D17,0) returns #VALUE! Can't start debugging the SYNTAX and ARGS msgs as they are dependent on these. No issues with these in CLR. Also, what about referencing cells that do not have a SG number? Eg I have a Summary sheet with computed values I want to pull over to another sheet, there is no SG. And if at all possible, could we have tabs for the sheets as in CLR? The dropdown to switch is tedious when a lot of switching back and forth is required. Also, there seems to be an issue with shutting down the converted spreadsheet, got a SC is not responding message. Also switching from charts to sheets it does hang a couple of times. I've reinstalled CLR meantime.

[2014-08-14 18:19:37] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
=text(a3,"dd-mm-yy") returns #NAME? The TEXT function is not supported in the non-CLR version. =$A$22+TIME(C17,D17,0) returns #VALUE! Refer to this section here: https://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#SpreadsheetErrorCodes Also, what about referencing cells that do not have a SG number? Eg I have a Summary sheet with computed values I want to pull over to another sheet, there is no SG. You just need to use standard cell references. This is all. Also, there seems to be an issue with shutting down the converted spreadsheet, got a SC is not responding message. This is the result of Sierra Chart compressing and writing the spreadsheet to a file. If you wait long enough, the writing of the file will be complete. You must have a very large spreadsheet. Also switching from charts to sheets it does hang a couple of times. This is the result of a performance issue with Sierra Chart handling your spreadsheet. We are working on improving performance. In some cases performance is better than the old CLR spreadsheets, but in some cases it is not. You can privately attach your spreadsheet here so we can do some testing of it. Follow these instructions here: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile 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 Date Time Of Last Edit: 2014-08-18 17:01:10

[2014-08-14 18:39:58] #3 [Go To First Post]
user58907 - Posts: 83
Will upload after the close. Re not supported, I referred to the page on New Non-CLR Spreadsheet Function Limitations and TEXT is listed as supported. I went the roundabout route converting to Text because of the issue with Date+Time storage and comparisons - it's been a long time since but I think it's about floating point numbers. Basically, I need to extract output values from studies like ATR for specific times and dates. Any suggestions for this with Non-CLR? http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetFunctions.html#NonCLRFunctions

[2014-08-14 19:20:45] #4 [Go To First Post]
Sawtooth - Posts: 3993
This is what I use to remove floating point inaccuracies of the SerialDateTime: =MROUND(A3,1/86400) This will round the SerialDateTime to the second. MROUND is not listed in the non-CLR functions, but it works in the non-CLR spreadsheet.

[2014-08-14 19:22:26] #5 [Go To First Post]
user58907 - Posts: 83
Thanks Tom.

[2014-08-14 21:59:16] #6 [Go To First Post]
user58907 - Posts: 83
This is the spreadsheet file as requested. It is the one I tested with the conversion, and is actually one of the smaller ones as I didn't want to test the larger ones right off. On average 60% to double the size of this.


Private File

[2014-08-18 17:10:57] #7 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
The spreadsheet function TEXT has been removed from the documentation and MROUND has been added. We will be testing the spreadsheet given in post #6. For now use the version of Sierra Chart with Old Spreadsheets. 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 Date Time Of Last Edit: 2014-08-18 17:11:29

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