Released: Dec 14, 2023

Atualizações na V23.12

Recursos

• Added support for MAKEARRAY function.
• Added support for JSON as data source for smart markers.
• You can now retrieve "Style Includes" information.
• Improved the performance of calculating shared formulas recursively.

Correções

• 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.
• Changing hidden cells visibility does not work.
• Images shrunk when converting HTML to Excel workbook.
• Fonts 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.