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 24.6

  • Enhancements for rendering: color saturation and color temperature adjustment, duotones, Webp images
  • Enhancements for PivotTable: merging range, “Show Values as” of PivotField
  • Support Range.ToHtml()/ToImage() for user’s convenience to manipulate range data

Aspose.Cells for .NET 24.5

  • Support new functions: XMATCH, XOR
  • Support to transpose data of the range
  • Support to get properties of advanced filter settings
  • Support to render picture placed in cell to pdf/image
  • Support to copy styles to autofill for GridJS
  • Support chart color setting for GridJS

Aspose.Cells for .NET 24.4

  • Provide simple implementations of interrupt monitor for user’s convenience
  • Support to embed attachments when converting OLE Object to pdf
  • Support to render auto shape of ChartX to image
  • Support to embed image into cell(“Place in Cell” operation for picture in ms excel)
  • Enhancements for importing Numbers file: merged cells, hidden rows/columns, …etc.

Aspose.Cells for .NET 24.3

  • Support to import AZW3 file
  • Support to save ods with odf 1.3 standard
  • Support to calculate EVALUATE function
  • Support filters for GridDesktop: Top10, Date, Text
  • Add more formulas in insert menu and help tips for GridJS
  • Add categorization feature to formula menu for GridJS
  • Automatically set cell to date format for GridJS when the calculated result is datetime

Aspose.Cells for .NET 24.2

  • Support new functions: TEXTAFTER,TEXTBEFORE,TEXTSPLIT,TOROW,TOCOL
  • Support detecting oxps format
  • Improve performance for sorting large dataset
  • Enhancment for operations about filter for GridDesktop: number filter, key word search, clear filter.

Aspose.Cells for .NET 24.1

  • Support NET8
  • Support to import csv data with user specified header rows/columns and total rows/columns per sheet
  • Support to export html with custom styles
  • Support auto filling for merged areas
  • Support auto filling data from right to left and bottom to up

Aspose.Cells for .NET 23.12

  • Support for PDF/A-2 and PDF/A-3 compliance while converting to pdf
  • Support calculating discrete grouping of pivot table
  • Support to export cells data to generic list
  • Support to import cross references using linked tables for smart markers
  • Support MAKEARRAY function for formulas
  • Support to render cell text with rotation angle for GridJS
  • Support more options for importing/exporting datatable for GridDesktop
  • Support render picture with rotation for GridDesktop
  • Support to adjust worksheet order for GridDesktop
  • Support option of showing/hidding formula warning message for GridDesktop

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.