Released: Nov 25, 2009

Updates in this release

Updates in V2.1.1

• Imports Excel spreadsheets that are in HTML format.
• Provides support for ResultSet with type TYPE_FORWARD_ONLY for Smart Markers.
• Supports to get the relative GroupBox that a RadioButton is in.
• Changes the controls’ status according to their Linked Cell value, or changes the Linked Cell value according to controls’ status.
• Shifts rows upward/downward for cells or range of cells.
• Supports to apply given style on a cell or a range of cells by a specified StyleFlag.
• Provides support to import/export an array formula for Excel 2007 file.
• Imports Document Properties when reading Excel 2007 file.
• Provides support to import/export controls, such as, CheckBox, ComboBox, ListBox etc. for Excel 2007 file.
• Parses fill settings when reading Chart from xls file.
• Supports formula for the text of ChartFrame related objects such as Title, DataLabels.
• Improved the model for Line and Area (Fill) to support new properties that are imported by Excel 2007 file format.
• Improved the model for Markers to support new properties that are imported by Excel 2007 file format.
• Workbook.save() method is enhanced for saving large Workbooks to remote file system on the network.
• The performance of reading large XLSX files has been enhanced.
• The performance of autoFitRows/Columns has been optimized.
• Enhancements for saving file as HTML format: exports images to customized destination; handles images when saving HTML file; improves performance by cutting off string values that cross multiple cells.