What's new in JExcel 1.7
May 16, 2015
- 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 in JExcel 1.6 (May 7, 2013)
- 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 in JExcel 1.5 (Jan 31, 2012)
- 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.
New in JExcel 1.4 (Jan 31, 2012)
- New Features and Improvements:
- Added the delete() method to Range class.
- Updated JExcel FileFormat enumeration with the latest formats.
- The following properties are added to the Window class:
- DisplayGridlines
- DisplayOutline
- DisplayWorkbookTabs
- DisplayHeadings
- DisplayVerticalScrollBar
- DisplayHorizontalScrollBar
- DisplayFormulas
- JExcel Application class has been extended with DisplayAlerts property to allow controlling Excel alerts.
- Added wrappers for ForumulaArray and Formula properties to Range class.
- JExcel is now using the SLF4J Logging Facade that allowing the end user to plug in the desired logging framework at deployment time.
- Added Ctrl+S keyboard shortcut to "Save" option (JExcel Demo).
- Added ability to open several windows of JExcel Demo (JExcel Demo).
- Resolved Issues:
- Issue with opening new Excel file formats.
- Issues with closing Popup menus immediately after opening.
- Excel repainting issues in JWorkbook component.
- Issue with closing EXCEL.EXE process after closing all opened JWorkbook components.
- Memory leak issues with releasing JExcel application.
- Focus handling issues between several opened JWorkbook.
- Conflicts/focus handling issues between opened JWorkbook components and Excel windows.
- Issues with a 'Static View' mode of JWorkbook component.
- Re-parenting issue in JWorkbook component.
- Activation/deactivation issues with Excel toolbar in JWorkbook component.
- Improved stability when switching between opened JWorkbook components and another Excel windows.
- Issue with closing JWorkbook component.
- Layout issues in JWorkbook component.
- Issue with creating multiple JWorkbook components simultaneously.
- Blinking issues when several JWorkbook instances are opened.
- Issue with opening "Print Preview" mode.
- Issue with closing Java process "javaw.exe" after closing the last JExcel Demo window (JExcel Demo).
- Crash issue with JVM 1.6 (JExcel Demo).
New in JExcel 1.3 (Nov 10, 2008)
- Added the getValues() functionality into Range class for bulk reading operations.
- Added the copyWorksheet() method to the Workbook class for copying a Worksheet.
- Added the mergeWorkbook() methods to the Workbook class for merging Workbooks.
- Added the displayHeadings() method to the Worksheet class for hiding and displaying headings.
- Added the allowMacros() method for disabling/allowing macros execution.
- Added the setAutoFit() method to the Range class.
New in JExcel 1.2 (Aug 22, 2008)
- Added getRowCount() and getColumnCount() methods for Range class.
- fillWithArray() method implementation is improved by using setValue2 MS Excel interface, speeding up bulk operations for large data sets.
- Added setSaved() method for Workbook class for forcing �saved� status.
- Native Peer setValue2() functionality is exposed for Range object.
- Added COM exception handling for deleteRow() and deleteColumn() methods.
- Memory leak fixes in RangePresentation inherited classes.
- Fixed CLSID checking for XLSM format (MS Excel 2007 Macro-Enabled Workbook).
- Fixed XLS file opening issue when working using MS Office 2007.
- Fixed save() method from JWorkbook class to correctly save an opened document.
- Fixed file reference storage for saveAs() method of JWorkbook class.
- Some new samples based on customer support requests are added to JExcel package.
- Fixed �Save� and �Save as...� menu items in JExcel demo application.