Released: Aug 4, 2022

Updates in V22.8

Funktionen

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

Fehlerkorrekturen

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

Released: Jul 7, 2022

Updates in V22.7

Funktionen

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

Fehlerkorrekturen

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

Released: Jun 10, 2022

Updates in V22.6

Funktionen

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

Fehlerkorrekturen

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

Released: May 10, 2022

Updates in V22.5

Funktionen

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

Fehlerkorrekturen

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

Released: Apr 12, 2022

Updates in V22.4

Funktionen

• Added support for removing trailing blank cells when saving to CSV.
• Added 'Style.HasBorders' to allow you to check for borders.
• Added the ability to get a merged range.
• Added 'GridLoadDataFilterOptions' for GridDesktop and Worksheet.GetMergeByCell API.
• Added support for High Contrast Theming in Aspose.Cells.GridDesktop.
• Added support for 'PasteType.ValuesAndFormats' when copying a range.

Fehlerkorrekturen

• When converting XLS to PDF, text blank line size in textbox is not rendered...

Released: Mar 10, 2022

Updates in V22.3

Funktionen

• Added support for sorting PivotFields using the values in a selected row/column.
• Added support for re-calculating cells that reference a defined name.
• Added SaveFormat.Ots and SaveFormat.Xlt enums.
• Added support for setting range borders.

Fehlerkorrekturen

• Pivot table not sorting on refresh.
• Deleting worksheet deletes Slicers.
• Regression: After copying range of cells formulas are lost.
• Conditionally formatted fields are not colored in the right color.
• Formulas were not calculated...

Released: Feb 11, 2022

Updates in V22.2

Funktionen

• Added the ability to extract all the NameCollections of a particular worksheet.
• Added StandardHeightInch property to Cells class.

Fehlerkorrekturen

• Various formatting and other shapes rendering issues in PDF and HTML of Excel file.
• Some shapes are not rendered properly in Excel to PDF conversion.
• Invalid value for external reference in DataSource field of Pivot Table.
• Regression: CSV to PDF conversion not working.
• Empty CellsArea array returned for CSV/TSV files.
• Finnish language...

Released: Jan 7, 2022

Updates in V22.1

Funktionen

• Added support for returning original indices of sorted rows/columns.
• Added the ability to set print job name, with PrinterSettings, while rendering to printer.
• Added the ability to ignore hidden rows and columns when getting Cells.MaxDisplayRange.

Fehlerkorrekturen

• Incorrect result for calculating FREQUENCY function in array formula.
• Unsupported function: CUBESET.
• Different behavior about collapsing and expanding multi level groups.
• BMP image files don’t display in header/footer.
• XLS...

Released: Dec 8, 2021

Updates in V21.12

Funktionen

• Added support for converting Microsoft Excel to SQL scripts.
• Added support for converting Excel to XML data.
• Added support for importing XML data.
• Updated priorities when adding new format conditions.
• Sorting with DataSorter now affects table formatting.
• FormatConditionCollection.AddCondition() now gives different behavior for the formula.
• Added filter option for revision logs while creating workbook from template file.
• Added the ability to ignore 3D references for conditional...

Released: Nov 8, 2021

Updates in V21.11

Funktionen

• Added support for XLOOKUP formula/function.
• Added support for saving images with workbook.Save() method.
• Added support for saving as a JSON file.
• Added the ability to retrieve formatted cell values against certain cells.
• Added the ability to clear defined names when clearing worksheets.
• Improved performance when converting Microsoft Excel to HTML.

Fehlerkorrekturen

• 3D, the shape of the cloud changed.
• Bug of saving external NamedRange which references to range of multiple sheets...