Bug 24355

This bug is present on both Win32 and Solaris Sparc.

When trying to create a spreadsheet with over 8215 datapoints, the resultant 
xls file becomes corrupt. Excel attempts to repair the document, but some of 
the data at the end of the file is lost. The following are the maximum sizes of 
spreadsheets I could create w/o corruption:

8215 rows, 1 column
4107 rows, 2 columns
2738 rows, 3 columns

I am using JDK 1.4.2. I am using Excel 2002 SP-2.

The following is the code I used to produce the problem:

    public void createFile(String filename, int height, short width) throws 
Exception {
        FileOutputStream fileOut = new FileOutputStream(filename);
        
        HSSFWorkbook wb;
        HSSFSheet sheet;
        HSSFRow row;
        HSSFCell cell;
        
        int counter = 0;
        
        wb = new HSSFWorkbook();
        sheet = wb.createSheet("Test sheet");
        
        for (int i = 0; i < height; ++i) {
            row = sheet.createRow(i);
                       
            for (short s = 0; s < width; ++s) {
                ++counter;
                
                cell = row.createCell(s);
                cell.setCellValue(String.valueOf(counter));
            }
        }
        
        wb.write(fileOut);
        fileOut.close();        
    }