Support Board
Date/Time: Mon, 25 Nov 2024 21:19:35 +0000
Post From: Spreadsheet Cell Reference Updating Incorrectly During A Column Move
| [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 |