incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ariel Constenla-Haile <arie...@apache.org>
Subject Re: Feature request: Autofilter blanks & nonblanks
Date Fri, 16 Mar 2012 13:54:01 GMT

Hi Helen,

Steven is not subscribed to the list, so you have to Cc him, otherwise
he won't be able to read the answer.

Regards
Ariel

On Fri, Mar 16, 2012 at 10:42:17AM +0800, Yue Helen wrote:
> Steven,
> 
> I'm trying to clarify the scenario...
> 
> Do you mean that, you need a (Blanks)/(Non-Blanks) condition in the
> autofilter? Why is it related with top 50/100?
> 
> I just had a quick look. One alternative to do that, is to use Standard
> Filter...and then set empty/not empty" in the filter...not one step
> solution...does it help?
> 
> Helen
> 
> 2012/3/16 Steven Asselman <steven.asselman@gmail.com>
> 
> > oh, also I could make a row for each top 50 and 100 next to it with a check
> > If(blank)... in it and use that in the autofilter... But that's well,
> > ugly...
> >
> > Op 15 maart 2012 23:04 schreef Steven Asselman
> > <steven.asselman@gmail.com>het volgende:
> >
> > > Hi,
> > >
> > > 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
> > > challenge.
> > >
> > >
> > > 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)
> > >
> >
> >
> >
> > --
> > Met vriendelijke groet,
> > - Steven Asselman
> >

-- 
Ariel Constenla-Haile
La Plata, Argentina

Mime
View raw message