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 2016/07/05 07:24:14 UTC
svn commit: r1751400 -
/poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java
Author: centic
Date: Tue Jul 5 07:24:14 2016
New Revision: 1751400
URL: http://svn.apache.org/viewvc?rev=1751400&view=rev
Log:
Add a unit-test to verify that DataFormatter.formatCellValue() does format formula-results correctly
Modified:
poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java
Modified: poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java?rev=1751400&r1=1751399&r2=1751400&view=diff
==============================================================================
--- poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java (original)
+++ poi/trunk/src/testcases/org/apache/poi/ss/usermodel/TestDataFormatter.java Tue Jul 5 07:24:14 2016
@@ -32,10 +32,12 @@ import java.util.Calendar;
import java.util.Date;
import java.util.Locale;
+import org.apache.poi.hssf.HSSFTestDataSamples;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.TestHSSFDataFormatter;
import org.apache.poi.ss.format.CellFormat;
import org.apache.poi.ss.format.CellFormatResult;
+import org.apache.poi.ss.util.CellReference;
import org.apache.poi.ss.util.NumberToTextConverter;
import org.apache.poi.util.LocaleUtil;
import org.apache.poi.util.SuppressForbidden;
@@ -775,4 +777,22 @@ public class TestDataFormatter {
wb.close();
}
}
+
+ @Test
+ public void testFormulaEvaluation() throws IOException {
+ Workbook wb = HSSFTestDataSamples.openSampleWorkbook("FormulaEvalTestData.xls");
+
+ CellReference ref = new CellReference("D47");
+
+ Cell cell = wb.getSheetAt(0).getRow(ref.getRow()).getCell(ref.getCol());
+ //noinspection deprecation
+ assertEquals(CellType.FORMULA, cell.getCellTypeEnum());
+ assertEquals("G9:K9 I7:I12", cell.getCellFormula());
+
+ DataFormatter formatter = new DataFormatter();
+ FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
+ assertEquals("5.6789", formatter.formatCellValue(cell, evaluator));
+
+ wb.close();
+ }
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org