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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Andreas Säger <villeroy at t-online.de> ---

> with AOO 4.1.5 and "[x] expand references":
> - select row 12
> - context menu: insert row
> -> formula in B11 changes from =SUM($A$6:A11) to =SUM($A$6:A12)
> 

The formula does not calculate the running total anymore. The meaning of this
single formula in B11 has changed. It does not sum up the other column until
the same row.
The R1C1 notation shows this more clearly.

> btw: excel suggest using: =SUM(INDIRECT("A6:A"&ROW()))

https://support.office.com/en-us/article/Calculate-a-running-total-in-Excel-1359BF89-180B-4771-B5B4-C6F6558549C5
describes the proceeding with normal formulas, cell insertion and formula copy.

I have to assume that Excel does not modify the existing formula because this
would mix wrong formulas into the calculated field. 
And OpenOffice still shows the correct behaviour where certain references do
NOT expand. At the moment I have difficulties describing a rule for this. The
old source code should explain it better than I can right now. It could be that
references adjacent to the inserted cells and in the opposite direction to the
move direction remain untouched but I'm not sure.

-- 
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/20191117/fc2bd936/attachment.html>