https://bugs.documentfoundation.org/show_bug.cgi?id=173213
--- Comment #6 from ady <[email protected]> --- (In reply to m_a_riosv from comment #5) > When I enter =SUM(A2:$A$1) in a cell it changes to =SUM($A$1:A2) > automatically at intro, even pasting it. That is why I started with a same-cell range, as in =SUM(A1:$A$1), and I specifically wrote that in comment 4. We are used to use the starting cell with absolute references and the second with relative references. Imagine a case in which you accidentally change (to absolute) the ending cell instead of the starting one, or if you type-in the formula, maybe by mistake (typo). Since the range is the same cell, there is no automatic re-ordering. That is the less-serious part of the issue. The really problematic issue is the paste, with incorrect mixed positions of the "$" symbols when the paste is on one cell, as described in comment 4; that, is a regression (IDK since which version, but at least since 7.4). Both issues should be improved/resolved, but the more-serious problem is particularly problematic. -- You are receiving this mail because: You are the assignee for the bug.
