Released: Mar 9, 2023

Updates in V23.3

Features

• Added support for interruptions when calculating formulas in one cell.
• Added support for 'sheet zoom' and 'freeze panes' when exporting and importing HTML.
• Added support to modify the logic when generating a 'group' object from a 'smartart' object.
• Added support for 'Fill <Application>' tag in XLSX.
• Added support for 'img' tag margins when loading HTML.

Fixes

• When reading into 03 format Excel, the 'FillType' of the straight line is not processed.
• How to code/utilize Row 1 Filter Flag Option.
• Horizontal flip seems to be missing when reading arrow lines.
• XLS to HTML: Rectangle shape is distorted.
• XLS to HTML: Image clipped and moved out of place.
• Difference in values between an Excel file and the converted PDF (via Aspose.Cells) file.
• Double quotes " from XLSX file not shown in converted PDF file.
• DATEDIF function doesn't work correctly with leap years.
• Chart legend items cut off in the output image.
• Regression: Chart resized incorrectly.
• Can not switch worksheet in java demo project for the file with password.
• Colors lost when exporting a Chart to EMF.
• Font with font full name is not picked while converting to PDF.
• Worksheet to EMF image is not right after setting resolution option.
• Images cannot display when loading HTML stream.
• HTML to Excel: Styles changed.
• 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 custom format.
• Global named ranges with references like =!$K$23 break in the new version.
• Method deleteRows is causing incorrect formatting.
• The saved file reports an error when upload and open in Onedrive disk.
• An Exception is thrown when converting chart to image.
• Render special Major Gridline for Radar Chart.
• Colored pictures inserted in Excel become black when converted to PDF.
• Center Across text is cut off if it is in the last column when converting to PDF.
• HTML to Excel convert failed with error Invalid #.
• Custom Number Format with Trailing Dots is ignored when exporting to HTML.
• Font changed in the re-saved XLS file.
• The result file is abnormal when converting Excel to HTML.
• Shape rotate error when save to HTML.
• Arc shape should be flipped Horizontally of Excel 95.
• Support pattern fill of shape in the Excel 95/5.0.
• Some text in the last column are cut off when saving file to HTML.
• Merged areas lost after saving as HTML.
• The border is displayed on the text for the chart title in Excel to PDF rendering.
• 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 converting XLSX to HTML, the program will prompt that the starting cell of the Chart object has invalid '}' content.
• Series Line is missing in a Scatter chart.
• Can not switch worksheet for the specified file from customer.
• CSV file not same with WPS file.
• The converted PDF by Aspose.Cells from MS Excel file could not be read normally with iText.
• Showing '#' for numbers in the converted PDF.
• Text is not center aligned while rendering to PNG image.
• HTML is wrong when some rows are hidden.
• Select pivot data field of a pivot table to apply format on.
• Formatting issues in HTML to Excel conversion.
• "com.aspose.cells.CellsException: Invalid sheet reference for the defined Name" when rendering an Excel file to PDF.
• ArrayIndexOutOfBoundsException on workbook save.
• Password not working when opening LibreOffice Calc file (ODS).
• Exception "Invalid end row index" in CSV to PDF rendering.
• An exception IllegalArgumentException is generated when exporting files to HTML.