[Libreoffice-bugs] [Bug 118161] COUNTA() returns inconsistent values depending on entering separate cells or a corresponding cell range

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118161

Eike Rathke <erack at redhat.com> 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 <erack at redhat.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180614/0508d645/attachment.html>