What's new in Aspose.Cells for .NET

This page describes the most interesting new Aspose.Cells features introduced in recent releases.

Aspose.Cells for .NET 23.11

Support to convert spreadsheets to PDF file version 1.7(ISO32000-1:2008)
Support to insert form controls for GridJS
Support to show gradient fill of cell background for GridJS
Support to copy/delete/insert/rename worksheet for GridDesktop
Support auto extending max rows/columns when doing paste operation for GridDesktop
Support SheetPrintingPreview for GridDesktop
Provide .NET Core build of GridDesktop

Aspose.Cells for .NET 23.10

Support adaptive paste operation when size of target range is different from source range
Support to set hyperlinks directly to a Range
Support to copy multiple worksheets simultaneously
Support to check whether one range is empty for cells data

Aspose.Cells for .NET 23.9

Support to calculate new functions in formula: LAMBDA,LET,MAP,SCAN
Support to import/export EPUB files
Support to filter chart series
Support localization for GridDesktop
Provide GridWeb for .net7-windows platform

Aspose.Cells for .NET 23.8

Support to preserve padding space in formulas
Support to replace/insert text with formatting for richtext of cell
Support to render activex control and form control for spin button in GridJs
Support more types of validation for GridJs: textlength/decimal, select list, formula expression

Aspose.Cells for .NET 23.7

Enhancement for many features of GridJS such as rendering controls, serverside saveback for combobox, …etc.
Enhanced file format detection for some new formats such as visio file, OneNote package file.
Support XAdES signatures for CSharp X509Certificate2
Support to work in Blazor Web Assembly

Aspose.Cells for .NET 23.6

Support to export and highlight revision logs
Support to traverse existing Row objects from RowCollection in reversed order
Support to refresh multiple consolidation ranges of pivottable
Support to show chart sheet in GridJs
Support to display cell overflow content in GridJs
Support to display background image for GridJs
Support to filter by datetime in GridJs

Aspose.Cells for .NET 23.5

Support to update external references of external sheet data to the local sheet of current workbook
Support to render Checkbox control as interactive control instead of static picture
Support to select PivotArea and format it
Support to add watermark while converting to pdf

Aspose.Cells for .NET 23.4

Support to calculate function ENCODEURL
Support to complete the construction of an equation shape by inserting relevant nodes step by step
Support to calculate formula expression as array formula without setting it to a cell object
Support to save xlsb file in LightCells mode
Support to check whether one font is installed or available
Support to set formula to specified cell in the ListObject
Support to save workbook as xhtml
Support to render activex control and form control for GridWeb

Aspose.Cells for .NET 23.3

Support to set/read/save new functions: LET, ENCODEURL
Support to link data sources to external links when calling formula calculation

Aspose.Cells for .NET 23.2

Support to set/read/save new functions: SCAN, LAMBDA
Support to export style to json

Aspose.Cells for .NET 23.1

Support new functions: CHOOSEROWS, CHOOSECOLS, HSTACK, VSTACK
Support to get author and date time from revisions

Aspose.Cells for .NET 22.12

Support to export excel to JSON with multi-layered hierarchy structure

Aspose.Cells for .NET 22.11

Support to distinguish between dynamic array formula and legacy array formula
Support to read/save dynamic array formulas for xlsb file format

Aspose.Cells for .NET 22.10

Support to use SkiaSharp as the graphics library for NET6
Support to add and update chart with CRTX template file

Aspose.Cells for .NET 22.9

Support to set table formula for cells
Support to set dynamic array formula with custom function and calculation engine
Support to set preset gradient settings for gradient fill format
Support to apply outlline borders with Theme colors for Range

Aspose.Cells for .NET 22.8

Support exporting comments and notes as displayed on sheet to html
Support specifying worksheets to output while converting to pdf/xps

Aspose.Cells for .NET 22.7

Support to export html to a single file with page header/footer
Support to get absolute position and size of Range(in points)

Aspose.Cells for .NET 22.6

Improvement for calculating and tracing formulas with formula calculation chain

Aspose.Cells for .NET 22.5

Improvement for memory performance of setting cells formula while saving workbook in LightCells mode

Aspose.Cells for .NET 22.4

Enhanced options to control blank cells for exporting CSV.
Support complicated split and update of conditional formatting for insert/delete operations

Aspose.Cells for .NET 22.3

Support to re-calculate cells which depend on defined name when the defined name is changed and workbook’s calculation chain is enabled.
Support to get cell’s leafs recursively according to formulas' calculation chain

Aspose.Cells for .NET 22.2

Support to extract defined names from NameCollection by speicified scope filter.

Aspose.Cells for .NET 22.1

Support to generate editable pptx
Support to import large csv into multiple worksheets when data row/column exceeding limit
Support to import csv with LightCells
Support to remove specified external link
Support to keep formulas while removing external links

Aspose.Cells for .NET 21.12

Support converting Excel to SQL Scripts
Support importing and exporting plain xml data
Support to read as much data as possible from corrupted xls file
Support to interrupt the process of SmartMarker
Improve performance for adding ranges for conditional formatting and validation
Set priority as highest for the newly added format condition, just like the behavior of ms excel

Aspose.Cells for .NET 21.11

Support calculating XLookup formula/function.
Integrate saving json and images to saving workbook.
Improve performance while converting Excel to HTML.

Getting Started