Support Board
Date/Time: Wed, 27 Nov 2024 10:36:11 +0000
Post From: Conversion to Non-CLR Spreadsheets
| [2014-08-14 18:19:37] |
| |
|
=text(a3,"dd-mm-yy") returns #NAME? =$A$22+TIME(C17,D17,0) returns #VALUE! 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. 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
|