https://bugs.freedesktop.org/show_bug.cgi?id=69763
Priority: medium
Bug ID: 69763
Assignee: [email protected]
Summary: LibreOffice Calc: Change in formula evaluations when
using empty content or content ""
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: unspecified
Component: Libreoffice
Product: LibreOffice
Empty cells and cells with value "" are processed in an other way than in all
former versions of Calc (and at least MS Office 2000) leading to the need of
extensive changes.
e.g.: my formula
=WENN($A901;E900+D901;"")
is now ending in failure because E900 may be empty or have value ""
Up to now it was working as expected, but in the new version it must be changed
e.g. to
=WENN($A901;E900+SUMME(D901);"")
or even to
=WENN($A901;E900+SUMME(D901);0)
to avoid changes in other formulas (and instead leading e.g. to formatting
work)
because cell D901 may have content empty or "" (and because the result itself
is used in further calculations)
--
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
