https://bugs.documentfoundation.org/show_bug.cgi?id=96344
Bug ID: 96344
Summary: FILTER - Bad count of items in status bar and DCOUNT
counting items in list
Product: LibreOffice
Version: 4.3.3.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 121151
--> https://bugs.documentfoundation.org/attachment.cgi?id=121151&action=edit
Test file for cell count
Hi,
In attached file there are a few strange things about counting of filtered
cells. The file contains two sheets "Logg" and "Count". On sheet "Logg" there
is a list (named area "LoggDB") with one column "Typ". The list if pre-filtered
for "Ozone McDaddy".
Strange things are that;
1. On sheet "Logg", the number of displayed rows containing "Ozone McDaddy" are
20. But when selecting the same cells, the status bar displays a row count of
51! On sheet "Count" function DCOUNTA is used to count number of rows
containing for "Ozone McDaddy" in cell N4; the result is (correctly) 20.
2. On sheet "Count" function DCOUNTA is also used to count number of rows
containing for "UP Summit XC2" in cell M4; the result is 174. Filtering the
list on sheet "Logg" and selecting all filtered cells yields row count of 194!
I expected the result from DCOUNT and the status bar row count for selected
cells to match. That is not the case.
I'm using Linux Debian stable (jessie) release of LibreOffice;
Version: 4.3.3.2
Build ID: 430m0(Build:2)
What could be wrong?
--
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
