https://bugs.freedesktop.org/show_bug.cgi?id=55603
--- Comment #2 from Mariano <[email protected]> --- Because it's used to be the meaning of absolute reference: if you copy the cell, the absolute reference (in this case the "$A" column) must to be unchanged. If it was a new feature it was a major change and then, how can we call this feature? Absolute references that sometimes -exactly when it refers to the original cell- are relative references? If the user write the "$" it's because it wants an absolute reference, not a relative. Please note this: the result it's different if you change the formula. For example, if I change the B1 cell, so it contains what I want: B1: =COLUMN()-COLUMN($A1) [results 1] and the copy and paste B1 cell to C1, D1, etc., now the result it's the expected: C1: =COLUMN()-COLUMN($A1) [results 2] D1: =COLUMN()-COLUMN($A1) [results 3] It results, that the same formula "=COLUMN()-COLUMN($A1)" paste of different form if it's copy from A1 cell that it's copy from B1 cell: . Copy from A1 and paste to C1 results "=COLUMN()-COLUMN($C1)" . Copy from B1 and paste to C1 results "=COLUMN()-COLUMN($A1)" It seems more a bug like a new feature. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
