Released: Jan 17, 2020

Mises à jour de V20.1

Correctifs

• Cell.getValidation method returns null for ODS.
• XLSX to PDF, Difference in PDF output when using Oracle JDK vs Open JDK.
• Opacity is not applied to column charts.
• %of, %of Row, %of ParentRowTotal, %ParentTotal, etc. are not working in pivot output.
• Cell’s default background color is wrong in output HTML.
• SheetRender.toImage() output is incorrect.
• calculateFormula() does not calculate value.
• Percent Format Style is applied incorrectly under Norwegian Locale.
• Smaller font rendered in...

Released: Dec 20, 2019

Mises à jour de V19.12

Fonctionnalités

• Add tooltip text to cells when exporting to HTML.
• Added option to disable OLE object loading while opening a workbook.

Released: Nov 19, 2019

Mises à jour de V19.11

Fonctionnalités

• Added Validation.addArea (CellArea cellArea, boolean skipArea) and Validation.setAreas() methods.
• Added the ability to read OData connection details.
• Export a print area range to HTML without implicitly changing the state of a workbook.

Released: Oct 21, 2019

Mises à jour de V19.10

Fonctionnalités

• Added support for custom data sorting in pivot table reports.

Correctifs

• Performance issue with calculateFormula().
• Pivot table data coloring and formatting is not rendering properly.
• PDF is not generated as expected.
• Cell.getStyle.getCustom returns wrong format for German locale.
• ArrayIndexOutOfBoundsException while loading the Microsoft Excel file.

Released: Sep 23, 2019

Mises à jour de V19.9

Correctifs

• Hidden rows are displayed while converting Excel file to HTML when AutoFilter exists.
• CalculateFormula() fails with large formula strings.
• CalculateFormula() corrupts the Excel file.
• Formatting issues while converting Excel file to PDF.
• Text overlapping after converting Chinese XLSX file to PDF.
• Workbook.setRecalculateOnOpen(false) not working for newer Excel versions.
• Data labels based on formulas are not correctly rendered in PDF.
• Exception raised while converting XLSM to image...

Released: Aug 21, 2019

Mises à jour de V19.8

Fonctionnalités

• Added support for ECDSA and RSA algorithms.
• Read total page count before converting to a PDF or image.
• Insert SVG files into worksheets.
• Added support Java 12.
• Improved CPU and memory consumption during Excel to PDF conversions.

Released: Apr 18, 2019

Mises à jour de V19.4

Fonctionnalités

• Disable the auto-show task pane property.
• Improved performance when converting from XLSX to HTML.

Released: Mar 19, 2019

Mises à jour de V19.3

Fonctionnalités

• Preserve separators for empty rows when exporting an XLS file to CSV.

Correctifs

• Text extraction results differ from the original.
• The text is not properly aligned in PDF output.
• Text color (black) is changed to red in HTML rendering.
• Scatter chart is not rendered in Excel to PDF conversion.
• Horizontal axis labels are not rendered fine for charts in Excel to PDF rendering.
• 2D Bubble chart is not rendered in Excel to PDF conversion.
• Issue while embedding same PDF file in multiple...

Released: Feb 20, 2019

Mises à jour de V19.2

Fonctionnalités

• Insert rows with InsertOptions similar to Microsoft Excel.

Correctifs

• Using FontUnderlineType.WORDS throws exception.
• Data with conditional formatting omitted while XLSX to HTML conversion.
• Adding complex reference to defined name results in corrupt MS Excel workbook.
• Cell.getValidationValue returns wrong value for the specified value.
• Custom function name within the shared formulas replaced by another name.
• Axis titles missing and other formatting is wrong of charts in Excel to...

Released: Dec 20, 2018

Mises à jour de V18.12

Fonctionnalités

• Added the ability to export a range as HTML.

Correctifs

• Data bars are missing when XLSX is converted to HTML.
• Value still exists when XLSX is converted to HTML file format.
• LightCells API fails to load a huge file.
• Text formatting is missing in HTML output of MS Excel range.
• Icon Sets become misaligned when XLSX is converted to HTML.
• Exporting named range data is not correctly rendered to HTML.
• An issue found in Named Range.
• Validation always returns true for 'getInCellDropDown...