Aspose.Cells for .NET Releases

Released: Feb 5, 2021

Updates in V21.2

Features

  • Added support for column percentage display to PivotTable.
  • You can now use LightCells API with XLSB files.
  • Updated data source when changing Waterfall chart to Column chart.
  • Added support for updating display icons in embedded JPG, ZIP and MSG objects.

Fixes

  • Hang on CalculateFormula.
  • Cells.DeleteBlankRows never finishes (infinite loop) on a particular worksheet.
  • Loading xlsb results with OOM exception.
  • Wrong position of some polylines when saving .html files.
  • Arrow position is wrong...

Released: Jan 15, 2021

Updates in V21.1

Features

  • Added support for Microsoft .NET 5.0.
  • Added the ability to switch row/column data series.
  • Added OleObject.SetEmbeddedObject() method.
  • Added the ability to get the data source range of the chart.

Fixes

  • SmartArt shapes are not rendered fine in Excel to PDF conversion.
  • Shapes are not positioned correctly in Excel to PDF conversions.
  • Arrow graph is incomplete.
  • Diagram blocks are shifted when converting to HTML.
  • Invalid CSS and HTML markup when converting XLSX to HTML.
  • Unencoded quotes in...

Released: Dec 17, 2020

Updates in V20.12

Features

  • IFS formulas can now be wrapped with curly braces after saving.
  • Added support for formulas with Sheet() function.
  • Reduced output size when converting to HTML.
  • Added the ability to display additional columns when text is overlapping next cells.
  • Added the ability to remove ODS macros in Workbook.RemoveMacro.
  • Added support for h1 tag when setting Cell.HtmlString.

Fixes

  • New worksheet is missing mc:Ignorable="x14ac xr xr2 xr3”.
  • Conversion complex XLSM to HTML takes a lot of time.
  • Invalid...

Released: Nov 12, 2020

Updates in V20.11

Features

  • Improved support for locale-dependent formatting pattern “aaaa” for year in Spain region.

Fixes

  • Warning raised while adding 29 sheets and opening the output XLS file in Microsoft Excel.
  • Text was cut when rendering PDF.
  • An image becomes all white and some text corruption in other images/shapes.
  • Slicer on different table generates corrupted file.
  • XLSB file is corrupted after load and save.
  • Chart field containing dates has different format in PDF format.
  • Aspose.Cells generates invalid HTML...

Released: Sep 10, 2020

Updates in V20.9

Features

  • Added support for getting and setting slicer shape properties.
  • GridWeb client API now supports adding and removing comments.
  • Added new properties to the public API.
  • Improved support for freezing and splitting worksheets.

Fixes

  • Fixed an issue where chart does not allow treating #N/A as empty cells when saving as PDF.
  • Fixed an issue where Kaiti font is not properly rendered.
  • Fixed an issue where query tables are not loaded from ODS file.
  • Fixed an issue where macros should be removed when...

Released: Aug 13, 2020

Updates in V20.8

Features

  • Added support for slicers in Microsoft Excel tables.
  • Added client API for direct font setting in GridWeb.
  • Added client API for adding/removing hyperlinks in GridWeb.
  • Added ShowAddButton property to support the adding/deleting of worksheets in GridWeb.
  • Added support for OTF font types for rendering purposes.
  • Added support to convert workbooks into PPTX in which slides are pictures.
  • Added support to convert workbooks into DOCX in which pages are pictures.
  • Added support for tables in ODS...

Released: Jul 15, 2020

Updates in V20.7

Features

  • Added support for FilterString() criteria.
  • Added the ability to loop over all PivotFields with a regular "for each" loop.
  • Added the ability to check whether the struct or window of the workbook is protected with a password.

Released: Jun 12, 2020

Updates in V20.6

Features

  • Added support for storing temp files for session info.
  • Added the ability to copy and paste a non-contiguous range (data only).
  • Improved picture/shape loading performance.

Released: May 21, 2020

Updates in V20.5

Features

  • Added support ASP.NET Core and MVC.
  • Added option to access the active cell or selected cells from outside the GridWeb.

Released: Apr 16, 2020

Updates in V20.4

Features

  • Added support for the union of multiple cells as a range.
  • Added option to update Power Query Formula Item source fields.
  • Added the ability to set Latin text fonts and Asian text fonts on chart category axis.
  • Added support for databar, color scale and icon set, conditional formatting in ODS files.
  • Added the ability to open password-protected files using Aspose.Cells.GridDesktop.
  • Added support for entering a new line in the formula bar.
  • Improved performance when refreshing pivot tables.