Home >> Support Board

Support Board

Date/Time: Tue, 30 Apr 2024 05:37:08 +0000

How to Post a Message for Support

New SC spreadsheet functionality

View Count: 1271

[2014-06-29 07:06:17] #1 [Go To First Post]
tobi - Posts: 351
If I understand correctly, the Non-.NET/CLR version of SC is soon going to be the main release. Therefore I'm testing this version, especially the new spreadsheet functionality at the moment. My experience with the new spreadsheet functionality has been very disappointing so far! Here are a few questions/comments: - Isn't it possible to use the same Chart Data Output Sheet Number and Formula Source Sheet Number in different spreadsheet studies in the same chart? If I try this, SC crashes (gets closed w/o waring). In the old system this could be done w/o problems. - I understand, that the formulas are not "converted" from the old to the new system when opening a chartbook with spreadsheet studies created with the old system and opening it in the Non-CLR verion. If I copy the formulas "by hand" though, SC often times crashes (especially with long formulas). Are you aware of these things? Will they be resolved? Is it reasonable to already test the new system, since obviously there are still some major problems (in the spreadsheet functionality)? If these can not be resolved in a satisfying way, how long will the old system (CLR version) be supported and updated? Thank you, Tobi

[2014-06-29 07:32:41] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Not to worry. - Isn't it possible to use the same Chart Data Output Sheet Number and Formula Source Sheet Number in different spreadsheet studies in the same chart? If I try this, SC crashes (gets closed w/o waring). In the old system this could be done w/o problems. We will fix this. - I understand, that the formulas are not "converted" from the old to the new system when opening a chartbook with spreadsheet studies created with the old system and opening it in the Non-CLR verion. Soon we will be adding support to copy formulas from the old CLR spreadsheets to the new spreadsheets. If I copy the formulas "by hand" though, SC often times crashes (especially with long formulas). We will solve this. This kind of problem is totally unacceptable and we were not aware of this. Can you give us a step-by-step procedure to reproduce. Or just post the particular long formula you are using so we can test it. The soonest we get this problem reproduced, the sooner we can resolve it. Are you aware of these things? Will they be resolved? No and Yes. We have very high standards and these problems are completely unacceptable. They will be immediately resolved. Is it reasonable to already test the new system, since obviously there are still some major problems (in the spreadsheet functionality)? Yes it is. We will resolve these problems. 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-06-29 07:34:51

[2014-06-29 21:30:26] #3 [Go To First Post]
tobi - Posts: 351
Thank you for your detailed answers and your willingness to get this fixed quickly! I've attached an example chartbook in the old version (test.cht and test.scwbf) and in the new version (test-nonCLR.cht and test-nonCLR.scss). E.g. when you try to copy the formula in Sheet2, column K from the old version spreadsheet to the Non-CLR version spreadsheet, SC crashes. Too, when I try to add another spreadsheet study, also with Chart Data Output Sheet Number 2 and Formula Source Sheet Number 2 in the Non-CLR version, SC crashes. Hope this helps to figure out the mistakes.


Private File Private File Private File Private File

[2014-06-30 06:32:03] #4 [Go To First Post]
tobi - Posts: 351
Could you please leave a short note here, when these things are fixed. Thank you.

[2014-06-30 06:55:29] #5 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Yes. 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

[2014-07-03 05:17:44] #6 [Go To First Post]
tobi - Posts: 351
Have the issues described above been fixed in Non-.NET/CLR version 1155 or 1156?

[2014-07-03 05:34:32] #7 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Yes. But there are some performance improvements we want to work on based on the formulas you are using and we have not done those yet. However, the abnormal shutdown problems have been resolved. 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

[2014-07-03 05:44:12] #8 [Go To First Post]
tobi - Posts: 351
Ok, I see it's working fine now. Thank you for fixing it! Does it make sense to use/work with this version already or would you recommend to wait until you have finished the performance improvements?

[2014-07-03 06:27:48] #9 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Yes, it does make sense to use that version. 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

[2014-07-03 10:13:07] #10 [Go To First Post]
tobi - Posts: 351
I've discovered a little issue. Please see the attached chartbook and spreadsheet. Sometimes, in the Sheets 2, 5, 8 and/or 11, I get a #VALUE! message in cells K3, K4 and/or L3, L4 (and corresponding in cells M till Q). This seems to have to do with the cells W3, W4 and/or X3, X4. Hope you can figure out what is causing this!? As additional information, please see the attached screenshot for my Spreadsheet Settings. Please let me know here about further steps. Thank you! Date Time Of Last Edit: 2014-07-03 10:14:15


Private File Private File spreadsheet settings.png / V - Attached On 2014-07-03 10:11:50 UTC - Size: 12.38 KB - 330 views

[2014-07-04 03:36:01] #11 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We will look into this. 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: