Support Board
Date/Time: Mon, 25 Nov 2024 18:49:59 +0000
Spreadsheet Cell Reference Updating Incorrectly During A Column Move
View Count: 1177
| [2014-03-01 23:15:28] |
| Crazy_Bull - Posts: 17 |
|
Problem Desciption Moving any column # by cutting and pasting it, affects the addressing of column #-1 and fails to update the Defined Name reference. Steps to Reproduce the Problem Using the attached files: 1. Observe: a. The formula in column ZL references ZL$1 b. The formula in column ZM references ZM$1 c. Defined Name HL_TS_DB_T75 references “ES!$ZM3” 2. Select column ZM 3. Cut column ZM using Ctrl-X 4. Scroll left and select column XQ 5. Insert a blank column 6. Paste the Clipboard using Ctrl-V 7. Scroll right and select empty column ZN 8. Delete the empty column 9. Observe: a. The formula in column XQ has been correctly updated to reference XQ$1 b. The formula in column ZL has ALSO been updated to reference XQ$1 c. The Defined Name HL_TS_DB_T75 is “ES!!REF#” |
 Alert SS.scwbf - Attached On 2014-03-01 23:13:33 UTC - Size: 5.19 MB - 552 views Alert SC.cht - Attached On 2014-03-01 23:14:38 UTC - Size: 2.36 MB - 532 views |
| [2014-03-04 00:41:56] |
| |
|
We will look this over, when we are able to. However, we are no longer doing any further development on what are called the CLR spreadsheets. Formulas in the new non-CLR Spreadsheets will never be updated with cutting and pasting of spreadsheet data. Although they may indirectly be if internally they are held as relative references. So we would have to look into that. Also not sure if defined names are even supported . In any case those would not be updated either. 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-03-04 00:43:52
|
| [2014-03-04 01:26:45] |
| 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 |
| [2014-03-04 04:56:38] |
| Crazy_Bull - Posts: 17 |
|
Since the column move functionality had be working correctly for years, I suspect the bug was introduced when you all added the Number of Formula Columns functionality. I'll see if column move works correctly in the release prior to that assuming I can still get access to that release. |
| [2014-03-05 21:11:34] |
| |
|
There is all new spreadsheet functionality being developed in what is called our non-CLR version. We will consider what you are saying, but there are some design considerations to this. You may not also be aware of the separation between the Spreadsheet study and the Spreadsheet window component which operate independently from each other. And the Spreadsheet component in our main CLR release, is no longer under active development and we have no control over it. It will be discontinued by the end of the year and replaced by our new Spreadsheet functionality. We do not believe this has any relationship to the Number of Formula Columns input. That is completely separate from cutting and pasting on a spreadsheet. 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-03-05 21:12:43
|
| [2014-03-05 21:30:21] |
| Crazy_Bull - Posts: 17 |
|
The functionality in question is in the Spreadsheet Study. Sorry for not making this clear.
|
| [2014-03-05 21:32:38] |
| |
|
OK, we are going to be looking at this more closely later on. We just do not want to say what we will or will not do until we have a closer more comprehensive look through 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 Date Time Of Last Edit: 2014-03-05 21:33:34
|
To post a message in this thread, you need to log in with your Sierra Chart account: