Author: yegor
Date: Sat Mar 2 11:38:09 2013
New Revision: 1451875
URL: http://svn.apache.org/r1451875
Log:
Bugzilla 54436: Fixed metadata for GETPIVOTDATA function
Added:
poi/trunk/test-data/spreadsheet/54436.xlsx (with props)
Modified:
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
poi/trunk/src/resources/main/org/apache/poi/ss/formula/function/functionMetadata.txt
Modified:
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java?rev=1451875&r1=1451874&r2=1451875&view=diff
==============================================================================
---
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
(original)
+++
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
Sat Mar 2 11:38:09 2013
@@ -26,6 +26,10 @@ import org.apache.poi.hssf.usermodel.HSS
import org.apache.poi.openxml4j.opc.OPCPackage;
import org.apache.poi.openxml4j.opc.PackagePart;
import org.apache.poi.openxml4j.opc.PackagingURIHelper;
+import org.apache.poi.ss.formula.WorkbookEvaluator;
+import org.apache.poi.ss.formula.eval.ErrorEval;
+import org.apache.poi.ss.formula.eval.ValueEval;
+import org.apache.poi.ss.formula.functions.Function;
import org.apache.poi.ss.usermodel.BaseTestBugzillaIssues;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
@@ -1339,4 +1343,17 @@ public final class TestXSSFBugs extends
assertEquals(259.0, a1Value, 0.0);
}
+ public void test54436(){
+ Workbook workbook =
XSSFTestDataSamples.openSampleWorkbook("54436.xlsx");
+
if(!WorkbookEvaluator.getSupportedFunctionNames().contains("GETPIVOTDATA")){
+ Function func = new Function() {
+ public ValueEval evaluate(ValueEval[] args, int srcRowIndex,
int srcColumnIndex) {
+ return ErrorEval.NA;
+ }
+ };
+
+ WorkbookEvaluator.registerFunction("GETPIVOTDATA", func);
+ }
+ workbook.getCreationHelper().createFormulaEvaluator().evaluateAll();
+ }
}
Modified:
poi/trunk/src/resources/main/org/apache/poi/ss/formula/function/functionMetadata.txt
URL:
http://svn.apache.org/viewvc/poi/trunk/src/resources/main/org/apache/poi/ss/formula/function/functionMetadata.txt?rev=1451875&r1=1451874&r2=1451875&view=diff
==============================================================================
---
poi/trunk/src/resources/main/org/apache/poi/ss/formula/function/functionMetadata.txt
(original)
+++
poi/trunk/src/resources/main/org/apache/poi/ss/formula/function/functionMetadata.txt
Sat Mar 2 11:38:09 2013
@@ -271,13 +271,13 @@
350 ISPMT 4 4 V V V V V
351 DATEDIF 3 3 V V V V
352 DATESTRING 1 1 V V
-353 NUMBERSTRING 2 2 V V V
-354 ROMAN 1 2 V V V
-# New Built-In Sheet Functions in BIFF8
-358 GETPIVOTDATA 2 30
-359 HYPERLINK 1 2 V V V
-360 PHONETIC 1 1 V R
-361 AVERAGEA 1 30 V R ...
+353 NUMBERSTRING 2 2 V V V
+354 ROMAN 1 2 V V V
+# New Built-In Sheet Functions in BIFF8
+358 GETPIVOTDATA 2 30 V V R ...
+359 HYPERLINK 1 2 V V V
+360 PHONETIC 1 1 V R
+361 AVERAGEA 1 30 V R ...
362 MAXA 1 30 V R ...
363 MINA 1 30 V R ...
364 STDEVPA 1 30 V R ...
Added: poi/trunk/test-data/spreadsheet/54436.xlsx
URL:
http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/54436.xlsx?rev=1451875&view=auto
==============================================================================
Binary file - no diff available.
Propchange: poi/trunk/test-data/spreadsheet/54436.xlsx
------------------------------------------------------------------------------
svn:mime-type = application/vnd.ms-excel
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
