GNOME Bugzilla – Bug 350222
Unexpected change of range-reference upon cut-and-paste
Last modified: 2006-10-17 02:28:37 UTC
Steps to reproduce: 1. A1 = '1' 2. A2 = '=sum($A$1:A1)' 3. cut A2 and paste B2 Expected result: B2 = '=sum($A$1:A1)' Actual result: B2 = '=sum(A$1:$A1)' If it is pasted at A2, B2 changes to '=sum($A1:A$1)' instead. This bug exists in both 1.6.3 and 1.7.
>>If it is pasted at A2, B2 changes to '=sum($A1:A$1)' instead. Sorry for typo, this case is for pasting at A3.
I can confirm this under Linux too.
ahh, I see. The inversion check was being done relative to the source position rather than the destination. Which produced a false positive when comparing relative to absolute ref. Patch is in 1.7.2