[Libreoffice-ux-advise] [Bug 127738] calc settings should be more user friendly - expand references should be enabled

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127738

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
Probably something like values in A1:A3 and in A4 have =SUM(A1:A3), then insert
a row above 4 making it new row 4 and shifting A4 down to A5; what may be
expected here is that the formula reference gets adjusted to =SUM(A1:A4) to
include the new cell of the inserted row.

Which happens if "expand references" is on (Tools -> Options -> Calc ->
General). However, having that option on by default is not a good idea because
it acts on any edge, top, left, right and bottom, and all range references
anywhere referencing those, which may come unexpected.

What might be useful could be to detect the special case of formula cells
immediately at the insertion position referencing the cell range directly above
and adjust those. But then again other formula expressions elsewhere might be
out of sync, so that isn't a good idea either. Maybe a restricting second
"expand only bottom references" option (radio button none|bottom|alledges) for
the common case where one wants to append new data.

Btw, sorting is completely off-topic in this context.

-- 
You are receiving this mail because:
You are on the CC list for the bug.