poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 15375] - Post 1.5.1 POI causes spreadsheet to become unopenable.
Date Wed, 15 Jan 2003 16:57:49 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15375>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15375

Post 1.5.1 POI causes spreadsheet to become unopenable.





------- Additional Comments From chris.haddad@cobia.net  2003-01-15 16:57 -------
Here is the code that corrupts the xls file (1/15/03 16:53 attachment to this 
bug report) when using the 1.9.0 nightly build from 20030115:

    public void poiXlsTest() {      
      
      try {
    POIFSFileSystem fs      =
            new POIFSFileSystem(new FileInputStream
("/usr/local/data/dashView.xls"));
    HSSFWorkbook wb = new HSSFWorkbook(fs);
    HSSFSheet sheet = wb.getSheetAt(0);
    
    HSSFRow row = sheet.getRow(5);
    HSSFCell cell = row.getCell((short)3);
    if (cell == null)
        cell = row.createCell((short)3);
        
        // Write test
    cell.setCellType(HSSFCell.CELL_TYPE_STRING);
    cell.setCellValue("a test");

        // change existing numeric cell value
    log.debug("change existing numeric cell");
    HSSFRow oRow = sheet.getRow(14);
    HSSFCell oCell = oRow.getCell((short)4);
    oCell.setCellValue(75);
    oCell = oRow.getCell((short)5);
    oCell.setCellValue("0.3");
    
    // Write the output to a file
    FileOutputStream fileOut = new FileOutputStream("/usr/local/data/dashView-
1.xls");
    wb.write(fileOut);
    fileOut.close();
  }
  catch (java.io.FileNotFoundException ex)
  {
    log.error(ex.getMessage());
  }
  catch (java.io.IOException ex)
  {
    log.error(ex.getMessage());
  }
  
  }

Mime
View raw message