At 13:49 25/03/2014 +0100, Laurens Thissen wrote:
When I apply a filter in a Calc file, is it possible to see how many records are filtered? I am unable to find an easy way to do this in Calc. In Excel this is instantly readable in the status bar (e.g. 7 out of 36 records found).
Towards the right of the Status Bar (at the bottom of the window), you will see a field that is described as "Cell or object information". This may show Sum or Average by default, but if you right-click it you can select Count instead. Observing this both before and after the filtering process may provide what you need.
I trust this helps. Brian Barker ------------------------------------------- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
