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.

Bugfixes and improvements:

• Improved performance of the Worksheet.fillWithArray(Cell, ...) methods;
• Fixed memory management issues in the fillWithArray() methods;
• Fixed NPE in implementation of Cell.equals() method;
• Fixed the issue in Font.setColor() mehtod when it did not work properly with Color.white.
• Added new Range.getText() and Cell.getText() methods;
• Added VM parameter -Dteamdev.jexcel.ignoreRemoteRequests for disabling usage of IgnoreRemoteRequests ("Ignore other applications that use Dynamic Data Exchange (DDE)") option. JExcel will not disable DDE requests in Excel if -Dteamdev.jexcel.ignoreRemoteRequests=false VM parameter is specified;
• Fixed IOException in JWorkbook.save() method when trying to save to existing file;
• Fixed the issue in JWorkbook.saveAs() method when it added improper extension to the file name;
• Fixed memory leaks in the Range.find(), Range.findNext() methods;
• Resolved the cause of ComException in Workbook.equals() method;
• Fixed the issue with switching focus between JWorkbook and Excel windows;
• Fixed the flickering issue while updating inactive JWorkbook component;
• Fixed cyclic focus switching in several JWorkbooks;
• Resolved issue in Cell.getColumnName() so now it return a column name without a row index;
• Resolved the issue when JWorkbook doesn't work correctly without adding it to a parent container (JFrame);
• Fixed memory management issues in Cell.isNumber(), Cell.isLogical(), Cell.isText(), Cell.isError() methods;
• Fixed the issues with displaying JWorkbook component in inactive state;
• Fixed the issue with returning incorrect value in Range.getInteriorPatternColor() method;

New features and improvements:

• Added support of Windows 8 (32-bit and 64-bit modes);
• Added support of JDK 1.7;
• Improved automatic memory management;
• Extended API with the new methods, such as:
  • Range.getColumnName() - returns column name of the range;
  • Range.getEntireColumn() - returns an entire column;
  • Range.setWrapText(boolean) - wrapping of the text in cells, columns or rows;
  • Application.getSelection() - returns the selected object in the active window;
  • Application.getNames() - returns an array of names in the active workbook.
  • Aplication.openWorkbook(File file, boolean readOnly, String password, String writePassword), GenericWorkbook.setWritePassword(String password) - methods for working with write protection passwords;
• Added new event listeners for the following Excel events:
  • windowActivate, windowResize, windowDeactivate;
  • pivotTableUpdate, pivotTableOpenConnection, pivotTableCloseConnection;
  • followHyperlink.

Resolved Issues:

• Fixed memory leak issues in JExcel wrappers, methods and event handling functionality;
• Fixed focus handling issues in JWorkbook component;
• Fixed the issue with unloading EXCEL.EXE process after closing a JWorkbook component;
• Resolved the issue with embedding JWorkbook component to JInternalFrame container;
• Fixed incorrect return value in the Cell.getNumber() method for double and float types;
• Fixed memory leak in the Variant[][] Range.getValues() method;
• Fixed memory leak in the Worksheet.fillWithArray(String range, String[][] content) method;
• Fixed the issue in the Range.getValues() method so now the returned date values have proper VT_DATE variant type;
• Fixed the issue with switching between opened JWorkbook and another Excel documents using Alt+Tab keystroke, or mouse by mouse click;
• Resolved performance issues in the Worksheet.fillWithArray() methods;
• Fixed AutomationException in the Cell.setAutoFit() method;
• Fixed the issue with the opening of the several files in the same JWorkbook component;
• Fixed the issues in the JWorkbook.saveCopyAs(), JWorkbook.save() and JWorkbook.saveAs() methods.

New Features:

• Added support of 64-bit platform;
• Generation of appropriate events for worksheets which have been added by copying;
• Added support of Excel 2010 32/64-bit.

Resolved Issues:

• Memory leak in Worksheet.getCell() and Cell.getString() methods;
• Keyboard handling issue when JExcel cannot process arrow keys after losing and getting focus back;
• Several focus handling issues in JWorkbook component;
• Excel process is now released correctly after the application is closed.