Hi, I've tried Michael's patch and it worked fine, so the question is now: \ 1. Do I need to open a bug, since Michael referred several bug dealing with this problem. 2. When this patch will be incorporated to the release?
Thanks for the help. -----Original Message----- From: Mikael Sitruk [mailto:[EMAIL PROTECTED] Sent: 13 August, 2004 08:57 To: 'POI Developers List' Subject: RE: Strange record type in Excel file I will try the patch thanks, btw what is your version? How did you find that the 5D record is an object, I didn't find it in the documentation? -----Original Message----- From: Michael Zalewski [mailto:[EMAIL PROTECTED] Sent: 13 August, 2004 01:28 To: POI Developers List Subject: RE: Strange record type in Excel file Oops wrong patch The patch I submitted about dropdowns is in http://nagoya.apache.org/bugzilla/show_bug.cgi?id=27929 Looks like this patch was never incorporated because I made a typo on the Junit testcase. Or perhaps something else I just don't understand. You need to fix two files SubRecord.java and ObjRecord.java. The patch is here http://issues.apache.org/bugzilla/showattachment.cgi?attach_id=11954 I know this works because I am able to open your file with my patched version of POI. Haven't downloaded the newest 2.5 yet though. -----Original Message----- From: Michael Zalewski [mailto:[EMAIL PROTECTED] Sent: Thursday, August 12, 2004 7:18 PM To: POI Developers List Subject: RE: Strange record type in Excel file 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 http://nagoya.apache.org/bugzilla/show_bug.cgi?id=28203 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:[EMAIL PROTECTED] 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. Jason -----Original Message----- From: Mikael Sitruk [mailto:[EMAIL PROTECTED] Sent: Friday, 13 August 2004 6:34 AM To: [EMAIL PROTECTED] 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 1.10. 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 java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA ccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons tructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java :225) at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav a:160) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130) 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: [EMAIL PROTECTED] 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 Thanks Mikael.S ------------------------------------------------------------------------ ---- ---------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
