You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by fa...@apache.org on 2021/12/06 10:10:16 UTC
svn commit: r1895613 - in /poi/trunk: poi-ooxml/src/test/java/org/apache/poi/xssf/TestXLookupFunction.java poi-ooxml/src/test/java/org/apache/poi/xssf/TestXSSFXLookupFunction.java test-data/spreadsheet/xlookup.xlsx
Author: fanningpj
Date: Mon Dec 6 10:10:16 2021
New Revision: 1895613
URL: http://svn.apache.org/viewvc?rev=1895613&view=rev
Log:
add xlookup test
Added:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXSSFXLookupFunction.java
- copied, changed from r1895612, poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXLookupFunction.java
poi/trunk/test-data/spreadsheet/xlookup.xlsx (with props)
Removed:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXLookupFunction.java
Copied: poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXSSFXLookupFunction.java (from r1895612, poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXLookupFunction.java)
URL: http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXSSFXLookupFunction.java?p2=poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXSSFXLookupFunction.java&p1=poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXLookupFunction.java&r1=1895612&r2=1895613&rev=1895613&view=diff
==============================================================================
--- poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXLookupFunction.java (original)
+++ poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/TestXSSFXLookupFunction.java Mon Dec 6 10:10:16 2021
@@ -31,7 +31,7 @@ import static org.junit.jupiter.api.Asse
/**
* Testcase for function XLOOKUP()
*/
-public class TestXLookupFunction {
+public class TestXSSFXLookupFunction {
//https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929
@@ -52,6 +52,20 @@ public class TestXLookupFunction {
}
}
+ @Test
+ void testXLookupFile() throws Exception {
+ try (XSSFWorkbook workbook = XSSFTestDataSamples.openSampleWorkbook("xlookup.xlsx")) {
+ XSSFSheet sheet = workbook.getSheetAt(0);
+ XSSFFormulaEvaluator fe = new XSSFFormulaEvaluator(workbook);
+ XSSFRow row1 = sheet.getRow(1);
+ assertEquals("Dianne Pugh", row1.getCell(2).getStringCellValue());
+ assertEquals("Finance", row1.getCell(3).getStringCellValue());
+ fe.evaluateAll();
+ row1 = sheet.getRow(1);
+ assertEquals("Dianne Pugh", row1.getCell(2).getStringCellValue());
+ assertEquals("Finance", row1.getCell(3).getStringCellValue());
+ }
+ }
private XSSFWorkbook initWorkbook2() {
XSSFWorkbook wb = new XSSFWorkbook();
Added: poi/trunk/test-data/spreadsheet/xlookup.xlsx
URL: http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/xlookup.xlsx?rev=1895613&view=auto
==============================================================================
Binary file - no diff available.
Propchange: poi/trunk/test-data/spreadsheet/xlookup.xlsx
------------------------------------------------------------------------------
--- svn:mime-type (added)
+++ svn:mime-type Mon Dec 6 10:10:16 2021
@@ -0,0 +1 @@
+application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org