Return-Path: 
 <poi-user-return-4834-apmail-jakarta-poi-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org
Received: (qmail 85647 invoked from network); 3 Jun 2004 00:40:54 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 3 Jun 2004 00:40:54 -0000
Received: (qmail 52683 invoked by uid 500); 3 Jun 2004 00:41:11 -0000
Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org
Received: (qmail 52533 invoked by uid 500); 3 Jun 2004 00:41:10 -0000
Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:poi-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:poi-user-subscribe@jakarta.apache.org>
List-Help: <mailto:poi-user-help@jakarta.apache.org>
List-Post: <mailto:poi-user@jakarta.apache.org>
List-Id: "POI Users List" <poi-user.jakarta.apache.org>
Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
Delivered-To: mailing list poi-user@jakarta.apache.org
Received: (qmail 52518 invoked by uid 99); 3 Jun 2004 00:41:10 -0000
Received: from [80.91.224.249] (HELO main.gmane.org) (80.91.224.249)
  by apache.org (qpsmtpd/0.27.1) with ESMTP; Wed, 02 Jun 2004 17:41:10 -0700
Received: from root by main.gmane.org with local (Exim 3.35 #1 (Debian))
	id 1BVgHi-0007ct-00
	for <poi-user@jakarta.apache.org>; Thu, 03 Jun 2004 02:40:45 +0200
Received: from avproxy2.alcanet.com.au ([avproxy2.alcanet.com.au])
        by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
        id 1AlnuQ-0007hv-00
        for <poi-user@jakarta.apache.org>; Thu, 03 Jun 2004 02:40:42 +0200
Received: from neil.clifton by avproxy2.alcanet.com.au with local (Gmexim 0.1
 (Debian))
        id 1AlnuQ-0007hv-00
        for <poi-user@jakarta.apache.org>; Thu, 03 Jun 2004 02:40:42 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: poi-user@jakarta.apache.org
From: Neil Clifton <neil.clifton@alcatel.com.au>
Subject: POI HSSF Excel filter cells (Data -> Filter -> AutoFilter) break HSSF
Date: Thu, 3 Jun 2004 00:32:24 +0000 (UTC)
Lines: 36
Message-ID: <loom.20040603T021536-614@post.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@sea.gmane.org
X-Gmane-NNTP-Posting-Host: main.gmane.org
User-Agent: Loom/3.14 (http://gmane.org/)
X-Loom-IP: 208.178.117.4 (Opera/7.11 (Windows NT 4.0; U)  [en])
Sender: news <news@sea.gmane.org>
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Hi,
Anyone out there have any comments or suggestions for me?
Apparently if the HSSF file has cells that are set as filters using Data -> 
Filter -> AutoFilter in excel, when reading, I get:

org.apache.poi.hssf.record.RecordFormatException: Unable to construct record 
instance, the following exception occured: null
	at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.
java:237)

Also I see:

java.lang.reflect.InvocationTargetException: java.lang.
ArrayIndexOutOfBoundsException
	at org.apache.poi.hssf.record.SubRecord.createSubRecord(SubRecord.java:60)
	at org.apache.poi.hssf.record.ObjRecord.fillFields(ObjRecord.java:104)
	at org.apache.poi.hssf.record.Record.fillFields(Record.java:91)
	at org.apache.poi.hssf.record.Record.<init>(Record.java:56)
	at org.apache.poi.hssf.record.ObjRecord.<init>(ObjRecord.java:62)
	at java.lang.reflect.Constructor.newInstance(Native Method)
	at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.
java:291)

This is easy for me to reproduce with a very simple spreadsheet.
Anyone else get this?
I guess that the excel filter cell is not supported.
I cannot find much recent reference to it.
This is unfortunate because I have seen this filter cell used in many 
spreadsheets. It is useful and easy to apply.
I am working a project that will be loading data from some complex spreadsheets 
into a database. (I had trouble finding this problem when the filter cells were 
in a hidden worksheet).
I would love to find and contribute a fix myself if the project could spare the 
time. I cannot fix it in my own time ...
Any help?
Questions welcome.


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