incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Asselman <>
Subject Feature request: Autofilter blanks & nonblanks
Date Thu, 15 Mar 2012 22:04:10 GMT

I've been trying out OpenOffice today and while I'm very thankful for this
good Office, there's a thing that bugs me...

The one feature that I find very useful about Excel is the "(blanks)" and
"(nonblanks)" in the autofilter on a row.

Where does this come in use? Well, I have an Excel where I aggregate scores
AND ranks in tops for TV-series. From these I calcutate an average of some
sorts. The nonblanks come in use when I want to see every tv-serie in a
certain top 50. As you can see, this spreadsheet is a mix between a
database and a spreadsheet, but... Well, I could write a webapp in C# and
access the data from a database... But that's a *huge*  workaround.

I'm sure I'm not the only one who used Excel like this and it seems to me
(blanks)/(nonblanks) seems not to mucht effort to include in an update.
Actually, as I'm a software develor myself, I would find this a nice

I hope you can now see why this feature in Excel is helpful. I'm
disappointed that this means I still have to use Excel for this sheet, I
guess I'm not the only one in the world, so hopefully you know have enough
reasons to include this feature-request.  Thanks in advance.

Kind Regards,
- Steven Asselman
(The Netherlands)

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message