diff options
| author | PJ Fanning <fanningpj@apache.org> | 2021-12-03 12:16:30 +0000 |
|---|---|---|
| committer | PJ Fanning <fanningpj@apache.org> | 2021-12-03 12:16:30 +0000 |
| commit | f33217b9e4bff9fc5e78deeaff254debb4be7a59 (patch) | |
| tree | d9e69dc37853f7df23208bac3bd9ef69fc95484b /poi/src | |
| parent | 37573b3b4e6c0b6ad55959a013748c434bd45513 (diff) | |
| download | poi-f33217b9e4bff9fc5e78deeaff254debb4be7a59.tar.gz poi-f33217b9e4bff9fc5e78deeaff254debb4be7a59.zip | |
add xlookup tests
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1895547 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'poi/src')
| -rw-r--r-- | poi/src/test/java/org/apache/poi/ss/formula/atp/TestXLookupFunction.java | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/poi/src/test/java/org/apache/poi/ss/formula/atp/TestXLookupFunction.java b/poi/src/test/java/org/apache/poi/ss/formula/atp/TestXLookupFunction.java index b50a2e5bc5..17f7f1f304 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/atp/TestXLookupFunction.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/atp/TestXLookupFunction.java @@ -41,6 +41,11 @@ public class TestXLookupFunction { HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb); HSSFCell cell = wb.getSheetAt(0).getRow(0).createCell(100); assertString(fe, cell, "XLOOKUP(F2,B2:B11,D2:D11)", "+55"); + assertString(fe, cell, "XLOOKUP(\"Brazil\",B2:B11,D2:D11)", "+55"); + assertString(fe, cell, "XLOOKUP(\"brazil\",B2:B11,D2:D11)", "+55"); + //wildcard lookups + assertString(fe, cell, "XLOOKUP(\"brazil\",B2:B11,D2:D11,,2)", "+55"); + assertString(fe, cell, "XLOOKUP(\"b*l\",B2:B11,D2:D11,,2)", "+55"); } } |