1. Nope this is a well known problem. 2. Glen, did this go into 2.5.1??
On Sat, 2004-08-14 at 05:06, Mikael Sitruk wrote: > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
