poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Zalewski <zalew...@optonline.net>
Subject RE: Strange record type in Excel file
Date Thu, 12 Aug 2004 23:18:21 GMT
It does seem to be an OBJ record.

It is an OBJ record that describes a drop-down list (ftCmo), which caused a
problem in 2.0. Basically, the subrecord that describes a combo box does not
follow the rules of other subrecords. I supplied a patch for this problem
(and I think two other people also supplied patches). But are these patches
in 2.5?

See this patch

This error caused InvocationTargetException to be thrown whenever reading a
spreadsheet that contains drop down list boxes (including spreadsheets with
data validation).

You might check that the code in this patch has been applied to the 2.5
release. I get so confused about HEAD vs 2.0 vs 2.5. I think if you follow
the instructions there, you will be able to use the new release.

-----Original Message-----
From: Height, Jason [mailto:jheight@subcorp.com.au]
Sent: Thursday, August 12, 2004 6:19 PM
To: POI Developers List
Subject: RE: Strange record type in Excel file

Is that 93 in decimal or Hex. If it is hex then yup don't know what that
record type is.

If it is decimal ie 5D hex then the record is the OBJ record which
describes a graphic object. Which should be implemented.

In either case could you please create a bugzilla entry, attaching the
sample file that you provided.


-----Original Message-----
From: Mikael Sitruk [mailto:mikael_s@bezeqint.net]
Sent: Friday, 13 August 2004 6:34 AM
To: poi-dev@jakarta.apache.org
Subject: Strange record type in Excel file

Hi to all

I've encountered a problem in releases 2.5/2.51 that was not present in

I have a workbook containing data, and I wish to copy to a target
workbook, in 1.10 everything was fine, nevertheless when upgrading to
2.5/2.51 I got an exception on the workbook creation.

I've attached the exception just for documentation


        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native








        at HSSF.<init>(HSSF.java:109)

        at HSSF.main(HSSF.java:348)


First I though that my code was not ok, so I used the one referenced in
the FAQ, and still got the problem. So I've printed the record that made
the problem, and got:

Record type: 93 size: 70 data: [B@19106c7

I've tried to find from which cell this can provide, but even after
having removing all the data in the worksheet (the problematic worksheet
is "sss") I still got the exception.

I've checked in the M$ Excel File Format doc, but I don't see any
documentation on this record type!!!

Do you have any idea how I can overcome the problem? Since for now I'm
not able to upgrade to the latest POI version.

I've attached the problematic file



This e-mail (including attachments) is confidential information of
Australian Submarine Corporation Pty Limited (ASC).  It may also be legally
privileged.  Unauthorised use and disclosure is prohibited.  ASC is not
taken to have waived confidentiality or privilege if this e-mail was sent to
you in error. If you have received it in error, please notify the sender
promptly.  While ASC takes steps to identify and eliminate viruses, it
cannot confirm that this e-mail is free from them.  You should scan this
e-mail for viruses before it is used.  The statements in this e-mail are
those of the sender only, unless specifically stated to be those of ASC by
someone with authority to do so.

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

View raw message