[Libreoffice-bugs] [Bug 128846] New: Inconsistent behaviour of option "Expand References..."

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 128846
           Summary: Inconsistent behaviour of option "Expand
                    References..."
           Product: LibreOffice
           Version: 6.0 all versions
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: villeroy at t-online.de

The following used to be the correct behaviour since the beginning of
OpenOffice.org:
WITHOUT option "Expand References"
-- any insertion at the first row of the referenced range shifts down the
reference.
-- any insertion directly below the referenced just inserts cells _below_ the
reference without affecting the reference.

WITH option "Expand References"
-- any insertion at the first row of the referenced range expands the
reference.
-- any insertion directly below the referenced expands the reference.

In both cases any insertion between row #2 and the last row expands the
reference.
###########################################################################
So far LibreOffice behaves consistently, nevertheless some flaw has been
introduced in version 6, may be earlier.
OpenOffice used to preserve the formulas adjacent to the inserted cells whereas
LibreOffice consequently expands all references which flaws some calculated
fields such as running totals.
In the attached document, the last reference of the running total expands
beyond the current row if "Expand References" is set.
Formula in B11 =SUM($A$6:A11) becomes =SUM($A6:A12) although the cell B11 does
not move.
The not adjacent formula cell in B2 which calculates the overall
=SUM($A$6:$A$11) expands to =SUM($A$6:$A$12) which is perfectly wanted
behaviour. However, the adjacent calculated field should not change.
This becomes more apparent when you turn on the R1C1 formula view. The  entire
calculated field is calculated as =SUM(R6C1:RC[-1]) describing the sum from
absolute Row6,Col1 until THIS row, previous column. 
After inserting a new row, the last formula changes to  =SUM(R6C1:R[1]C[-1])
describing the sum from absolute Row6,Col1 until NEXT row,previous column.

-- 
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/20191116/0f55d28b/attachment-0001.html>