Thanks Brian, It helps, i.e. it’s a workaround, not ideal. In order for Count to work for my purposes, I have to manually select a filtered, randomly selected column of cells, but these cells need to be formatted as Numbers. All this is not so bad with small database files, but is quite cumbersome in the case of bigger ones. I hope I am overlooking something, but atm this is one of the strong points of Excel which I’d love to see developed for Calc as well. Thanks again, Laurens
On [25 mrt.], at 17:24, Brian Barker <b.m.bar...@btinternet.com> wrote: > 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 >
