[Libreoffice-bugs] [Bug 118161] New: ANZAHL2 (German version) returns inconsistent values depending on entering separate cells or a corresponding cellrange

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118161
           Summary: ANZAHL2 (German version) returns inconsistent values
                    depending on entering separate cells or a
                    corresponding cellrange
           Product: LibreOffice
           Version: 5.1.6.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: usack at math.fu-berlin.de

Description:
In a list of values that come from cell references in another table an empty
value in the referenced cell will not be counted when using e.g. ANZAHL2(A1:C1)
as expected. However if I use ANZAHL2(A1;B1;C1) it is counted which I would NOT
expect. See MWE

Steps to Reproduce:
1.Open new file
2.Enter Values in Table2: A1=1 B1=<empty> C1=3
3.Enter cell references in Table1: A1=Table2.A1 B1=Table2...etc
4.In Table1 enter in (say) A4 =ANZAHL2(A1:C1) and in A5 =ANZAHL2(A1;B1;C1)

Actual Results:  
Table1.A4 contains 2
Table1.A5 contains 3 

Expected Results:
Table1.A5 should imho contain 2


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 5.1.6.2
Build-ID: 1:5.1.6~rc2-0ubuntu1~xenial3
CPU-Threads: 4; BS-Version: Linux 4.4; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:60.0) Gecko/20100101
Firefox/60.0

-- 
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/8b422e36/attachment-0001.html>