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 2022/05/30 10:33:59 UTC
svn commit: r1901408 - /poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestXMatchFunction.java
Author: fanningpj
Date: Mon May 30 10:33:59 2022
New Revision: 1901408
URL: http://svn.apache.org/viewvc?rev=1901408&view=rev
Log:
add lowercase tests
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestXMatchFunction.java
Modified: poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestXMatchFunction.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestXMatchFunction.java?rev=1901408&r1=1901407&r2=1901408&view=diff
==============================================================================
--- poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestXMatchFunction.java (original)
+++ poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestXMatchFunction.java Mon May 30 10:33:59 2022
@@ -45,6 +45,15 @@ public class TestXMatchFunction {
}
@Test
+ void testMicrosoftExample0Lowercase() throws IOException {
+ try (HSSFWorkbook wb = initNumWorkbook("grape")) {
+ HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
+ HSSFCell cell = wb.getSheetAt(0).getRow(2).createCell(5);
+ assertDouble(fe, cell, "XMATCH(E3,C3:C7)", 2);
+ }
+ }
+
+ @Test
void testMicrosoftExample1() throws IOException {
try (HSSFWorkbook wb = initNumWorkbook("Gra?")) {
HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
@@ -57,6 +66,16 @@ public class TestXMatchFunction {
}
}
+ @Test
+ void testMicrosoftExample1Lowercase() throws IOException {
+ try (HSSFWorkbook wb = initNumWorkbook("gra?")) {
+ HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
+ HSSFCell cell = wb.getSheetAt(0).getRow(2).createCell(5);
+ assertDouble(fe, cell, "XMATCH(E3,C3:C7,1)", 2);
+ assertDouble(fe, cell, "XMATCH(E3,C3:C7,-1)", 5);
+ }
+ }
+
@Test
void testMicrosoftExample2() throws IOException {
//the result in this example is correct but the description seems wrong from my testing
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org