Mailing-List: contact commits-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@poi.apache.org
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r1808932 -
 /poi/trunk/src/testcases/org/apache/poi/ss/usermodel/BaseTestFormulaEvaluator.java
Date: Tue, 19 Sep 2017 19:19:30 -0000
To: commits@poi.apache.org
From: centic@apache.org
Message-Id: <20170919191934.722A33A01AB@svn01-us-west.apache.org>
archived-at: Tue, 19 Sep 2017 19:19:37 -0000

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