Re: Calc and filter

2014-03-25 Thread Brian Barker
At 21:45 25/03/2014 +0100, Laurens Thissen wrote: On [25 mrt.], at 17:24, Brian Barker 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 Exc

Re: Calc and filter

2014-03-25 Thread Laurens Thissen
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 cumberso

Re: Calc and filter

2014-03-25 Thread Brian Barker
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