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 12:02:24 UTC
svn commit: r1895619 - /poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/atp/TestXMatchFunction.java
Author: fanningpj
Date: Mon Dec 6 12:02:24 2021
New Revision: 1895619
URL: http://svn.apache.org/viewvc?rev=1895619&view=rev
Log:
add xmatch test
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=1895619&r1=1895618&r2=1895619&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 Dec 6 12:02:24 2021
@@ -72,6 +72,16 @@ public class TestXMatchFunction {
}
}
+ @Test
+ void testMicrosoftExample4() throws IOException {
+ try (HSSFWorkbook wb = new HSSFWorkbook()) {
+ HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
+ HSSFCell cell = wb.createSheet().createRow(0).createCell(0);
+ assertDouble(fe, cell, "XMATCH(4,{5,4,3,2,1})", 2);
+ assertDouble(fe, cell, "XMATCH(4.5,{5,4,3,2,1},1)", 1);
+ }
+ }
+
private HSSFWorkbook initNumWorkbook(String lookup) {
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org