[Libreoffice-bugs] [Bug 128846] Inconsistent behaviour of option "Expand References..."
https://bugs.documentfoundation.org/show_bug.cgi?id=128846 Oliver Brinzing changed: What|Removed |Added Resolution|--- |WORKSFORME CC||er...@redhat.com Status|UNCONFIRMED |RESOLVED --- Comment #6 from Oliver Brinzing --- (In reply to Andreas Säger from comment #5) > Please mark this as invalid or enhancement request? I don't know. > Totally confused sincerely yours, > Andreas ok, setting to WFM I don't think, it's possible to distinguish between formulas which should expand or not expand if "expand references" is enabled. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128846] Inconsistent behaviour of option "Expand References..."
https://bugs.documentfoundation.org/show_bug.cgi?id=128846 --- Comment #5 from Andreas Säger --- Please mark this as invalid or enhancement request? I don't know. Totally confused sincerely yours, Andreas -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128846] Inconsistent behaviour of option "Expand References..."
https://bugs.documentfoundation.org/show_bug.cgi?id=128846 --- Comment #4 from Oliver Brinzing --- Created attachment 155898 --> https://bugs.documentfoundation.org/attachment.cgi?id=155898=edit screenshots from aoo415 with expand referenced enabled -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128846] Inconsistent behaviour of option "Expand References..."
https://bugs.documentfoundation.org/show_bug.cgi?id=128846
--- Comment #3 from Andreas Säger ---
> 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"()))
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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128846] Inconsistent behaviour of option "Expand References..."
https://bugs.documentfoundation.org/show_bug.cgi?id=128846
Oliver Brinzing changed:
What|Removed |Added
CC||oliver.brinz...@gmx.de
--- Comment #2 from Oliver Brinzing ---
Created attachment 155888
--> https://bugs.documentfoundation.org/attachment.cgi?id=155888=edit
excel spreadsheet
(In reply to Andreas Säger from comment #0)
> 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.
correct: =SUM($B$6:$B$11) expands to =SUM($B$6:$B$12)
> Formula in B11 =SUM($A$6:A11) becomes =SUM($A6:A12) although the cell B11
> does not move. However, the adjacent calculated field should not change.
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)
i cannot see a difference?
btw: excel suggest using: =SUM(INDIRECT("A6:A"()))
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128846] Inconsistent behaviour of option "Expand References..."
https://bugs.documentfoundation.org/show_bug.cgi?id=128846 --- Comment #1 from Andreas Säger --- Created attachment 155885 --> https://bugs.documentfoundation.org/attachment.cgi?id=155885=edit Spreadsheet with total and a calculated field of running totals. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
