What's new in Aspose.Cells for .NET
Contents
[
Hide
]
This page describes the most interesting new Aspose.Cells features introduced in recent releases.
Aspose.Cells for .NET 24.12
- Support notification of formula changes when inserting/deleting cell range
- Support lambda functions of BYROW and BYCOL
- Support to render LinearGradientBrush, PathGradientBrush, HatchBrush and TextrueBrush to pcl
- Support to place inline styling/formatting instead of css when saving html
- Support to add font color, cell color as data sorter key
- Support to update order and add group to PowerQueryFormulas
- Enhancements for filters of PivotField such as multiple filters, filter whole day
- Support refreshing formula reference after inserting/deleteing row/column in GridJs
- Support update monitor for GridJs
- Support center alignement across columns for GridJs
Aspose.Cells for .NET 24.11
- Support xlsx to pcl conversion
- Support to get source of external source for PivotTable
- Support to get table relationships in excel sheet
- Support to get formatted string of cells in multi-threads
- Support “PlaceInCell” picture for MemoryPreference mode and formula calculation
- Support importing/exporting rich values such as errors, entities
- Support adding SignatureLine just like in Excel
- Improvement for generated SVG to make it behavior in the same way for different frameworks
- Enhancement for adding free form shapes
- Support to set number format type for different data types such as date, time, currency… for GridJs
- Support to render borders for row/column’s style for GridJs
- Enhancement for rendering and editing of GridJs
Aspose.Cells for .NET 24.10
- Support to get source of pivot table from corresponding external connection
- Support to create compact pivot tables
- Improve converting pivot area to range
- Support to read CHM file
- Support to ignore disorder cells/rows instead of giving exception when importing OOXML template files
- Support more options for deleting blank rows/columns
- Support to get or update server side info for GridWeb for .Net6
- Support to set different number format types for GridJs
- Support Lazy loading for GridJs
- Improve splitting text for rich text cell values for GridJs
Aspose.Cells for .NET 24.9
- Support to create Checkbox for cell and render Checkbox to pdf
- Support to export equation content to MathML and LaTex
- Support to export cell address when saving HTML
- Support parsing feature property bags of xlsx
- Optimization for releasing image resources when saving PDF
- Support to get formulas of pivot calculated item/field
- Improvement for performance of calculating grouped pivot field
- Support to detect OLE(Object Linking and Embedding) format
- Enhancement of formulas in GridJs: show formulas and formula explanation, use formulas as parameters for setting verification
- Support for syntax checking and spell correction for user input in GridJs
- Support to show time control for mobile device when cell format is time in GridJs
- Improve effect of validation editing and failure prompts of GridJs for mobile device
Aspose.Cells for .NET 24.8
- Support new functions: VALUETOTEXT, ARRAYTOTEXT
- Support GridWeb for .NET6.0 on Linux
- Support sorting pivot table by pivot field item
- Support to visit all cells that contain “Place in Cell” pictures
- Support to keep document properties without encryption when encrypting file
- Support editing formulas with blank spaces for GridWeb
- Support configuration to show or hide invisible shapes in GridJs
- Improve features of GridJs such as settings, editing formulas, input checking
Aspose.Cells for .NET 24.7
- Support DROP function in formulas
- Improve the performance of calculating LET and MAKEARRAY functions with complex parameters
- Support outline of the star characters in chart
- Support making an object as decorative
- Supporting swapping series
- Improve the display of TreeMap Chart
- Support converting picture of “overed cell” to “in cell”
- Support to load local Office cloud font by default
- Support to keep json schema when importing json data
- Support exporting to AZW3 format file
- Support to auto set height after setting wrap for cell for GridJS
- Support json generation using stream writer way for GridJS
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.