poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DavidZaz <dzaze...@cait.org>
Subject RE: Auto Filter
Date Fri, 25 Jun 2010 13:32:16 GMT

Thanks for the reply.

I performed the following test:

1. Created a new Excel 2007 document in MS Excel 2007.
2. Entered some dummy data.
3. Clicked on the "data" tab. Highlight the columns to be auto-filtered and
click on the "filter" icon.
4. Save the file and close MS Excel.
5. Open the file with OpenOffice.

In my testing, the filter did appear in OpenOffice so it must be stored in
the file somewhere. I'll open up the xlsx file in an editor and see if I can
identify the appropriate tags....


Christian Gosch-2 wrote:
> 
> As far as I remember, Excel AutoFilter is a feature of the application, 
> not the file. If that is not correct, please correct me.
> 
> But what may be part of the file is a specific filter, since Excel knows 
> of a stored filter when the file is opened again.
> 
> Another way to check this is to open a prepared file with OOo: If the 
> filter is recognized there, then there obviously must be some way to 
> detect it.
> 
> If on the other hand OOo can set up such a filter, and afterwards Excel 
> can recognize it, there obviously must be some way to put that into the 
> file.
> 
> --cg
> 
> 
>> -----Original Message-----
>> From: DavidZaz [mailto:dzazeski@cait.org]
>> Sent: Friday, June 25, 2010 3:14 PM
>> To: user@poi.apache.org
>> Subject: Re: Auto Filter
>> 
>> 
>> I did some more research and found bug 35125 in the bug database. It 
> was
>> reported in 2005, but it doesn't look active. It looks like 
> auto-filter
>> was
>> never implemented.
>> 
>> Can anyone verify that is correct? If it was not implemented, are 
> there
>> any
>> pointers about how I could get it added?
>> 
>> References:
>> https://issues.apache.org/bugzilla/show_bug.cgi?id=35125
>> 
>> 
>> DavidZaz wrote:
>> >
>> > How do I setup an auto-filter column using Apache POI on a xlsx 
> file?
>> >
>> > I've tried googling for the answer and I've found this question 
> asked
>> > several times with either no response or a HSSF specific answer. 
> Should
>> I
>> > add a feature request bug or has this functionality already been
>> > implemented?
>> >
>> > Thanks!
>> >
>> 
>> --
>> View this message in context: http://old.nabble.com/Auto-Filter-
>> tp28991981p28992209.html
>> Sent from the POI - User mailing list archive at Nabble.com.
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>> 
>> 
>> !DSPAM:4c24abb217327074515327!
>> 
>> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/Auto-Filter-tp28991981p28992392.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message