Released: Oct 11, 2022

V22.10 での更新項目

機能

• Added support for CRTX files.
• PivotTable Timeline Filter now disappears after loading and updating Microsoft Excel documents.
• You can now translate legend labels in accordance with locale/regional settings.

不具合の修正

• MAXIFS formulas take long time to be calculated.
• It’s not allowed to push non-empty cells off the end of the worksheet error when using Cells.InsertRows method.
• External Link of Pivot table got deleted when converting XLS file to XLSM.
• XLSX file with PivotTable file is corrupted after re-save.
• Issue with some Smart Markers (inserted) in the PivotTable and Pivot chart.
• Wrong external data connections when converting external connections.
• Extra row is added when creating classic pivot table.
• GetValidationValue incorrect using NotBetween operator.
• Decimal values in the result of Cell.Formula may be different from what MS Excel shows.
• Style.SetPatternColor(BackgroundType,Color,Color) does not take effect.
• LightCellsDataHandler.StartSheet(Worksheet) cannot skip the sheet when returning false for XLSB template file.
• Missing chart title on convert to PDF.
• XLSX to PDF: Text not formatted properly.
• Issue regarding Arial Tur font in Excel to PDF rendering.
• Some cells with the Accounting number format are rendered as #####.
• When setting the worksheet contents to black and white, it is still printed in color & borders are displayed unnecessarily.
• Worksheet containing button objects are not recognized properly when copying the sheet.
• HTML table to Excel sheet not converted properly.
• Re-saving an XLSX file generated corrupt file.
• Unable to load power query formula from Excel file.
• Style corruption after saving and reopening an Aspose.Cells-generated workbook.
• Hyperlink Duplication Issue.
• Excel to XML conversion - Element Names are Not Escaped.
• HTML to XLSX: Missing cell content.
• The position of the “Northwind Traders” text is incorrect (the left indent value is not interpreted correctly).
• PivotTable.CalculateData caused NullReferenceException.
• Calculating workbook twice with enabled calculation chain caused exception.
• Opening XLSX file whose styles have been removed throws exception.
• Exception raised while importing the customer’s file in GridWeb.
• Exception is thrown when trying to open unprotected document with a password.