https://issues.apache.org/bugzilla/show_bug.cgi?id=44958
Summary: Unknown Ptg in Formula: 0x2 (2) --- Data Tables not
Supported
Product: POI
Version: 3.0
Platform: Macintosh
OS/Version: Mac OS X 10.4
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
Created an attachment (id=21940)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=21940)
Excel Spreadsheet Containing Data Tables
Using the HSSFWorkbook(InputStream) constructor with the attached excel
spreadsheet (containing data tables) yields:
WARN. Unread 170 bytes of record 0x1b8
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:208)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:126)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:226)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:168)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:278)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:259)
at HSSFTest.main(HSSFTest.java:29)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:196)
... 6 more
Caused by: org.apache.poi.hssf.record.RecordFormatException:
java.lang.UnsupportedOperationException: Unknown Ptg in Formula: 0x2 (2)
at
org.apache.poi.hssf.record.FormulaRecord.fillFields(FormulaRecord.java:109)
at org.apache.poi.hssf.record.Record.<init>(Record.java:55)
at
org.apache.poi.hssf.record.FormulaRecord.<init>(FormulaRecord.java:89)
... 11 more
Caused by: java.lang.UnsupportedOperationException: Unknown Ptg in Formula:
0x2 (2)
at org.apache.poi.hssf.record.formula.Ptg.createPtg(Ptg.java:361)
at
org.apache.poi.hssf.record.formula.Ptg.createParsedExpressionTokens(Ptg.java:98)
at
org.apache.poi.hssf.record.FormulaRecord.fillFields(FormulaRecord.java:107)
... 13 more
I found this as well:
ptgTbl - data table (ptg = 0x02)
This ptg indicates a data table. It only occurs in a FORMULA record,
never in an ARRAY or NAME record. When ptgTbl occurs in a formula,
it is the only token in the formula. This indicates that the cell
containing the formula is an interior cell in a data table; the table
description is found in a TABLE record. Rows and columns which
contain input values to be substituted in the table do not contain
ptgTbl.
The token value for ptgTbl consists of the row and column of the
upper left corner of the table's interior.
Offset Name Size Contents
------ ---- ---- --------
0 rwFirst 2 row number of upper left corner
2 colFirst 1 column number of upper left corner
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
