https://bugs.documentfoundation.org/show_bug.cgi?id=173213
--- Comment #11 from ady <[email protected]> --- Created attachment 208576 --> https://bugs.documentfoundation.org/attachment.cgi?id=208576&action=edit tdf 173213 Simplified test spreadsheet and STR Since the subtleties of the initial status and the procedure / STR seem to be trickier to explain than what I thought, I am attaching a very simple spreadsheet with very simple instructions (i.e. 1 step). The STR with this attachment is: 1. Use the fill handle from cell B1 in order to drag (aka copy+paste) to cell B2 (and only to cell B2, not to be extended further down). I created the sample spreadsheet with LO 3.3.0.4. The actual results on each version I tested this is as follows (on cell B2, and only cell B2, with cell B3 and down being empty, untouched): LO 3.3.0.4 : =SUM(A2:$A$1) LO 4.4.7.0 : =SUM(A$1:$A2) > Already an incorrect mix of references! LO 5.0.6.3 : =SUM(A$1:$A2) LO 5.1.0.3 : =SUM(A$1:$A2) LODev 27.2 : =SUM(A$1:$A2) There are 2 key factors in order to reproduce the issue: A._ The initial formula in cell B1 uses infrequent references: =SUM(A1:$A$1) B._ The dragging (or copy+paste) action extends _only_ one row, not more than one row (but it can be replicated horizontally, towards one column instead). Please try to reproduce the issue with this new attachment and STR, with older versions. -- You are receiving this mail because: You are the assignee for the bug.
