https://bugs.freedesktop.org/show_bug.cgi?id=74677
Priority: high
Bug ID: 74677
Assignee: [email protected]
Summary: empty Cells in SUMPRODOCT(...) are evaluated as 1
Severity: critical
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.0.3 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 93614
--> https://bugs.freedesktop.org/attachment.cgi?id=93614&action=edit
Calc-document Sumproducterror
Hallo
Empty Cells in =SUMPRODUCT-formula-Arrays are evaluated as 1, if the
corresponding Cell is *not* empty.
I expect that they are evaluated as 0 as in prior Version of LO up to 4.1
Test with:
Version: 4.2.0.3
Build-ID: c63c03decdf780d8fb80823950665b782ec9ecd0
Karolus
--
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
