https://bugs.freedesktop.org/show_bug.cgi?id=72999
Priority: medium
Bug ID: 72999
Assignee: [email protected]
Summary: EDITING: COUNT function ignores second and next
arguments if 1st is a range
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA PossibleRegression
Status: UNCONFIRMED
Version: 4.2.0.1 rc
Component: Spreadsheet
Product: LibreOffice
Problem description:
If COUNT function has several arguments, and if 1st one is a range (A1:A2),
then next arguments are ignored
Steps to reproduce:
1. New spreadsheet (same with previous spreadsheet)
2. Insert values in A1, A2 and A3 for instance
3. Type in A4: =COUNT(A1:A2;A3)
Current behavior:
Result is 2 whatever the content of A3 is.
Expected behavior:
Result should be 3 if A3 content is a value.
The result is correct if formula is =COUNT(A1;A2;A3)
NO problem with COUNTA, SUM, MEAN functions
Operating System: Windows 7
Version: 4.2.0.1 rc
Last worked in: 4.1.4.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
