Blog Posts

6 Posts

JExcel 1.4 Release Notes

Posted by Roman Kazmin Oct 29, 2009

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).
0 Comments Permalink
New Features:
0 Comments Permalink
New Features and Improvements:    
  • 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.

Fixes:   
  • 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.

Other:   
  • Some new samples based on customer support requests are added to JExcel package.
  • Fixed “Save” and “Save as...” menu items in JExcel demo application.
           
0 Comments Permalink

New Feature and Improvements:

  • Added protect/unprotect features for the Worksheet class.
  • Added the getUsedRange method for the Worksheet class.
  • Added delete/insert functionality for columns/rows in the Worksheet class.
  • Added save() and saveAs() methods for JWorkbook.
  • Added the ability to specify the order of cells in the resulting list of the Range.getCells() method.
  • Added the ability to declare the getWorkbook() method from the JWorkbook class as public.
  • Added isLogical() and getLogical() methods to the Cell class to allow getting a value of boolean expressions.

 

Fixes:

  • Fixed the problem with creation of JWorkbook in static mode.
  • Fixed the exception occurred while closing JWorkbook in static mode.
  • Fixed the exception occurred during printing of an Excel file.
  • Fixed the problem with incorrectly obfuscated Excel stubs inside the JExcel library.
  • Fixed JVM crash on Workbook.saveAs method when JExcel is running with MS Excel 2000.
  • Fixed "FunctionExecutionException: invalid vtbl" exception occurred when calling Application.openWorkbook() method in Excel 2000.
  • Fixed the problem with releasing of the Excel document after closing the JWorkbook component.

0 Comments Permalink
Changes since version 1.0 Beta:
  • Removed ability to access the underlying Workbook object of JWorkbook to avoid ambiguity.
  • Added ability to interrupt JWorkbook closing.
  • Added ability to fill the cells Range with an array of values.
  • JWorkbook, JWorkbookEventListener, JWorkbookEventAdapter, JWorkbookEventObject moved to com.jniwrapper.win32.jexcel.ui package.
  • Border, Font, InteriorPattern, TextAlignment, TextOrientation moved to com.jniwrapper.win32.jexcel.format package.
  • JWorkbook and Workbook classes now implement the common GenericWorkbook interface.
  • Workbook.getPeer() renamed to getNativePeer().

Fixes:

  • Fixed "Object is not connected to server" problem occurred while creating new workbook.
  • Fixed problem with repainting workbook in "static mode" in JExcel Demo.

JExcel Demo:

  • JExcel Demo source are now available in distribution.
  • "Save Copy As..." dialog opens when closing a workbook that was modified.
0 Comments Permalink

JExcel Beta1

Posted by Igor Shvydkoy Dec 28, 2005
New:
  • Initial Beta Release.
0 Comments Permalink