[Libreoffice-bugs] [Bug 113896] New: EDITING: Formula should be extended to a newly inserted row/column

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 113896
           Summary: EDITING: Formula should be extended to a newly
                    inserted row/column
           Product: LibreOffice
           Version: 6.0.0.0.alpha1+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: thomas.lendo at gmail.com

Formulas should be automatically extended to newly inserted rows/columns at the
beginning or end (for example if the cell where the action is done is within
the formula cell range).

STR/example with SUM:
1. A1: cell content "1"
2. A2: cell content "2"
3. A3: cell content "3"
4. A4: cell content "=SUM(A1:A3)"
5. Right-click on row header of row 3.
6. Select "Insert Rows Below".

Current result:
Cell content of A5 (formerly A4) still is "=SUM(A1:A3)".

Expected result:
Cell content of A5 should be "=SUM(A1:A4)".

The automatic adjustment of the SUM formula would prevent the user to do it by
himself/herself. I assume that the user want to have A4 added to SUM.

It's questionable under which circumstances the formula should be adjusted
automatically:

* If the cell where the action is done is within the formula cell range. This
would extend the formula to newly created A1 if the user clicks "Insert Row
Above" in row 1 and this would behave also as described in the example above.

* If the cell which is inserted is between SUM cell and its summed cells (in
the example above: A1-A3). This would extend the formula to A4 if the user
clicks "Insert Rows Above" in row 4. Would this also extend the formula to
newly created A1 if the user clicks "Insert Row Above" in row 1?

And is this technically distinguishable?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171117/4814020a/attachment.html>