slaubach 2002/10/04 13:33:22
Modified: src/testcases/org/apache/poi/hssf/usermodel
TestWorkbook.java
Log:
Added test case to ensure that user defined formats get written to the file and then
read back properly. Helps ensure bugs like
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=13248 does not reoccur.
Revision Changes Path
1.7 +49 -1
jakarta-poi/src/testcases/org/apache/poi/hssf/usermodel/TestWorkbook.java
Index: TestWorkbook.java
===================================================================
RCS file:
/home/cvs/jakarta-poi/src/testcases/org/apache/poi/hssf/usermodel/TestWorkbook.java,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- TestWorkbook.java 11 Sep 2002 02:30:43 -0000 1.6
+++ TestWorkbook.java 4 Oct 2002 20:33:22 -0000 1.7
@@ -253,9 +253,57 @@
sheet.getRow(( short ) 0).getCell(( short ) 0);
assertEquals(1.25,cell.getNumericCellValue(), 1e-10);
-
assertEquals(format.getFormat(cell.getCellStyle().getDataFormat()), "0.0");
+ stream.close();
+ }
+
+/**
+ * TEST NAME: Test Read/Write Simple w/ Data Format<P>
+ * OBJECTIVE: Test that HSSF can write a sheet with custom data formats and
then read it and get the proper formats.<P>
+ * SUCCESS: HSSF reads the sheet. Matches values in their particular
positions and format is correct<P>
+ * FAILURE: HSSF does not read a sheet or excepts. HSSF cannot identify
values
+ * in the sheet in their known positions.<P>
+ *
+ */
+
+ public void testWriteDataFormat()
+ throws IOException
+ {
+ File file = File.createTempFile("testWriteDataFormat",
+ ".xls");
+ System.err.println(file);
+ FileOutputStream out = new FileOutputStream(file);
+ HSSFWorkbook wb = new HSSFWorkbook();
+ HSSFSheet s = wb.createSheet();
+ HSSFRow r = null;
+ HSSFCell c = null;
+ HSSFDataFormat format = wb.createDataFormat();
+ HSSFCellStyle cs = wb.createCellStyle();
+
+ short df = format.getFormat("0.0");
+ cs.setDataFormat(df);
+
+ r = s.createRow((short)0);
+ c = r.createCell((short)0);
+ c.setCellStyle(cs);
+ c.setCellValue(1.25);
+
+ wb.write(out);
+ out.close();
+
+ FileInputStream stream = new FileInputStream(file);
+ POIFSFileSystem fs = new POIFSFileSystem(stream);
+ HSSFWorkbook workbook = new HSSFWorkbook(fs);
+ HSSFSheet sheet = workbook.getSheetAt(0);
+ HSSFCell cell =
+ sheet.getRow(( short ) 0).getCell(( short ) 0);
+ format = workbook.createDataFormat();
+
+ assertEquals(1.25,cell.getNumericCellValue(), 1e-10);
+
+ assertEquals(format.getFormat(df), "0.0");
+
stream.close();
}
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
