Auto Filter count

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Auto Filter count

Stephen Ellis
Hi There,
Firstly thank you for version 1.6, I think it is a big improvement over 1.5.
Would it be possible to include a count feature when using the Auto Filter in a future update.
With this feature it would then be the ultimate office package.
Excel already has this feature included.
At the moment I physically have to count records, this is not only time consuming but also inaccurate.
Thank you for your time.
I look forward to your reply.
Stephen.
Reply | Threaded
Open this post in threaded view
|

Re: Auto Filter count

Brian Barker-2
At 12:30 19/09/2019 +0000, Stephen Ellis wrote:
>Firstly thank you ...

Well, it's not me: you wrote to a mailing list which, as its name
("Users") suggests, is composed mainly of users of OpenOffice - just
like you and me.

>... for version 1.6, I think it is a big improvement over 1.5.

Since neither of those versions existed, I'm hoping you mean version 4.1.6?

>Would it be possible to include a count feature when using the Auto
>Filter in a future update. With this feature it would then be the
>ultimate office package. Excel already has this feature included. At
>the moment I physically have to count records, this is not only time
>consuming but also inaccurate.

Unreliable rather than necessarily inaccurate, I think.

No, you don't have to count the rows. You can use the SUBTOTAL()
function, which provides the result of one of eleven different
calculations on a range, but applied only to the visible rows when
AutoFilter has been used. For example:
=SUBTOTAL(2;Xm:Xn)
applies the function COUNT() to visible cells in the range Xm:Xn, so
counts how many numbers there are; or
=SUBTOTAL(3;Xm:Xn)
applies the function COUNTA() in a similar fashion, thus counting
values whether they be numbers or text.
But note that empty cells are not counted. Try this and watch the
values change as you use different criteria in your AutoFilter.

If you wish to suggest something as an enhancement to OpenOffice, you
need to do this at the web site - at the same place where you report
bugs. Start at
https://bz.apache.org/ooo/ . But I'm not sure that "Excel has this"
will be a compelling reason for change.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]