Released: Mar 7, 2023

V23.2 での更新項目

機能

• Added support for parsing, reading and saving 'SCAN' and 'Lambda' functions.
• Added support for multiple pagination formats when converting Microsoft Excel to PPTX.
• You can now extract cell style to a generic object (i.e. JSON).

不具合の修正

• Cell.Formula is not same as displayed in MS Excel.
• Formulas are calculated incorrectly.
• Issue with reading charts from Excel file (generated by Aspose.Cells) through Microsoft Graph API.
• Chart to PDF not same as to image.
• Text in chart in SVG has wrong position...

Released: Jan 10, 2023

V23.1 での更新項目

機能

• You can now 'interrupt' when calculating formulas.
• Change the default style of a row/column without changing the style of existing cells.
• Support for new functions: HSTACK and VSTACK.
• Added support for reading the author and date/time of revisions.
• Added support for CHOOSECOLS and CHOOSEROWS Microsoft Excel 365 formulas.
• Enhanced 'SaveOptions.HasHeaderRow' when converting XLSX to JSON.

不具合の修正

• JSON value is missing when a sheet is empty.
• JsonSaveOptions.SkipEmptyRows is not working properly...

Released: Nov 14, 2022

V22.11 での更新項目

機能

• Added support for copying timelines.
• Distinguish or differentiate between 'CSE' legacy array formulas and normal array formulas.
• Added support for disabling merged table cells when saving to HTML from XLSX.
• Added support for parsing collapsed properties when converting from HTML to Microsoft Excel.

不具合の修正

• Re-saving an XLSM file having ActiveX controls corrupted the macros in the file.
• XLSX to PDF: Content misalignment.
• XLS to PDF: Content misalignment in cells.
• XLSX to PDF: Shapes missing...

Released: Oct 20, 2022

V22.10 での更新項目

機能

• Added support for Apple macOS.
• Added support for CRTX files.
• PivotTable Timeline Filter now disappears after loading and updating a Microsoft Excel document.
• 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...

Released: Sep 9, 2022

V22.9 での更新項目

機能

• Added support for discrete data grouping in XLS files.
• Added preset settings for gradient fill.
• Added support for setting table formulas in 'datatable'.
• You can now convert OZM to LBM using the 'CONVERT' function.
• Improved recognition of user input.
• Added support for multiple tables in a .numbers worksheet.
• You can now export empty cells as null to JSON.
• Improved detection of header rows.
• Added support for applying outline borders.
• Read and write a protected range with SHA-512 in XLSB files...

Released: Aug 9, 2022

V22.8 での更新項目

機能

• Added support for expand/collapse button style to PivotTable.
• Added the ability to convert threaded comments to HTML.
• Added the ability to copy row height when processing smart markers of a table.
• Added the ability to delete grouped shapes from a group.

不具合の修正

• Wrong vertical alignment of cell text on convert to PDF from Excel file with pivot table.
• Shared formulas were copied incorrectly for different file formats.
• Wrong word wrapping on converting to PDF from Excel file with pivot table...