Released: Feb 20, 2019

Updates in V19.2

Features

• Insert rows with InsertOptions similar to Microsoft Excel.

Fixes

• 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 PDF/A conversion.
• Arrows in the PNG output are not matching the arrows in the Excel chart.
• Wrong rows height changed while using auto-fit rows operation.
• Workbook setting "ReCalculateOnOpen" not persisted.
• Incomplete display for AutoFitterOptions.setAutoFitMergedCells(true).
• The Textboxes background color is unexpectedly changed.
• On deleting first row of a Range, the Range is updated wrongly.
• When using Cell.setHtmlString a new line is added at the end of the text.
• Exception "Invalid IMEModeType string val" when loading an XLSX file format.