Support Board

Date/Time: Sun, 05 May 2024 01:40:35 +0000

Post From: Spreadsheet Cell Reference Updating Incorrectly During A Column Move

[2014-03-04 01:26:45] Link To Thread - Link To Post [Go To First Post]
Crazy_Bull - Posts: 17
I am surprised by your reply. Yes, defined names work and have since I started using Sierra Chart five years ago. Also, column move worked correctly a few revs back. So this is a degradation that's occurred in the last few months. I would have to do some digging to determine the last Sierra Chart version that worked for column moves, but it was not that long ago -- probably no more than three or four months. This is a SIGNIFICANT bug for ANYONE using the spreadsheet functionality. It is also a bug that should be easy to fix since the code is inadvertently modifying the reference in column n-1 rather than column n. So fundamentally is an indexing problem with the index being off by one. I certainly hope you approve fixing this bug. I have years of effort invested in my spreadsheet system and I would hate to have to port it to another platform. Regards, John Clark