https://bugs.documentfoundation.org/show_bug.cgi?id=106051
Bug ID: 106051
Summary: recalculate does not always work (simple sum
operation)
Product: LibreOffice
Version: 5.3.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: monique.mes...@gmail.com
Description:
I attach an example file but you can build your own. Reproducible every time
for me. A sum depending on cells themselves sum does not recalculate, when
defined from a dragged formula.
Steps to Reproduce:
1. Put random numbers in a corner - in the example A1 to C4.
2. Below the first column, calculate the sum then drag right to do the same for
all columns (cells A5-D5)
3. Right of the first line, calculate the line sum then drag down to do the
same for all lines including the last, "summed" line (cells D1-D5). I get 182
in D5.
4. Just below, copy exactly D5 ie "=SUM(A5:C5)". I get 182 too.
(or replace steps 1-4 by opening the attached spreadsheet)
5. Select a line (eg 3) and hit "delete". Cells in line 3 are now empty.
Actual Results:
Totals recalculate EXCEPT for cell D5 (who depends on A5-C5), staying at 182.
F9 solves the problem. Interestingly enough cell D6 (that was manually edited
instead of dragging the formulas down) works just fine, updating to 132.
Also interestingly, inserting an empty line between lines 4 & 5 prior to
deleting line 3 makes it work correctly.
Expected Results:
Both cells D5 & D6 should recalculate when deleting a line above - only D6
does.
Reproducible: Always
User Profile Reset: No
Additional Info:
Didn't reset my user profile but same problem on a different, new machine.
I put the severity as "normal" but personally for me, it is major - I can't
trust my calculations anymore and need to recalculate everything whenever I
change something.
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/55.0.2883.87 Safari/537.36
--
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
