svn commit: r1918817 - in /poi/trunk: poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/ poi/src/test/java/org/apache/poi/hssf/usermodel/ poi/src/test/java/org/apache/poi/ss/usermodel/

[fanningpj]

Author: fanningpj
Date: Tue Jul  2 09:08:40 2024
New Revision: 1918817

URL: http://svn.apache.org/viewvc?rev=1918817&view=rev
Log:
another dataformatter test

Modified:
    
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataFormat.java
    
poi/trunk/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFDataFormat.java
    
poi/trunk/poi/src/test/java/org/apache/poi/ss/usermodel/BaseTestDataFormat.java

Modified: 
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataFormat.java
URL: 
http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataFormat.java?rev=1918817&r1=1918816&r2=1918817&view=diff
==============================================================================
--- 
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataFormat.java
 (original)
+++ 
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestXSSFDataFormat.java
 Tue Jul  2 09:08:40 2024
@@ -28,6 +28,7 @@ import org.apache.poi.ss.formula.Workboo
 import org.apache.poi.ss.usermodel.BaseTestDataFormat;
 import org.apache.poi.ss.usermodel.Cell;
 import org.apache.poi.ss.usermodel.CellStyle;
+import org.apache.poi.ss.usermodel.DataFormat;
 import org.apache.poi.ss.usermodel.DataFormatter;
 import org.apache.poi.ss.usermodel.FormulaEvaluator;
 import org.apache.poi.ss.usermodel.Workbook;
@@ -158,18 +159,5 @@ public final class TestXSSFDataFormat ex
             */
         }
     }
-
-    @Test
-    public void testFormatCellValueDecimal() throws IOException {
-        DataFormatter df = new DataFormatter();
-
-        try (Workbook wb = new XSSFWorkbook()) {
-            Cell cell = wb.createSheet("test").createRow(0).createCell(0);
-            assertEquals("", df.formatCellValue(cell));
-
-            cell.setCellValue(1.005);
-            assertEquals("1.005", df.formatCellValue(cell));
-        }
-    }
-
+    
 }

Modified: 
poi/trunk/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFDataFormat.java
URL: 
http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFDataFormat.java?rev=1918817&r1=1918816&r2=1918817&view=diff
==============================================================================
--- 
poi/trunk/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFDataFormat.java
 (original)
+++ 
poi/trunk/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFDataFormat.java
 Tue Jul  2 09:08:40 2024
@@ -29,8 +29,11 @@ import org.apache.poi.hssf.HSSFITestData
 import org.apache.poi.ss.usermodel.BaseTestDataFormat;
 import org.apache.poi.ss.usermodel.Cell;
 import org.apache.poi.ss.usermodel.CellStyle;
+import org.apache.poi.ss.usermodel.DataFormat;
+import org.apache.poi.ss.usermodel.DataFormatter;
 import org.apache.poi.ss.usermodel.Row;
 import org.apache.poi.ss.usermodel.Sheet;
+import org.apache.poi.ss.usermodel.Workbook;
 import org.junit.jupiter.api.Test;
 
 /**

Modified: 
poi/trunk/poi/src/test/java/org/apache/poi/ss/usermodel/BaseTestDataFormat.java
URL: 
http://svn.apache.org/viewvc/poi/trunk/poi/src/test/java/org/apache/poi/ss/usermodel/BaseTestDataFormat.java?rev=1918817&r1=1918816&r2=1918817&view=diff
==============================================================================
--- 
poi/trunk/poi/src/test/java/org/apache/poi/ss/usermodel/BaseTestDataFormat.java 
(original)
+++ 
poi/trunk/poi/src/test/java/org/apache/poi/ss/usermodel/BaseTestDataFormat.java 
Tue Jul  2 09:08:40 2024
@@ -273,4 +273,24 @@ public abstract class BaseTestDataFormat
             assertEquals("12'345'678", formatter.formatCellValue(lge));
         }
     }
+
+    @Test
+    public void testFormatCellValueDecimal() throws IOException {
+        DataFormatter df = new DataFormatter();
+
+        try (Workbook wb = _testDataProvider.createWorkbook()) {
+            Cell cell = wb.createSheet("test").createRow(0).createCell(0);
+            assertEquals("", df.formatCellValue(cell));
+
+            cell.setCellValue(1.005);
+            assertEquals("1.005", df.formatCellValue(cell));
+
+            DataFormat format = wb.createDataFormat();
+            CellStyle cellStyle = wb.createCellStyle();
+            cellStyle.setDataFormat(format.getFormat("0.00"));
+            cell.setCellStyle(cellStyle);
+            assertEquals("1.01", df.formatCellValue(cell));
+        }
+    }
+
 }



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@poi.apache.org
For additional commands, e-mail: commits-h...@poi.apache.org