DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=42618>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=42618 Summary: Problem reading excel cell formula Product: POI Version: unspecified Platform: All OS/Version: Windows XP Status: NEW Severity: blocker Priority: P2 Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] I am trying to read a formula as is from the excel file. The formula is =CHOOSE(2,A2,A3,A4) But I am getting the following error. Exception in thread "main" org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance at org.apache.poi.hssf.record.RecordFactory.createRecord (RecordFactory.java:191) at org.apache.poi.hssf.record.RecordFactory.createRecords (RecordFactory.java:115) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:205) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:257) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:238) at excelFileReader.ParseExcel.main(ParseExcel.java:14) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at org.apache.poi.hssf.record.RecordFactory.createRecord (RecordFactory.java:179) ... 5 more Caused by: org.apache.poi.hssf.record.RecordFormatException: java.lang.UnsupportedOperationException: Unknown Ptg in Formula: 0x0 (0) at org.apache.poi.hssf.record.FormulaRecord.fillFields (FormulaRecord.java:109) at org.apache.poi.hssf.record.Record.<init>(Record.java:56) at org.apache.poi.hssf.record.FormulaRecord.<init> (FormulaRecord.java:89) ... 10 more Caused by: java.lang.UnsupportedOperationException: Unknown Ptg in Formula: 0x0 (0) at org.apache.poi.hssf.record.formula.Ptg.createPtg(Ptg.java:357) at org.apache.poi.hssf.record.formula.Ptg.createParsedExpressionTokens (Ptg.java:98) at org.apache.poi.hssf.record.FormulaRecord.fillFields (FormulaRecord.java:107) ... 12 more -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
