Automatic count of rows in filtered list

Discuss the spreadsheet application

Automatic count of rows in filtered list

Postby morphingstar » Sun May 03, 2020 9:28 pm

 Edit: Split from [Solved] Automatic count of the rows in a filtered list — MrProgrammer, moderator, 2020-05-04 15:07 UTC 
I need to see the number of found rows in a cell above the table when I select Autofilter, I want to include the value when printing.
The bottom bar indicates value 1 while 50 rows are displayed in Filter out of 400. Cell content is text, though I don't care about content type. Displayed is Displayed!
Last edited by MrProgrammer on Mon May 04, 2020 5:08 pm, edited 2 times in total.
Reason: New problem in [Solved] topic from new person requires their own topic
OO 4.1.6 on Win10. Member since StarOffice 7. Alternative name "morphingstar2" when other fails. Use Writer, Calc (as DB + Calc), Draw. Impress mainly for Eyedropper and animating GIFs. Updated 20190716.
User avatar
Posts: 86
Joined: Mon Mar 28, 2011 5:52 am
Location: Mx

Re: [Solved] Automatic count of the rows in a filtered list.

Postby Villeroy » Sun May 03, 2020 10:27 pm

LibreOffice Calc shows the count of selected rows and columns in the status bar disregarding rows that are hidden by a filter.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Posts: 28544
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Calc

Who is online

Users browsing this forum: No registered users and 17 guests