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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
