I made an attempt to clean up the bug database. Here is the first portion of HSSF bugs that are fixed and can be closed. I added a unit test per bug to org.apache.poi.hssf.usermodel.TestBugs The following issues should be closed after the patch is applied: 25183 org.apache.poi.hssf.usermodel.HSSFSheet.setPropertiesFromSheet 26100 128-character message in IF statement cell causes HSSFWorkbook open failure 27933 Unable to use a template (xls) file containing a wmf graphic 29206 NPE on HSSFSheet.getRow for blank rows 29675 POI 2.5 final corrupts output when starting workbook has a graphic 29942 Importing Excel files that have been created by Open Office on Linux 29982 Unable to read spreadsheet when dropdown list cell is sel... 30540 HSSFSheet.setRowBreak throws NullPointerException 31749 {Need help urgently}[This is critical] workbook.write() corrupts the file......? 31979 {urgent help needed .....}poi library does not support form objects properly. 35564 HSSFCell.java: NullPtrExc in isGridsPrinted() and getProtect() when HSSFWorkbook is created from file 35565 HSSFCell.java: NullPtrExc in getColumnBreaks() when HSSFWorkbook is created from file 37376 Cannot open the saved Excel file if checkbox controls exceed certain limit 40285 CellIterator Skips First Column 40296 HSSFCell.setCellFormula throws ClassCastException if cell is created using HSSFRow.createCell(short column, int type) These are "good" bugs. Each has a test case so the task came to writing a unit test per bug to see if there are still exceptions when reading/writing etc. Other bugs require more time to investigate and understand what's wrong. Shout if there are bugs you are still working with. Yegor
Created attachment 19404 [details] more unit tests added to org.apache.poi.hssf.usermodel.TestBugs
Created attachment 19405 [details] test xls files to add to HSSF.testdata.path
committed. Need to check if 37376 is fixed, since the bug report stated that the user cannot open the file in excel. Yegor, can you confirm that?
Avik, thanks. >>Need to check if 37376 is fixed, since the bug report stated that the >>user cannot open the file in excel. Yegor, can you confirm that? Yes, I can confirm that the file can be opened in excel. We can close this issue. Yegor
Thanks Yegor, this bug was a massive effort!!