Support Board

Date/Time: Sun, 05 May 2024 04:20:02 +0000

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

[2014-03-01 23:15:28] Link To Thread - Link To Post [Go To First Post]
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 - 381 views Alert SC.cht - Attached On 2014-03-01 23:14:38 UTC - Size: 2.36 MB - 368 views