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: [email protected]
For additional commands, e-mail: [email protected]
