This update contains the following features and improvements:

• Starting from this version JExcel supports Excel 2013 and Excel 2016.
• A new EntireRange class for entire rows and columns is introduced; this new class provides the possibility to hide or show an entire row or column.
• A new Worksheet.fillWithArray(String range, Variant[][] content) method is added. This method simplifies work with bulk operations; the Range.getValues() method returned a Variant array, but the existing Worksheet.fillWithArray implementations accepted only strings, numbers and dates. The new method overload resolved this mismatch and it is not necessary to convert the data on Java side anymore.
• We also added an ability to determine if a document is saved using SaveAs method by adding support of WorkbookEventListener.beforeSaveAs() Workbook event. In the previous version, it was impossible to determine which command (Save or Save As) was used to save the workbook when the beforeSave() event is received. To distinguish these two actions we have added a separate beforeSaveAs() event.

The following issues are resolved in version 1.8:

• Resource memory initialization in JWorkbook.openWorkbook() method is fixed.
• Native resource leak in Worksheet.insertColumnAfter() method is fixed.
• NPE issue in the Worksheet.equals() method is fixed.
• BufferUnderflowException in multi-threaded environment is fixed.