Home >> Support Board

Support Board

Date/Time: Sun, 28 Apr 2024 05:20:54 +0000

How to Post a Message for Support

Bug in spreadsheet

View Count: 796

[2016-01-14 04:23:53] #1 [Go To First Post]
User266903 - Posts: 26
See attached. E21 = H23-H21 Now highlight row 20 by clicking on row header. Right click. Insert Row. Now E21 is E22. E22 should be = H24-H22, but it is not. It is still = H23-H21 Date Time Of Last Edit: 2016-01-14 04:26:55


buggy.scss - Attached On 2016-01-14 04:19:23 UTC - Size: 1.53 KB - 233 views

[2016-01-14 04:49:48] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We will have a look at this, but from what we see, this is probably a design decision how this currently works. So this would not be considered a bug but we will confirm that. It is not expected that Insert Rows is a frequently used operation with Sierra Chart 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

[2016-01-14 04:51:49] #3 [Go To First Post]
User266903 - Posts: 26
I am simply basing my expectation based on say, Excel. Not being able to add / delete rows would make it very hard to use for most people. as we can not anticipate in advance what we need and how it evolves over time. Thanks.

[2016-01-14 04:54:38] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
OK we are checking on this including to see what is involved to support 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

[2020-05-19 14:47:09] #5 [Go To First Post]
trading2themoon - Posts: 46
Any update on this? I have found that inserting rows does not behave as expected, I.e., the top rows are reset back to the usual 3 and I lose any formulas and changes made in row 2 and 3 as soon as the sheet updates.

[2020-05-19 14:51:08] #6 [Go To First Post]
User266903 - Posts: 26
It still blows my mind that Sierra just decided to dump Excel and replace it with whatever they got here. Like just give us DDE or RTD and let us users decide what to do with it. Date Time Of Last Edit: 2020-05-19 14:51:29

[2020-05-19 19:30:11] #7 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
We are not fully understanding post #5. What exactly are you doing? A screenshot will also help. And when using the Spreadsheet Study, row 2 contains Subgraph titles which are automatically set. Also refer to the documentation for this Input setting: Spreadsheet Study Inputs: Formula Source Sheet Number Post #6 is a misunderstanding of fact. Sierra Chart has always provided built-in spreadsheets, and Excel has always been secondary and very problematic. The interface that Excel provides is basically true garbage. And Sierra Chart has not provided any technical support for the Excel interface for something like 7+ years now. And Excel was never supported with the Spreadsheet System for Trading study. Removing support was the only thing that could be done. 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: 2020-05-19 19:37:26

[2020-05-19 20:01:16] #8 [Go To First Post]
trading2themoon - Posts: 46
And when using the Spreadsheet Study, row 2 contains Subgraph titles which are automatically set. Also refer to the documentation for this Input setting: Spreadsheet Study Inputs: Formula Source Sheet Number The input setting you refer to allows me to change the sheet number, but nothing about the row number for input. I'm dying to have another row above the data for notes and comments. Speaking of comments, is this supposed to be a way to add a custom header or description? There's no New Comment, only Edit Comment. I've also added comments but then lost them because they are hidden unless I pick the right cell and toggle Show Comment.

[2020-05-19 23:15:06] #9 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
No comments are not for a custom header or description. Here is the documentation for them: Spreadsheet Menu: Spreadsheet >> Edit Comment . I've also added comments but then lost them because they are hidden unless I pick the right cell and toggle Show Comment. There is a marker at the lower left of the cell indicating there is a comment. The color can be change to something more bright and noticeable. 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

[2020-05-20 21:25:33] #10 [Go To First Post]
trading2themoon - Posts: 46
Thanks. So where would you post notes, descriptions and additional information in the spreadsheets?

[2020-05-20 21:30:34] #11 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
Well that is what Comments are for. But it is not meant to be creating a custom header but thinking about you could effectively do that by enabling the option to show the comment in the cell which makes it visible like the value of the cell. 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: