Released: Dec 14, 2023

Mises à jour de V23.12

Fonctionnalités

• Added support for PDF version 1.5 and 1.6 while rendering spreadsheets to PDF format.
• Added support for MAKEARRAY function.
• Added support for JSON as data source for smart markers.
• You can now retrieve "Style Includes" information.
• Added HtmlSaveOptions.CalculateFormula property like other save options so user may choose to calculate formulas or not before saving.
• Improved the performance of calculating shared formulas recursively.

Correctifs

• The vertical text position inside the text box is incorrect.
• When converting XLS to PDF, the rounded rectangle is rendered into a right rectangle.
• Regression: calculateFormula hangs.
• The numeric values are added extra spaces for some regions such es-ES.
• Character spacing is not retained during chart conversion to image.
• The appearance of the graph changes when converting Microsoft Excel to PDF.
• Graph data labels disappear when converting Excel to PDF.
• Content of some cells not fully displayed within the width of the column when printed to HTML.
• The cell number value is not fully displayed for some of the locales ( "es", "fr", "it" in particular) in output HTML.
• When using 'Shrink to fit' option, worksheet cell cannot be reflected in the output HTML.
• Cell data offset when saving file to HTML.
• OTS and Excel95 format get incorrect values when calling FileFormatUtil.saveFormatToExtension.
• Advanced MS Excel charts are not rendered properly in the output PDF.
• DAYS360 function works incorrectly in case of leap day.
• The LOOKUP function obtains an error value after calculation in a Chinese environment.
• Sheet to Image rendering - EMF+ required error instead of images on the sheet.
• Converting files to PDF takes too long.
• Incorrect data display when converting file to HTML.
• Date format error when converting file to HTML.
• Abnormal cell merging when converting files to HTML.
• Extra tag is added when text overflows the cell in the output HTML.
• Missing border when converting file to HTML.
• Filter in the template to ignore blank rows stop working after Pivot Table refresh.
• Pivot Table becomes unresponsive after simply resaving the spreadsheet.
• Filter on labels are not applied during Worksheet.refreshPivotTables call.
• The result file crash after adding treemap chart.
• Different behavior of XLSX and XLSB files for MaxRow and MaxColumn attributes when using in LightCells APIs.
• VLOOKUP function calculation gets an error value.
• Incorrect value obtained after IRR function calculation.
• Endless loop with "CalculateFormula" method.
• NumberValue formula not working.
• Error in file data saved after calling formula calculation.
• XLSX to PNG: Charts text wrap and Y axis.
• Excessive memory consumption when converting file to PDF.
• Chart title missing when converting file to PDF.
• Issue with the display of the circular chart legend after XLSX is converted to HTML.
• Data labels (percentages) are incorrect in the generated HTML for 3-D Pie chart.
• Excel to PDF conversion - Some text is blocked by the picture.
• Sparkline overlaps cell text while converting to SVG.
• Text is truncated when converting the file to PDF.
• File pagination error when converting file to PDF.
• EMF image is lost while converting workbook to PDF.
• Some texts are not visible when converting to HTML.
• Changing hidden cells visibility does not work.
• Images shrunk when converting HTML to Excel workbook.
• Fonts are changed for the data in cells for Excel where hyperlinks are present.
• Extra whitespace was generated between charts when converting the file to HTML.
• Some digits show dislocation when saving file to HTML.
• Text position error when converting file to HTML.
• The picture lost after converting XLSX to to HTML.
• GETPIVOTDATA is not working when using field grouping.
• Regression: Getting incorrect value in file explorer Preview Mode for Pivot.
• Smart markers can't get correct layout when setting line by line replacement to false.
• Regression: filters are not getting refreshed.
• After pivotTable.refreshData the file is corrupted.
• calculateData throws java.lang.NullPointerException.
• Partial data becomes garbled after converted from XLS to XLSX.
• Waterfall chart X-Axis labels are cut off when chart width is decreased.
• PivotTable.CalculateData() throws IndexOutOfBoundsException.
• Exception occurs when converting file to HTML.
• Read XLSX: java.lang.NullPointerException.
• Exception occurred while resaving the file.