Author: centic Date: Sun Jun 30 22:47:26 2013 New Revision: 1498190 URL: http://svn.apache.org/r1498190 Log: Bug 54084: Add testcase which reproduces the bug, no fix available yet
Added: poi/trunk/test-data/spreadsheet/54084 - Greek - beyond BMP.txt poi/trunk/test-data/spreadsheet/54084 - Greek - beyond BMP.xlsx Modified: poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java Modified: poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java URL: http://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java?rev=1498190&r1=1498189&r2=1498190&view=diff ============================================================================== --- poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java (original) +++ poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java Sun Jun 30 22:47:26 2013 @@ -17,13 +17,22 @@ package org.apache.poi.hssf.usermodel; +import java.io.IOException; +import java.io.UnsupportedEncodingException; + import junit.framework.AssertionFailedError; import junit.framework.TestCase; import org.apache.poi.hssf.HSSFTestDataSamples; import org.apache.poi.hssf.record.RecordFormatException; - -import java.io.IOException; +import org.apache.poi.ss.usermodel.Cell; +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.xssf.SXSSFITestDataProvider; +import org.apache.poi.xssf.XSSFTestDataSamples; +import org.apache.poi.xssf.streaming.SXSSFWorkbook; +import org.apache.poi.xssf.usermodel.XSSFWorkbook; /** * @author aviks @@ -77,4 +86,40 @@ public final class TestUnfixedBugs exten assertEquals("evaluating e1", 30., eval.evaluate(e1).getNumberValue()); } + + public void testBug54084Unicode() throws IOException { + // sample XLSX with the same text-contents as the text-file above + XSSFWorkbook wb = XSSFTestDataSamples.openSampleWorkbook("54084 - Greek - beyond BMP.xlsx"); + + verifyBug54084Unicode(wb); + +// OutputStream baos = new FileOutputStream("/tmp/test.xlsx"); +// try { +// wb.write(baos); +// } finally { +// baos.close(); +// } + + // now write the file and read it back in + XSSFWorkbook wbWritten = XSSFTestDataSamples.writeOutAndReadBack(wb); + verifyBug54084Unicode(wbWritten); + + // finally also write it out via the streaming interface and verify that we still can read it back in + Workbook wbStreamingWritten = SXSSFITestDataProvider.instance.writeOutAndReadBack(new SXSSFWorkbook(wb)); + verifyBug54084Unicode(wbStreamingWritten); + } + + private void verifyBug54084Unicode(Workbook wb) throws UnsupportedEncodingException { + // expected data is stored in UTF-8 in a text-file + String testData = new String(HSSFTestDataSamples.getTestDataFileContent("54084 - Greek - beyond BMP.txt"), "UTF-8").trim(); + + Sheet sheet = wb.getSheetAt(0); + Row row = sheet.getRow(0); + Cell cell = row.getCell(0); + + String value = cell.getStringCellValue(); + //System.out.println(value); + + assertEquals("The data in the text-file should exactly match the data that we read from the workbook", testData, value); + } } Added: poi/trunk/test-data/spreadsheet/54084 - Greek - beyond BMP.txt URL: http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/54084%20-%20Greek%20-%20beyond%20BMP.txt?rev=1498190&view=auto ============================================================================== --- poi/trunk/test-data/spreadsheet/54084 - Greek - beyond BMP.txt (added) +++ poi/trunk/test-data/spreadsheet/54084 - Greek - beyond BMP.txt Sun Jun 30 22:47:26 2013 @@ -0,0 +1 @@ +ððððððððððððððððððððððð ð¡ð¢ð£ð¤ð¥ð¦ð§ð¨ð©ðªð«ð¬ðð®ð¯ð°ð±ð²ð³ð´ðµð¶ð·ð¸ð¹ðº Added: poi/trunk/test-data/spreadsheet/54084 - Greek - beyond BMP.xlsx URL: http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/54084%20-%20Greek%20-%20beyond%20BMP.xlsx?rev=1498190&view=auto ============================================================================== Files poi/trunk/test-data/spreadsheet/54084 - Greek - beyond BMP.xlsx (added) and poi/trunk/test-data/spreadsheet/54084 - Greek - beyond BMP.xlsx Sun Jun 30 22:47:26 2013 differ --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@poi.apache.org For additional commands, e-mail: commits-h...@poi.apache.org