https://bugs.documentfoundation.org/show_bug.cgi?id=107779
--- Comment #23 from Eike Rathke <[email protected]> --- Clearly sort always sorts, regardless of the option.. but if and how the references are adjusted is exactly the point of that option, which was introduced at some time because people don't agree what a sort should actually do with references. If unchecked, references are not touched, so relative references still point to the same relative positions if their formula cell moved, i.e. to within the same sorted row stay on that row after the sort. If checked, references pointing (partially) outside of the sorted area are adjusted to still point to the original range, which for relative references *changes* (hence updates) the reference. The behaviour the bug submitter wants is the option *unchecked* (which is the default), i.e. after the sort on row 1 there's =SUM(C1:E1) and then all works as expected. However, with the option checked the current behaviour comes to a surprise because the sort range is shrunk to the actual used area and thus the formula points outside. Shrinking is done because sorting empty areas (no data and no attribution) is superfluous and sorting those areas as well would just slow down things significantly. This is especially important *because* people hit Ctrl+A select all or select entire rows or columns to sort an actually smaller range. In case the option is checked, shrinking the sort range must take references in formula cells into account, if they point to within the selected area but outside the used area, then stop shrinking there if so to have the references adjusted (or rather not adjusted) as expected. -- You are receiving this mail because: You are the assignee for the bug.
