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 2021/10/08 08:10:17 UTC

svn commit: r1894016 - /poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFBugs.java

Author: fanningpj
Date: Fri Oct  8 08:10:17 2021
New Revision: 1894016

URL: http://svn.apache.org/viewvc?rev=1894016&view=rev
Log:
add test case from bug-65619

Modified:
    poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFBugs.java

Modified: poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFBugs.java
URL: http://svn.apache.org/viewvc/poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFBugs.java?rev=1894016&r1=1894015&r2=1894016&view=diff
==============================================================================
--- poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFBugs.java (original)
+++ poi/trunk/poi-ooxml/src/test/java/org/apache/poi/xssf/usermodel/TestSXSSFBugs.java Fri Oct  8 08:10:17 2021
@@ -28,13 +28,9 @@ import java.io.FileOutputStream;
 import java.io.IOException;
 import java.util.Date;
 
+import org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream;
 import org.apache.poi.ss.ITestDataProvider;
-import org.apache.poi.ss.usermodel.BaseTestBugzillaIssues;
-import org.apache.poi.ss.usermodel.Cell;
-import org.apache.poi.ss.usermodel.PrintSetup;
-import org.apache.poi.ss.usermodel.Row;
-import org.apache.poi.ss.usermodel.Sheet;
-import org.apache.poi.ss.usermodel.Workbook;
+import org.apache.poi.ss.usermodel.*;
 import org.apache.poi.ss.util.CellRangeAddress;
 import org.apache.poi.xssf.SXSSFITestDataProvider;
 import org.apache.poi.xssf.XSSFITestDataProvider;
@@ -245,4 +241,37 @@ public final class TestSXSSFBugs extends
             }
         }
     }
+
+    @Test
+    void test65619() throws Exception {
+        try (UnsynchronizedByteArrayOutputStream bos = new UnsynchronizedByteArrayOutputStream()) {
+            try (SXSSFWorkbook workbook = new SXSSFWorkbook(100)) {
+                SXSSFSheet sheet = workbook.createSheet("Test Sheet 1");
+                Font font = workbook.createFont();
+                font.setItalic(true);
+                CellStyle cs = workbook.createCellStyle();
+                cs.setFont(font);
+                Row row = sheet.createRow(0);
+                Cell cell = row.createCell(1);
+                cell.setCellValue(new Date());
+                cell.setCellStyle(cs);
+                CreationHelper ch = workbook.getCreationHelper();
+                cs.setDataFormat(ch.createDataFormat().getFormat("dd MMM yyyy HH:mm:ss"));
+                cs.setAlignment(HorizontalAlignment.RIGHT);
+                workbook.write(bos);
+            }
+            try (XSSFWorkbook workbook = new XSSFWorkbook(bos.toInputStream())) {
+                XSSFSheet sheet = workbook.getSheet("Test Sheet 1");
+                XSSFRow row = sheet.getRow(0);
+                XSSFCell cell = row.getCell(1);
+                XSSFCellStyle cs = cell.getCellStyle();
+                assertNotNull(cs, "cell should have style");
+                assertEquals(HorizontalAlignment.RIGHT, cs.getCellAlignment().getHorizontal());
+                assertEquals("dd MMM yyyy HH:mm:ss", cs.getDataFormatString());
+                XSSFFont font = cs.getFont();
+                assertNotNull(font, "style should have font");
+                assertTrue(font.getItalic(), "saved font is italic");
+            }
+        }
+    }
 }



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