Home >> Support Board

Support Board

Date/Time: Sun, 19 May 2024 04:55:43 +0000

How to Post a Message for Support

Post From: Conversion to Non-CLR Spreadsheets

[2014-08-14 18:19:37] Link To Thread - Link To Post [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