Login Page - Create Account

Support Board


Date/Time: Thu, 26 Dec 2024 12:30:13 +0000



Spreadsheets Insert Row or Insert Column issue

View Count: 665

[2016-02-18 16:11:46]
Sawtooth - Posts: 4143
If a spreadsheet sheet is added with Spreadsheet >> Add Sheet, references to/from a chart's sheet move in the opposite direction of the added row or column.

See attached test spreadsheet.

To replicate when inserting a column:
-On the Control sheet, highlight column C, and Insert Column.
-Go to Sheet2, and focus cell J26. It shows =Control!B3 when it should be =Control!D3
-To undo, on the Control sheet, highlight column C, and Delete Column.

To replicate when inserting a row:
-On the Control sheet, highlight row 3, and Insert Row.
-Go to Sheet1, and focus cell J26. It shows =Control!B2 when it should be =Control!B4
Date Time Of Last Edit: 2016-12-05 03:14:58
attachmentInsert test.scss - Attached On 2016-02-18 16:10:07 UTC - Size: 68.79 KB - 327 views
[2016-02-18 17:21:01]
Sierra Chart Engineering - Posts: 104368
We will be looking 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:

Login

Login Page - Create Account