There are setDisplayGridlines() and other methods, which call protected Sheet HSSFSheet.getSheet() and then Sheet.windowTwo.setDisplayGridlines(). There is setDisplayZeros() method in WindowTwoRecord class, but it can't be called from HSSFSheet. Fix of it is easy to implement by adding getter/setter methods to HSSFSheet and Sheet. Currently the way to implement it is using of reflection: Field sheetField = HSSFSheet.class.getDeclaredField( "sheet" ); sheetField.setAccessible( true ); Sheet sheet = (Sheet)sheetField.get( hssfSheet ); Field windowTwoRecordField = Sheet.class.getDeclaredField( "windowTwo" ); windowTwoRecordField.setAccessible( true ); WindowTwoRecord windowTwoRecord = (WindowTwoRecord)windowTwoRecordField.get( sheet ); windowTwoRecord.setDisplayZeros( false );
Fixed in r747307. I added setDisplayZeros / isDisplayZeros to HSSFSheet, XSSFSHeet and common interface org.apache.poi.ss.usermodel.Sheet. Regards, Yegor