poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 44958] New: Unknown Ptg in Formula: 0x2 (2) --- Data Tables not Supported
Date Fri, 09 May 2008 06:44:51 GMT
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: dev@poi.apache.org
        ReportedBy: brandon@enspire.com


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message