Author: fanningpj
Date: Mon Feb 21 17:44:20 2022
New Revision: 1898282
URL: http://svn.apache.org/viewvc?rev=1898282&view=rev
Log:
add tests
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestIndirect.java
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestIndirect.java
URL:
http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestIndirect.java?rev=1898282&r1=1898281&r2=1898282&view=diff
==============================================================================
---
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestIndirect.java
(original)
+++
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestIndirect.java
Mon Feb 21 17:44:20 2022
@@ -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);
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
