poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 54436] Broken matadata for GETPIVOTDATA function
Date Sat, 02 Mar 2013 12:06:16 GMT

Yegor Kozlov <yegor@dinom.ru> changed:

           What    |Removed                     |Added
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #5 from Yegor Kozlov <yegor@dinom.ru> ---
Patch applied in r1451875

The metadata is fixed but you still be getting exceptions because GETPIVOTDATA
is not implemented in current version of POI. If you need to evaluate workbooks
with this function you need to implement it and register via
WorkbookEvaluator#registerFunction, see

I could not reproduce the problem with the test from the attached archive. The
code throws a exception but a different one:

java.lang.IllegalArgumentException: firstMovedIndex, lastMovedIndex out of
    at org.apache.poi.ss.formula.FormulaShifter.<init>(FormulaShifter.java:56)
    at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows(XSSFSheet.java:2361)

I confirmed it with POI-3.9 and trunk. 

The simplest test for this fix is to evaluate all formulas in the workbook:


Without this fix it fails with ArrayIndexOutOfBoundsException and with the
patch applied it passes OK. 


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

View raw message