Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Fri, 27 Dec 2024 01:52:47 +0000

Post From: Spreadsheets Insert Row or Insert Column issue

[2016-02-18 16:11:46] Link To Thread - Link To Post [Go To First Post]
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
0x Thank you
Insert test.scss - Attached On 2016-02-18 16:10:07 UTC - Size: 68.79 KB - 327 views