svn commit: r1611833 - /poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaParser.java

[ni...@apache.org]

Author: nick
Date: Fri Jul 18 23:02:51 2014
New Revision: 1611833

URL: http://svn.apache.org/r1611833
Log:
Stub the unit test which is the next thing to need to work for progress on #56737

Modified:
    poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaParser.java

Modified: poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaParser.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaParser.java?rev=1611833&r1=1611832&r2=1611833&view=diff
==============================================================================
--- poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaParser.java (original)
+++ poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaParser.java Fri Jul 18 23:02:51 2014
@@ -19,13 +19,14 @@ package org.apache.poi.xssf.usermodel;
 
 import junit.framework.TestCase;
 
-import org.apache.poi.ss.formula.ptg.Ptg;
-import org.apache.poi.ss.formula.ptg.RefPtg;
-import org.apache.poi.ss.formula.ptg.IntPtg;
-import org.apache.poi.ss.formula.ptg.FuncPtg;
 import org.apache.poi.ss.formula.FormulaParseException;
 import org.apache.poi.ss.formula.FormulaParser;
 import org.apache.poi.ss.formula.FormulaType;
+import org.apache.poi.ss.formula.ptg.FuncPtg;
+import org.apache.poi.ss.formula.ptg.IntPtg;
+import org.apache.poi.ss.formula.ptg.Ptg;
+import org.apache.poi.ss.formula.ptg.RefPtg;
+import org.apache.poi.xssf.XSSFTestDataSamples;
 
 public final class TestXSSFFormulaParser extends TestCase {
 
@@ -88,4 +89,26 @@ public final class TestXSSFFormulaParser
         assertTrue("", ptgs[0] instanceof IntPtg);
         assertTrue("", ptgs[1] instanceof FuncPtg);
     }
+    
+    public void DISABLEDtestFormulaReferencesOtherWorkbook() {
+        // Use a test file with the external linked table in place
+        XSSFWorkbook wb = XSSFTestDataSamples.openSampleWorkbook("ref-56737.xlsx");
+        XSSFEvaluationWorkbook fpb = XSSFEvaluationWorkbook.create(wb);
+        Ptg[] ptgs;
+
+        // Reference to a single cell in a different workbook
+        ptgs = parse(fpb, "[1]Uses!$A$1");
+        assertEquals(1, ptgs.length);
+        // TODO assert
+        
+        // Reference to a sheet-scoped named range in a different workbook
+        ptgs = parse(fpb, "[1]Defines!NR_To_A1");
+        assertEquals(1, ptgs.length);
+        // TODO assert
+        
+        // Reference to a global named range in a different workbook
+        ptgs = parse(fpb, "[1]!NR_Global_B2");
+        assertEquals(1, ptgs.length);
+        // TODO assert
+    }
 }



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org