https://bugs.freedesktop.org/show_bug.cgi?id=73080
Priority: medium
Bug ID: 73080
Assignee: [email protected]
Summary: COUNTBLANK counts formula with reference to blank cell
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
Make sure B2 is empty, that means, that it does not contain any content.
Write the formula =B2 into cell B3
Write the formula =COUNTBLANK(B2:B3) into cell A1.
Expected result: A1 shows number 1.
Seen result: A1 shows number 2.
The content of cell B3 is a formula, therefore it is not empty and may not be
counted. The specification only allows the exception, that a cell, which
contains a zero-length string, may be counted by COUNTBLANK.
Apache OpenOffice, Gnumeric, and Excel does not count cell B3 and return 1 in
the example given above.
Suggestion: LibreOffice does not count cell which has a formula that refers an
empty cell.
--
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
