https://bugs.documentfoundation.org/show_bug.cgi?id=94924
Bug ID: 94924
Summary: strange behavior in formulas computing
Product: LibreOffice
Version: 5.0.2.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 119471
--> https://bugs.documentfoundation.org/attachment.cgi?id=119471&action=edit
partial screen shot of the same situation; original without 0 and incorrectly
positive, test with added 0 on next line and correct negative result result
strange bug found found since last version update, in a calc file, used for
many years (bank account, the doc itself and its formulas can be considered as
improved).
Column D is for incomes;Column E is for outcomes;(hidden) column F is delta
result of =D-E
when discovered this bug, I had 4 lines with only outcomes, but the results was
... positive.
Evaluation by small formula helper was correct (negative)
In a further line, if i put a 0 instead of empty cell in INcome, the 4 results
turned to negative; if delete the 0, the four lines turned back to positive.
Finally, i have set a space instead of the 0, making errors on all the
followings lines, the delete back to an empty cell and ... everything back to
normal (delta negative when outcome set, positive when income set).
Strange, isn't it ?
It seems that it's only happens when there is no more "incomes" in further
lines, so the bug remains on lasts "outcomes" lines.
I had to go back on every sheet ending with outcome lines and doing this
space-enter-then-delete-content-of-cell woorkaround to get back correct values
over the whole workbook.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
