Aspose.Cells for .NET Releases

Released: Jul 7, 2022

Updates in V22.7

Features

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

Fixes

  • 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

Updates in V22.6

Features

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

Fixes

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

Released: May 10, 2022

Updates in V22.5

Features

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

Fixes

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

Released: Apr 12, 2022

Updates in V22.4

Features

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

Fixes

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

Released: Mar 10, 2022

Updates in V22.3

Features

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

Fixes

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

Released: Feb 11, 2022

Updates in V22.2

Features

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

Fixes

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

Released: Jan 7, 2022

Updates in V22.1

Features

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

Fixes

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

Released: Dec 8, 2021

Updates in V21.12

Features

  • 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

Features

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

Fixes

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

Released: Oct 14, 2021

Updates in V21.10

Features

  • Added the ability to open files with HTML tables as XLS files.
  • Added support for the Range.CurrentRegion property.
  • Updated hyperlink(Sheet1!A1) when changing the name of the worksheet.
  • Improved support for autofill range with fill type.
  • Added the ability to remove invisible shapes when rendering HTML.

Fixes

  • Conditional formatting of ODS is lost in Microsoft Excel if type is “Contains Text”.
  • Issue with retrieving Ranges (RefersTo) with an offset function.
  • Application halts while...