Release Notes: This release allows Java developers to restrict the API to use only one font location while rendering spreadsheets. It is now possible to export or prevent exporting of hidden worksheet contents when saving a worksheet to HTML, and to set the display option for empty cells inside the Pivot Table to any specified string. A couple of problems with rendering spreadsheets as PDF on Linux, exporting spreadsheets to HTML, print quality, and page setup were fixed.
Release Notes: This new release lets developers control the direction of the text in shapes, including spreadsheet comments. Direction can be left to right, right to left, or to context. Images can now be controlled when exporting to HTML format. Bugs in rendering PivotTables as PDF, range references, deleting columns, and AutoFitRows with different font settings were fixed.
Release Notes: This release supports memory optimization for existing worksheets. The previously provided approach was useful for minimizing the overall memory cost while working with existing large Excel spreadsheets containing huge data sets. This release enhances the licensing mechanism and adds the capability to identify potentially damaged or corrupted files. It fixes several important issues, such as a couple of problems related to the PDF rendering engine, rendering and manipulating charts, and retrieving and removing OleObjects. There is an overhaul of the existing formula engine.
Release Notes: Supports optimizing memory usage when working with big MS Excel files and large data sets (when building a workbook with large data sets, or reading a big template file). Sometimes developers may need to set their desired custom DateTime for the PDF files. This release allows getting or setting time for generating PDF documents during Excel to PDF conversion. Moreover, it also supports another valuable MS Excel features for showing formulas instead of the calculated values in a worksheet. Bugs in reading and writing Excel files and rendering images from worksheets have been fixed.
Release Notes: This release enables Java developers to read password-protected Microsoft Excel 2013 files and apply the justify distributed setting while applying text alignment settings on cells inside their own applications. It also provides support for B3 (13.9 x 19.7 inches) and Business Card (90 mm x 55 mm) PaperSizeTypes. It enhances the un-hiding of rows/columns, printing comments in a Microsoft Excel document while rendering to PDF, and chart-to-image and sheet-to-image modules, and fixes issues with manipulating charts and shapes, exporting Excel workbooks to PDF format, and much more.
Release Notes: The LightCells API can be used to read huge Excel spreadsheets with less memory. You can now create transparent images of an Excel worksheet. Issues with manipulating charts and shapes were fixed. Issues with rendering Excel file formats, rendering images from Excel worksheets, rendering shapes and control data, and exporting Excel workbooks to PDF format have been resolved.
Release Notes: This release adds a feature which lets you retrieve external data source details. Sometimes, you may want to retrieve details from external data sources, for example, if you want to read the SQL connection data. You can also limit the number of pages generated in Excel-to-PDF conversion. You can print a range of pages to the output PDF file using this new feature and can set a limit on how many pages are generated when converting a MS Excel spreadsheet to PDF file format. This release improves the chart-to-image and sheet-to-image modules and adds a number of enhancements.
Release Notes: The dependency on the dom4j library has been removed and was replaced with a custom XML parser. A “Cannot find black listed licenses resource” exception was fixed. The OSGi environment is now supported without any problems. Exceptions when reading/writing Excel files and rendering Excel spreadsheets to image files and PDF format were resolved.
Release Notes: This release supports selecting a range of cells in the worksheet while activating the worksheets in the output Excel file. You may also specify a first page header and footer image for worksheet. There were a number of complaints regarding the image quality in chart-to-image conversion, and this release improves the quality to a certain extent. It also fixes issues with manipulating charts and shapes. Several other important issues have been addressed, for example, issues related to rendering MS Excel file formats, manipulating charts, manipulating worksheets, and rendering to PDF format.
Release Notes: This release includes some useful enhancements. For example, you may add conditional icons set (images) with your data to make it more meaningful. You may also auto-resize the textbox control based on the text or contents. The component now allows you to create a CellArea by using “$” included in the cell address. Several important issues related to rendering Microsoft Excel files, rendering charts, manipulating PivotTables, copying cells, inserting rows, and rendering to PDF format have been resolved. Issues pertaining to the formula calculation engine have also been fixed in this release.