Author: fanningpj
Date: Mon Feb 21 13:05:00 2022
New Revision: 1898272
URL: http://svn.apache.org/viewvc?rev=1898272&view=rev
Log:
add tests
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestIndirect.java
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestSumproduct.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=1898272&r1=1898271&r2=1898272&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 13:05:00 2022
@@ -124,8 +124,12 @@ final class TestIndirect {
confirm(feA, c, "SUM(INDIRECT(A4))", 50); // indirect defined name
confirm(feA, c, "SUM(INDIRECT(B4))", 351); // indirect defined name
pointinh to other sheet
+
// simple error propagation:
+ confirm(feA, c, "INDIRECT(\"C\")", ErrorEval.REF_INVALID);
+ confirm(feA, c, "INDIRECT(\"4\")", ErrorEval.REF_INVALID);
+
// arg0 is evaluated to text first
confirm(feA, c, "INDIRECT(#DIV/0!)", ErrorEval.DIV_ZERO);
confirm(feA, c, "INDIRECT(#DIV/0!)", ErrorEval.DIV_ZERO);
Modified:
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestSumproduct.java
URL:
http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestSumproduct.java?rev=1898272&r1=1898271&r2=1898272&view=diff
==============================================================================
---
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestSumproduct.java
(original)
+++
poi/trunk/poi/src/test/java/org/apache/poi/ss/formula/functions/TestSumproduct.java
Mon Feb 21 13:05:00 2022
@@ -133,6 +133,7 @@ final class TestSumproduct {
HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
HSSFCell cell = wb.getSheetAt(0).getRow(0).createCell(100);
assertDouble(fe, cell, "SUMPRODUCT(C2:C5,D2:D5)", 78.97);
+ assertDouble(fe, cell, "SUMPRODUCT(C2:C5=\"Chai\",D2:D5)", 78.97);
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
