https://bugs.documentfoundation.org/show_bug.cgi?id=173213
Bug ID: 173213
Summary: Formula somewhere else changes when unrelated cells
are moved
Product: LibreOffice
Version: 26.2.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 208173
--> https://bugs.documentfoundation.org/attachment.cgi?id=208173&action=edit
Simple calculation of a Score value and I noticed the Bug.
EDITING
I have created a short table to calculate a score value using simple formula
like if or sum with specified areas:
=WENN(((HEUTE()-F$9)/365>B10)*(SUMME(G$21:G11)=0);D10;0)
A bug appears, if I move some text-containing cells. This move goes well, but
at the same time, some of the formula somewhere else change their content.
in Detail:
I move cell B2 to the right to C2
Text is moved, nice, but
In column G some forumal change their content and thus an error appears:
Formula in G10:before the move:
=WENN(((HEUTE()-F$9)/365>B10)*(SUMME(G$21:G11)=0);D10;0)
after the move:
=WENN(((HEUTE()-F$9)/365>B10)*(SUMME(G$11:G21)=0);D10;0)
The fixation of the border in the sum changes, which is very weird!
If I then Undo, the move is undone, but the formula changes are persistent.
After Undo
=WENN(((HEUTE()-F$9)/365>B10)*(SUMME(G$11:G21)=0);D10;0)
--
You are receiving this mail because:
You are the assignee for the bug.
