You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ce...@apache.org on 2017/09/19 19:19:30 UTC
svn commit: r1808932 -
/poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestFormulaEvaluator.java
Author: centic
Date: Tue Sep 19 19:19:30 2017
New Revision: 1808932
URL: http://svn.apache.org/viewvc?rev=1808932&view=rev
Log:
Add test to verify that bug 61532 is fixed as far as I see via the changes for bug 61148.
Modified:
poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestFormulaEvaluator.java
Modified: poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestFormulaEvaluator.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestFormulaEvaluator.java?rev=1808932&r1=1808931&r2=1808932&view=diff
==============================================================================
--- poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestFormulaEvaluator.java (original)
+++ poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestFormulaEvaluator.java Tue Sep 19 19:19:30 2017
@@ -17,16 +17,13 @@
package org.apache.poi.ss.usermodel;
-import static org.junit.Assert.assertEquals;
-import static org.junit.Assert.assertNull;
-import static org.junit.Assert.assertSame;
-import static org.junit.Assert.fail;
-
import java.io.IOException;
import org.apache.poi.ss.ITestDataProvider;
import org.junit.Test;
+import static org.junit.Assert.*;
+
/**
* Common superclass for testing implementation of {@link FormulaEvaluator}
*/
@@ -600,4 +597,31 @@ public abstract class BaseTestFormulaEva
private Cell getCell(Sheet sheet, int rowNo, int column) {
return sheet.getRow(rowNo).getCell(column);
}
+
+ @Test
+ public void testBug61532() throws IOException {
+ try (Workbook wb = _testDataProvider.createWorkbook()) {
+ final Cell cell = wb.createSheet().createRow(0).createCell(0);
+ cell.setCellFormula("1+2");
+
+ assertEquals(0, (int)cell.getNumericCellValue());
+ assertEquals("1+2", cell.toString());
+
+ FormulaEvaluator eval = wb.getCreationHelper().createFormulaEvaluator();
+
+ CellValue value = eval.evaluate(cell);
+
+ assertEquals(CellType.NUMERIC, value.getCellType());
+ assertEquals(3.0, value.getNumberValue(), 0.01);
+ assertEquals(CellType.FORMULA, cell.getCellType());
+ assertEquals("1+2", cell.getCellFormula());
+ assertEquals("1+2", cell.toString());
+
+ assertNotNull(eval.evaluateInCell(cell));
+
+ assertEquals("3.0", cell.toString());
+ assertEquals(CellType.NUMERIC, cell.getCellType());
+ assertEquals(3.0, cell.getNumericCellValue(), 0.01);
+ }
+ }
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org