Released: Feb 8, 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: Dec 9, 2022

V22.12 での更新項目

機能

• Added support for Microsoft .NET 7.
• Added support applying custom chart templates in CRTX files.

不具合の修正

• Images are distorted in Excel to PDF/HTML rendering.
• Image rotation effect is not displayed correctly in PDF/HTML.
• The rectangular box rotation effect in the graphics group is not displayed correctly in PDF/HTML.
• Some shapes are changed after converting Excel file to PDF.
• Boxes changed when converting XLSX document to PDF.
• Drawing shapes not rendered fine in HTML.
• The defined name is...

Released: Nov 10, 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.

不具合の修正

• XLSX to PDF: Content misalignment.
• XLS to PDF: Content misalignment in cells.
• XLSX to PDF: Shapes missing/Layout collapse.
• Character printing and spacing in the figures of Excel is cut off...

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...

Released: Sep 8, 2022

V22.9 での更新項目

機能

• Added support for discrete grouping of data in XLS files.
• Added support for preset settings for gradient fill.
• Added support for setting table formula in datatable.
• Added support for converting OZM to LBM using the CONVERT function.
• Improved the recognition of user’s input for 'Style.Custom'.
• Added support for multiple tables in a worksheet of .Numbers files.
• Added support for exporting empty cells as null to JSON.
• Improved the ability to detect whether the first row is header row.
• Added...

Released: Aug 4, 2022

V22.8 での更新項目

機能

• Added support for expand/collapse button style for 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...

Released: Jul 7, 2022

V22.7 での更新項目

機能

• New properties allow you to read the position and size of a range.
• Added the ability to convert all sheets to one page when saving as HTML.

不具合の修正

• Gridweb keeps jumping back to top when trying to copy and paste.
• The text rendered as small squares.
• Default font is not applied when converting XLSX to HTML.
• Pivot table styles not copied properly using the latest version of Aspose.Cells for .NET.
• Problem with COUNTIFS formula treating 0 incorrectly.
• Cell.GetPrecedents() does not provide all...

Released: Jun 10, 2022

V22.6 での更新項目

機能

• Added new APIs to convert data to 'ICellsDataTable'.
• Improved support for data storage in Numbers format.
• Improved support for reading images in Numbers format.
• Added support for setting CellRange style.
• Added ChartCollection.Add (ChartType, String, Boolean, Int32, Int32, Int32, Int32) overloaded method.
• Added support for importing an array value if the range is a simple cell.
• Added support for saving table formulas to XLSB.

不具合の修正

• Picture is blurred.
• Wrong UpperLeftRow of CheckBox after...

Released: May 10, 2022

V22.5 での更新項目

機能

• Improved performance when deleting blank columns.
• Added the ability to initialize a cell’s calculated value when setting dynamic array formulas.

不具合の修正

• Remove method SetDataSource(string variable, object[] dataArray) method.
• Issue with retrieving Linked OLE attachments in ODS file.
• Excel to Tiff conversion issue.
• Issue of exporting JSON string to Excel.
• Slicers filter disappears after resaving by Aspose.Cells APIs.
• Workbook corrupted when re-saving an XLSM file (containing a pivot table) by...