https://bugs.documentfoundation.org/show_bug.cgi?id=99291
Bug ID: 99291
Summary: An array formula computes incorrect and inconsistent
results, incompatible with other spreadsheets
Product: LibreOffice
Version: unspecified
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
User-Agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/49.0.2623.110 Safari/537.36 OPR/36.0.2130.65
Build Identifier: Version: 5.1.1.3 Build ID:
89f508ef3ecebd2cfb8e1def0f0ba9a803b88a6d CPU Threads: 4; OS Version: Windows
6.1; UI Render: default; Locale: pl-PL (pl_PL)
Initially the spreadsheet is empty, in particular column D is blank. (Semicolon
used in formulas below due to the local settings in my country.)
1. I enter formula =COUNTIF(D1:D5;D1) in A1, the result computed is 0
(consistent with other spreadsheets, including Excel and OpenOffice).
2. I enter formula {=COUNTIF(D1:D5;D1)} in B1, as an array formula
(Ctrl-Shift-Enter), the result computed is 0 (consistent with other
spreadsheets, including Excel and OpenOffice).
3. I enter formula {=COUNTIF(D1:D5;D2)} in B2, as an array formula
(Ctrl-Shift-Enter), the result computed is 0 (consistent with other
spreadsheets, including Excel and OpenOffice).
4. I enter formula {=COUNTIF(D1:D5;D1:D2)} in C1:C2, as an array formula
(Ctrl-Shift-Enter). I expect (by 2 and 3 above and the semantics of array
formulas) to get a column 0;0. However, I get a column 5;5. This is incorrect,
inconsistent with 2 and 3 above, incompatible with other spreadsheets,
including Excel and OpenOffice.
Reproducible: Always
Steps to Reproduce:
1. Strat with blank spreadsheet
2. Enter {=COUNTIF(D1:D5;D1:D2)} in C1:C2, as an array formula
(Ctrl-Shift-Enter).
3.
Actual Results:
5
5
Expected Results:
0
0
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Reset User Profile?No
--
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
