https://bugs.documentfoundation.org/show_bug.cgi?id=118161
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
Summary|ANZAHL2 (German version) |COUNTA() returns
|returns inconsistent values |inconsistent values
|depending on entering |depending on entering
|separate cells or a |separate cells or a
|corresponding cellrange |corresponding cell range
Status|UNCONFIRMED |NEW
--- Comment #2 from Eike Rathke <[email protected]> ---
It's certainly a bug that both variants return different results, but the
result should be 3 in both cases, not 2, because none of the cells in the range
are empty. It also doesn't need different sheets, a simple example
A1: =COUNTA(A2:A3)
A2: =B2
gives 0 instead of 1. Entering any value in B2 yields 1. Apparently the "empty
cell inherited" status in A2 is considered as empty.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
