https://bugs.documentfoundation.org/show_bug.cgi?id=173213
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- OS|Windows (All) |All Version|26.2.5.2 release |7.4.6.2 release Summary|Formula somewhere else |Copy paste or dragging |changes when unrelated |"relative:absolute" |cells are moved |references, pastes | |incorrect reference type in | |destination area (STR | |comment 4) Severity|normal |major CC| |[email protected], | |[email protected], | |[email protected] --- Comment #4 from ady <[email protected]> --- I am about to describe a minimal simple case of this bug (that affects LO and also related suites). This is a serious regression bug. In some sense, this could potentially be considered as 2 bugs in one, with 2 different levels of importance. STR: 1. Start a new spreadsheet file. 2. Cell A1: 1 3. Cell A2: 2 Please note that cell A3 is empty; do not add more values down the list, because the resulting behavior would end up being slightly different, thus hiding the more-serious bug. 4. Cell B1: =SUM(A1:$A$1) Please note that the start of the range uses relative references, and the end of the range uses absolute references. Also note that the start and the end of the range is pointing to the same cell at this time, although with relative vs absolute references. 5. Using the fill handle on cell B1 (i.e. the bottom-right corner of cell B1), drag it one row down, so as to cover the range B1:B2. At first glance, the following "Expected result" vs "Actual result" difference seems to be a minor display issue, but it is more than that: Expected result: Cell B2 should had been B2: =SUM($A$1:A2) Actual result: B2: =SUM(A$1:$A2) Please note the location of the two "$" symbols that indicate the absolute references in cell B2. Although the range is still "A1:A2", the impact of the relative vs absolute references (partial row in the starting address, partial column in the ending address) is a very serious bug. Also note that instead of dragging the fill handle, a simple copy+paste (from cell B1 to cell B2) also shows the same issue. Now, if the dragging (or copy+paste) destination area is more than one cell (e.g. cells B1:B10), the resulting references are different. In that case, cell B2 would end up being: B2: =SUM(A2:$A$1) which is still not the expected =SUM($A$1:A2), but the "$" symbols are positioned differently than what happened with only one destination cell. A similar problem can be also replicated horizontally: A10: 1 B10: 2 A11: =SUM(A10:$A$10) resulting B11: =SUM($A10:B$10) I have not tested other mixing cases of partial absolute references, but I would guess that similar issues can be observed. Back to the vertical case, the less-serious problem, B2: =SUM(A2:$A$1) – instead of the expected B2: =SUM($A$1:A2) – can also be reproduced in LO 3.3, and in AOO 4.1.16. The more-serious problem, B2: =SUM(A$1:$A2), can (only) be reproduced in later versions of LO (e.g. 7.4), but not in LO 3.3. BTW, this affects Collabora too. -- You are receiving this mail because: You are the assignee for the bug.
