Created attachment 43971 [details] autofilter count When applying an AutoFilter to a spreadsheet there's no way to see the row-count of the selection. Both Excel and Symphony show the count on the bottom statusbar. In LB there is a 'count' option in the status bar, but it remains on "0". In OOo this is working as it should.
This is not a bug. The count on the status bar is just showing the number of selected numeric values. On the screenshot you selected only one cell containing "b"... that is not a numeric value.
thx for the reply, but if it isn't a bug then it must be a missing feature, since all other spreadsheet editors can show the row count of a selected filter. I don't have a OOo installation at hand, but there is definately an option to see this.
additional info, looks like in OOo this is called "Number" or "Number2", and not "Count" (so let me apologize for the confusion) but in the same selection menu as on the screenshot, and seems to be missing in LB.
(In reply to comment #3) > additional info, looks like in OOo this is called "Number" or "Number2", and > not "Count" (so let me apologize for the confusion) but in the same selection > menu as on the screenshot, and seems to be missing in LB. In your screenshot, these are corresponding to "Count" and "CountA". CountA counts the number of values numeric or not in the selected cells. The "Feature" you are requiring is already implemented by this: I don't see the point in adding anything more to count rows.
Created attachment 44008 [details] autofilter2 see bug desciption
Yes, what you're saying is that Count is for the 'selected cells', correct. But that is in-depended from the AutoFilter selection, and not the intention of this report. What I miss is one that tells me how many rows there are in the selected criteria of the autofilter, see the new screenshot attached: https://bugs.freedesktop.org/attachment.cgi?id=44008 True in the example above I could select all cells to get the count, but the sheets I'm working with daily are more like; 2690 out of 12000, manually selecting is no real option here. OOo used the be able to show that too, possibly with the Number or Number2 function, but unfortunately I can't test that right now. (The Symphony version 3.0 I'm using is based on OOo 3.0.0 code afaik, so it has been done before..).
Kohei, could you evaluate that feature?
Created attachment 47883 [details] Screenshot of OOo autofilter The attachment shows no such "x out of y records found" in OOo.
(In reply to comment #8) > Created an attachment (id=47883) [details] > Screenshot of OOo autofilter > > The attachment shows no such "x out of y records found" in OOo. Screenshot was taken of OOo 3.2.0, on a Win7 x64 system
I haven't seen this confirmed by anyone - REOPENED is incorrect regardless as the bug isn't assigned to anyone. Also removing feature from whiteboard as that's incorrect. Marking as UNCONFIRMED so QA team can have a fresh look at it.
Setting as NEW, valid enhancement. Workaround select filtered data and in the bottom toolbar select "number of selected", but this is useful only in small count of selected items.
Submitted a patch for review at https://gerrit.libreoffice.org/#/c/20134/
Dennis Francis committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3536fe8f4cdbacf5702e743407f34d918b6f4d38 tdf#34873 : Show autofilter row count in status bar It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Dennis Francis committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1e619fdf9e79cb49895d83fe7f5a1f373495b915 tdf#34873 : Better way to show autofilter count It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 103007 has been marked as a duplicate of this bug. ***
Notes for unit test writers: Revert not needed as you would be testing new functionality.