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.

Released: Mar 20, 2020

Updates in V20.3

Features

• Added support for FLOOR.MATH and FILTER functions.
• Added support for setting chart series text direction to vertical.
• Reduced flickering for smooth resizing.
• Added the ability to distinguish hidden sheets.
• Improved performance when saving rows with conditional formatting and validation.

Released: Feb 20, 2020

Updates in V20.2

Features

• Added support for CSV to JSON conversion.
• Added new PivotTable.ExternalConnectionDataSource property which returns an external connection referred to by a PivotTable.
• Improves performance of PivotTable.CalculateStyle.