You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by fa...@apache.org on 2023/03/07 22:03:58 UTC
svn commit: r1908173 - /poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java
Author: fanningpj
Date: Tue Mar 7 22:03:58 2023
New Revision: 1908173
URL: http://svn.apache.org/viewvc?rev=1908173&view=rev
Log:
sxssf date style test
Modified:
poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java
Modified: poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java?rev=1908173&r1=1908172&r2=1908173&view=diff
==============================================================================
--- poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java (original)
+++ poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/streaming/TestSXSSFWorkbook.java Tue Mar 7 22:03:58 2023
@@ -34,6 +34,7 @@ import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
+import java.time.LocalDate;
import java.util.Arrays;
import org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream;
@@ -43,7 +44,9 @@ import org.apache.poi.openxml4j.opc.OPCP
import org.apache.poi.openxml4j.opc.PackageAccess;
import org.apache.poi.ss.tests.usermodel.BaseTestXWorkbook;
import org.apache.poi.ss.usermodel.Cell;
+import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CellType;
+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;
@@ -648,6 +651,31 @@ public final class TestSXSSFWorkbook ext
}
}
+ @Test
+ void dateStyle() throws IOException {
+ try (
+ SXSSFWorkbook workbook = new SXSSFWorkbook();
+ UnsynchronizedByteArrayOutputStream bos = new UnsynchronizedByteArrayOutputStream()
+ ) {
+ SXSSFSheet sheet = workbook.createSheet();
+ SXSSFRow row = sheet.createRow(0);
+ SXSSFCreationHelper createHelper = (SXSSFCreationHelper) workbook.getCreationHelper();
+ CellStyle cellStyle = workbook.createCellStyle();
+ cellStyle.setDataFormat(createHelper.createDataFormat().getFormat("dd.MM.yyyy"));
+ SXSSFCell cell = row.createCell(0);
+ cell.setCellValue(LocalDate.parse("2023-03-07"));
+ cell.setCellStyle(cellStyle);
+ workbook.write(bos);
+
+ try (XSSFWorkbook xssfWorkbook = new XSSFWorkbook(bos.toInputStream())) {
+ XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(0);
+ DataFormatter dataFormatter = new DataFormatter();
+ final String result = dataFormatter.formatCellValue(xssfSheet.getRow(0).getCell(0));
+ assertEquals("07.03.2023", result);
+ }
+ }
+ }
+
@Override
@Disabled("not implemented")
protected void changeSheetNameWithSharedFormulas() {
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org