Released: Mar 11, 2024

Updates in V24.3

Features

• Added support for EVALUATE function.
• Improved filtering in GridDesktop.
• Support for rich text when using formula editor box.
• Convert Microsoft Excel spreadsheets to ODS using ODF 1.3 standard.
• Support for processing navigation links when converting AZW3 to XLSX.

Fixes

• The ratios of width and height do not change simultaneously when Picture.IsLockAspectRatio is set to true.
• Data shift failed after calling InsertRange method.
• ISERROR function returns false for NPER #NUM! error.
• Calling...

Released: Feb 5, 2024

Updates in V24.2

Features

• Added support for the TOROW/TOCOL functions.
• Show "convert to number" menu for cells which have a number stored as text.
• Added support for copying/pasting image and HTML content to GridDesktop.
• Added key word search support for filter list to GridDesktop.
• Added support for clear filter operation to GridDesktop.
• Added support for number filter for GridDesktop.
• Added support for detecting OXPS format.
• Added support for parsing color attribute containing "var" or "rgba" fields.
• Improved...

Released: Jan 12, 2024

Updates in V24.1

Features

• Added the ability to keep the header row for each worksheet when converting a CSV to Microsoft Excel.
• Added support for Microsoft .NET 8.
• Added a new GridDesktop auto-fill feature.
• Added support for adding custom styles when exporting files to HTML.
• Added auto-fill support for the merge area.
• Added support for setting wrap using the UI.
• Added support for setting text rotation using the UI.
• Auto-fill data from right to left and bottom to up.
• Show the active sheet background in the bottom...

Released: Dec 14, 2023

Updates in V23.12

Features

• Added support for rendering rotated cell text.
• Added support for PDF/A-2b (ISO 19005-2), PDF/A-2u (ISO 19005-2), PDF/A-2a (ISO 19005-2), PDF/A-3b (ISO 19005-3), PDF/A-3u (ISO 19005-3) and PDF/A-3a (ISO 19005-3) compliance while converting workbooks to PDF.
• You can now keep missing data when refreshing and calculating pivot tables.
• Added support for calculating discrete grouping in pivot table.
• Added support for exporting generic lists.
• Added an auto clear data validation setting in...

Released: Nov 16, 2023

Updates in V23.11

Features

• Added support for Apple macOS ARM versions.
• Grid Desktop:
  • Added support for copy/delete/insert/rename worksheet operations.
  • Auto extend max rows/columns when performing paste operations.
  • Added support for 'SheetPrintingPreview' and 'PdfSaveOptions'.
• Generate ISO32000-1:2008 PDFs.
• Localize dates on grouping fields.
• Added support for 'LET' function.
• Added support for keeping data when removing pivot tables.

Fixes

• Removes all merged cells in the range when calling Cells.Unmerge...

Released: Oct 13, 2023

Updates in V23.10

Features

• Added support for adaptive paste operation when size of target range is different from source range.
• Added new API for setting range hyperlinks directly on Range.
• Added support for copying multiple worksheets simultaneously and preserving dependencies.
• Improved performance for setting formulas with sheet references for large amount of cells.
• Updated to SkiaSharp 2.88.6.
• You can now ignore the threaded comments when printing comments in place.
• Added support for checking whether one cell...

Released: Sep 15, 2023

Updates in V23.9

Features

• Added support for calculating LAMBDA, MAP and SCAN functions.
• Added support for parsing and calculating formulas with user defined custom function and definition.
• Added support for excluding specific data when exporting data to DataTable.
• Added localization support to GridDesktop.
• Added support for picture click event to GridDesktop.
• You can now auto extend empty rows/columns when scrolling down/right like Microsoft Excel.
• Added support for selecting text within a textbox control while...

Released: Aug 23, 2023

Updates in V23.8

Features

• Improved UI display for dropdowns with long lists of data.
• Added support for preserving padding space in formulas.
• Conditional formatting formulas can now be ignored when saving to XLSB format.

Fixes

• CHAR function returns error value when calling CalculateFormula.
• DataSorter does not clear old data when new data is blank.
• Incorrect result of calculating NUMBERVALUE Formula.
• Function’s calculated value changes from “#REF!” to “#VALUE!” after changing file format from xlsx to xls.
• Symbols...

Released: Jul 19, 2023

Updates in V23.7

Features

• Added support for rendering background color and border in GridWeb Textbox control.
• Added support for Microsoft Visio file type detection.
• Added support for Microsoft OneNote package file type detection.
• Added support for XAdES signatures for CSharp X509Certificate2.
• Added support for Workbook digital signatures in Blazor Web Assembly.
• Added support for VBA signatures in Blazor Web Assembly.
• Added support for encrypting/decrypting ODS in Blazor Web Assembly.

Fixes

• Aspose.Cells is not...

Released: Jun 16, 2023

Updates in V23.6

Features

• Added support for traversing row/cell in reverse order.
• Added support for refreshing multiple consolidation ranges in a pivot table.
• Added support for extending rows when setting a total formula.
• Improved detection of Gzip files.

Fixes

• Row with no data should be taken as blank and removed by Cells.DeleteBlankRows() even if there is merged cells intersect with it.
• Chart does not get updated when writing new lines to a listobject with Aspose.Cells.
• Arrow Shapes placed incorrectly after...