Release Notes: This release supports reading of Excel files containing millions of records with the LightCells API. It is now possible to find all cells with a common style or formatting, and to generate a transparent image of your worksheet.
Release Notes: This release supports fitting all worksheet columns on a single PDF page. It also provides a feature for detecting file format type and checking if the file is encrypted. Sometimes you need to detect a file’s format before opening it because the file extension does not guarantee that the file content is appropriate, or the file might be encrypted (a password protected file). Issues around rendering Microsoft Excel file formats (XLS, XLSX, ODS, CSV, XLSB, etc.), rendering and manipulating pivot tables, rendering images from Excel worksheets, exporting Excel workbooks to PDF format have been resolved.
Release Notes: This release added support for calculating the color selected by MS Excel when ColorScale Conditional formatting is used in the template file. Support for encrypted files was enhanced. Generation of password protected Excel files was enhanced. Several issues with rendering Microsoft Excel file formats, rendering and manipulating pivot tables, rendering images from Excel worksheets, manipulating custom document properties, working with advanced conditional formatting (MS Excel 2007/2010), and rendering and manipulating Charts have been resolved.
Release Notes: This release lets you select a different paper source when printing worksheets. Some significant enhancements are added for reading non-native Microsoft Excel files: now the component throws the appropriate exception when loading such files. This release improves the module for inserting OLE objects. It supports re-sampling images added to slides to reduce the overall file size and improve performance (e.g. if you want to compress images while saving Excel to PDF format). It fixes a few exceptions when reading/writing Excel files and refreshing pivot tables in the template files.
Release Notes: Reading and writing of page setup options in HTML files was enhanced. Rendering, manipulating, and refreshing PivotTables was enhanced. A few exceptions when reading and writing Excel files and manipulating PivotTables in a template file were fixed. Issues with rendering Excel files, rendering and manipulating PivotTables, rendering image files, converting Excel files to HTML/MTHML, and exporting to PDF have been resolved. Issues pertaining to the formula calculation engine have also been fixed.
Release Notes: This release supports adding custom data sorting. It adds some significant enhancements for copying ranges with conditional formatting and clearing the Textbox collection. It fixes a few exceptions when reading and writing Excel files and writing legend entries in charts. Several important issues have been addressed. For example, issues around rendering Microsoft Excel file formats, rendering and manipulating PivotTables, converting Excel files to HTML format, adding background watermarks in worksheets, rendering charts, rendering image files, and exporting to PDF have been resolved.
Release Notes: This release includes how to get icon sets, data bars, or color scales objects used when adding conditional formatting to a cell or a range of cells. Support for rendering a worksheet’s background in an output HTML file and parsing custom views and scenarios while converting from one Excel file format to another are added. Moreover, this release improves the Excel to PDF rendering feature, which sometimes took more time to convert large Excel files to PDF. Issues around reading and writing Microsoft Excel (2003 – 2007/2010) file formats have been fixed.
Release Notes: A picture can now be added based on a desired range of cells as the data source. Some significant enhancements were made for shading a style’s fill effect for cells, opening CSV files with values longer than 32K in the cells, and copying table and list object formulae accordingly when inserting new rows. Refreshing PivotTables, saving to HTML, reading files, rendering Microsoft Excel 2007/2010 file formats, rendering PivotTables, converting Excel files to HTML format, rendering charts, rendering image files, and exporting to PDF were fixed.
Release Notes: This release includes an enhancement for copying a cell over a range of cells. A new overload was added: AutoFitColumns (int firstRow, int firstColumn, int lastRow, int lastColumn, AutoFitterOptions options), making it possible to use auto-fitting options even in a range. Similarly, you may now copy tables when copying ranges. issues with rendering Excel files, rendering PivotTables and Pivot Charts, Excel to HTML, applying conditional formatting, rendering image files from worksheets, and exporting to PDF have been resolved. Issues pertaining to the formula calculation engine have also been fixed.
Release Notes: In this release, several important issues have been addressed. For example, issues around formatting cells, rendering PivotTables and charts, rendering Excel files, and rendering image files from charts / worksheets have been resolved. Issues pertaining to the formula calculation engine have also been fixed. Pivot table borders were incorrectly visible, and green ellipse word art/picture was incorrectly rendered around the chart; this is now fixed.