diff options
| author | PJ Fanning <fanningpj@apache.org> | 2022-02-21 17:44:20 +0000 |
|---|---|---|
| committer | PJ Fanning <fanningpj@apache.org> | 2022-02-21 17:44:20 +0000 |
| commit | 784c88f0798e63f4b7b450209698d240f943b863 (patch) | |
| tree | b53df1646582c5d3c4b448d3abb57b16dd2be72f /poi | |
| parent | f76a4e7fa0085172d4b9459ac388aac7617af2b0 (diff) | |
| download | poi-784c88f0798e63f4b7b450209698d240f943b863.tar.gz poi-784c88f0798e63f4b7b450209698d240f943b863.zip | |
add tests
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1898282 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'poi')
| -rw-r--r-- | poi/src/test/java/org/apache/poi/ss/formula/functions/TestIndirect.java | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestIndirect.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestIndirect.java index 21d55c9ec7..12c7169dfe 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestIndirect.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestIndirect.java @@ -195,6 +195,9 @@ final class TestIndirect { HSSFFormulaEvaluator feA = new HSSFFormulaEvaluator(wbA); confirm(feA, c, "INDIRECT(\"C[-17]\", FALSE)", 14.0); confirm(feA, c, "INDIRECT(\"C4\", FALSE)", 14.0); + confirm(feA, c, "INDIRECT(\"c4\", FALSE)", 14.0); + confirm(feA, c, "INDIRECT(\"Sheet1!C4\", FALSE)", 14.0); + confirm(feA, c, "INDIRECT(\"CX\", FALSE)", ErrorEval.REF_INVALID); } } @@ -207,7 +210,10 @@ final class TestIndirect { HSSFFormulaEvaluator feA = new HSSFFormulaEvaluator(wbA); confirm(feA, c0, "INDIRECT(\"R[-100]\", FALSE)", 11.0); confirm(feA, c0, "INDIRECT(\"R1\", FALSE)", 11.0); + confirm(feA, c0, "INDIRECT(\"r1\", FALSE)", 11.0); + confirm(feA, c0, "INDIRECT(\"Sheet1!R1\", FALSE)", 11.0); //assertEquals(12.0, c1.getNumericCellValue()); + confirm(feA, c0, "INDIRECT(\"RX\", FALSE)", ErrorEval.REF_INVALID); } } |