Released: Nov 13, 2023

Updates in V23.11

Features

• Added support for PDF version 1.5 and 1.6 when rendering spreadsheets to PDF.
• Added 'HtmlSaveOptions.CalculateFormula' property which lets the user choose to calculate formulas or not before saving.

Fixes

• 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.
• Content of some cells...

Released: Oct 16, 2023

Updates in V23.10

Fixes

• The position of the punctuation mark in vertical text is close to the left side.
• 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.
• Regression: Decimal rounding.
• 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 Excel to...

Released: Sep 15, 2023

Updates in V23.9

Features

• Improved parsing of XML with un-escaped greater than signs.

Fixes

• Characters disappear when saving file to PDF.
• Shapes are lost in Excel to PDF rendering.
• YEARFRAC is not working as in Excel in Aspose Cells for Java 23.8.
• Regression: Worksheet not calculated.
• Labels of Chart are overlapping having missing lines when Chart is converted to PDF.
• Issue with overlapping Donut Chart Labels.
• Legend data of chart error when saving to image.
• The underline style of the chart title is incorrect...

Released: Aug 14, 2023

Updates in V23.8

Features

• Added support for preserving padding spaces in formulas.
• You can now read 'button name' and 'title' from ODS files.
• Improved rendering of HTML to Microsoft Excel worksheets.

Fixes

• Regression: Slow performance of Workbook CalculateFormula.
• YEARFRAC formula calculation error.
• Chart to image rendering - One of the labels is inside the doughnut chart.
• Some labels overlapped when rendering chart to SVG/PDF on Linux.
• Missing values on x-axis on bar chart compared to original Excel file.
• Y...

Released: Jul 14, 2023

Updates in V23.7

Fixes

• Shapes with contents are not rendered precisely in Excel to PDF conversion.
• EXCEL function TRIM() calculation error.
• Inexplicable change in the handling of numbers in right function.
• Overlapping Labels issue in Donut Charts.
• Issue with graph rendering - "+" sign and graph for both the x-axis and y-axis are not being plotted in the output PDF.
• Position of legends is not retained during chart conversion to image.
• Position of leader lines is not retained during chart conversion to image.
• Font...

Released: Jun 9, 2023

Updates in V23.6

Features

• Read 'track changes' information and highlight relevant cells.
• You can now optimize SVG images.
• Added support for setting 'duotone' effects.

Fixes

• Header row getting included in sorting after applying subtotal and getting wrong results.
• The calculation result of the FILTER function is incorrect.
• Cells text is not center aligned vertically in the generated EMF image.
• Missing part of cell border when converting to HTML.
• Graphic position error converting file to HTML.
• The newly created...

Released: May 11, 2023

Updates in V23.5

Features

• Added support for adding watermarks while rendering to PDF.

Fixes

• The data in the text box is out of bounds.
• Text is moved when converting grouped autoshapes to PDF.
• Vertical text in figure in Excel is slanted when converted to PDF.
• Oval shape display error when exporting file to HTML.
• Replaced font of text boxes issues.
• Conditional formatting reference rules are not updated fine when copying ranges from one workbook to another workbook.
• Error plot is not displayed.
• Endless loop when...

Released: Apr 13, 2023

Updates in V23.4

Features

• Adds XlsbSaveOptions.LightCellsDataProvider property - Allows users to save XLSB files in 'LightCell' mode.
• Adds Worksheet.CalculateArrayFormula(...) methods - Allows users to calculate one formula as array formula dynamically without setting it to a cell at first.
• Adds CalculationOptions.CharacterEncoding property - Allows users to specify the encoding used for characters when calculating formulas such as CHAR and CODE.
• Adds EquationNode class and it's derived classes - Allows users to...

Released: Mar 9, 2023

Updates in V23.3

Features

• You can now modify the logic when generating a 'group' object from a 'smartart' object.
• Added support for 'img' tag margins when loading HTML.

Fixes

• Converted image is not same as MS Excel.
• Calculated field values are not retrieved by the getCalculatedValue() function.
• Chart to Image - character and legend height not rendered correctly.
• Converted PDF is showing diagram labels at different location and incorrect Axis points.
• Data labels missing from chart in copied workbook in v23.
• When...

Released: Feb 9, 2023

Updates in V23.2

Features

• You can now fill <Application> tags in XLSX.

Fixes

• When reading into 03 format Excel, the ‘FillType’ of the straight line is not processed.
• Horizontal flip seems to be missing when reading arrow lines.
• XLS to HTML: Image stretched.
• XLS to HTML: Arrow shifting.
• Diagram scattered issue in Excel to PDF rendering.
• Incomplete shape display after rotation when save to PDF.
• SUM AVERAGE calculation '#VALUE!'.
• Displayed result is incorrect for resultant HTML when cell value is string with...