Released: Sep 15, 2023

Updates in V23.9

Features

• Improved HTML to Microsoft Excel worksheet rendering.
• Improved parsing of XML with un-escaped greater than signs.
• You can now read button name and title from ODS files.

Fixes

• Lost spacing in formula after saving.
• 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 size of legends is not retained during chart conversion to image.
• Horizontal (Category) Axis missing in rendered PDF Charts from Excel chart.
• Chart to Image - string split into two lines.
• Excel Chart into image (.jpeg) : wrong export.
• Cell references are not displayed correctly when converting PDF in Excel.
• XLSX to PNG: Scale of Y-Axis wrong.
• X-axis of graph is too long in Excel to PDF rendering.
• Incorrect rendering of Torus in to PDF (.NET /Java).
• The horizontal and vertical resolution is not set in TIFF while converting to TIFF image in JDK9.
• Text offset issue when saving file to HTML.
• Alignment Issue while loading HTML into Excel file.
• Special characters appear while converting spreadsheetML to XLSX.
• Axis labels are rendered as vertical which should be diagonal.
• Waterfall chart to image lines appear.
• 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-axis scale of the bar chart changed when saving workbook to HTML.
• Office PowerPoint reports an error while saving PPTX (inserted a generated EMF image) to PDF.
• Failed to set transparency to false when saving as SVG.
• Conditional formatting with Data Bars are rendered incorrectly in HTML export.
• The issue with HTML extracted from the XLSX file.
• Horizontal Shifting not working using Smart Markers option.
• Output XLSX file does not show contents/values correctly after re-saving the file.
• Pictures are damaged after saving XLS to XLSX.
• 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 when converting the file to HTML.
• Overlapping and garbled date data when saving files to SVG.
• Cells text not center aligned vertically in the generated EMF image.
• The texts are truncated when converted to HTML.
• Content of some cells not fully displayed within the width of the column when printed to HTML.
• Some cells in rows are shifted to the right in Excel to HTML rendering.
• Extra underline appears in the text when converting the file to HTML.
• Issue with rendering some Excel 3-D charts (Column and Pie) into PDF.
• Pivot table wrong background colors in converted PDF.
• File corrupted after PivotTable.refreshData().
• Memory overflow when converting XLS to XLSX.
• Exceptions occur when converting XLSX to XLS.
• Shape to image error when converting file to PDF.
• "java.lang.OutOfMemoryError" while converting XLS to XLSX.
• Exception "java.lang.IllegalArgumentException" when loading an XLSX file.
• Exception using CellsHelper.convertR1C1FormulaToA1 when there are characters R or C or RC in formulas.