https://bugs.freedesktop.org/show_bug.cgi?id=64384
Priority: medium
Bug ID: 64384
Assignee: [email protected]
Summary: SUBTOTAL function fails with scalar as 2nd parameter
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: NEW
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
Created attachment 79043
--> https://bugs.freedesktop.org/attachment.cgi?id=79043&action=edit
SUBTOTAL test spreedsheet
I don't know if I may set this as bug or enhancement...
=SUBTOTAL(3;A2) will returns always 1 even if A2 (non-emty) hidden by
filtering.
Workaround : Works with a pseudo-range
=SUBTOTAL(3;A2:A2)
Someone (Eike ?) fix the same kind of bug with MATCH.
But it is perhaps more difficult...
--
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
