Browse our Products

Aspose.Cells for .NET 25.8 Release Notes

KeySummaryCategory
CELLSNET-54523Support for EXPAND formulaNew Feature
CELLSNET-58806Support COT/COTH functionNew Feature
CELLSNET-58809Support REDUCE functionNew Feature
CELLSNET-55776Support font Variation Selectors while converting to pdfNew Feature
CELLSNET-58803Preserve freezed top rows when converting worksheet to HTMLNew Feature
CELLSGRIDJS-1765Support API to apply font setting in textbox control in client JSNew Feature
CELLSGRIDJS-1508Support adding a batch insert row function in the menu and below the maximum row.New Feature
CELLSGRIDJS-1771Support for alignment options in number format.New Feature
CELLSGRIDJS-1772Support for border options in number format.New Feature
CELLSNET-58755Support “if” parameter of smart markerEnhancement
CELLSNET-58756Support Variables in formula smart markerEnhancement
CELLSGRIDJS-1806Support automatic text wrappingEnhancement
CELLSNET-58724Auto adjust width for textbox according its textBug
CELLSNET-58741Shape has lost some text when converting excel to pdfBug
CELLSNET-58774Excel crashes when opening the Excel file (generated by Aspose.Cells) containing free form shapeBug
CELLSNET-58274The row hidden status is incorrect after the filter operation in MemoryPreference modeBug
CELLSNET-58413NullReferenceException occurred when using LightCellsDataProvider with XlsSaveOptionsBug
CELLSNET-58497Aspose.Cells is incorrectly determining formula spill rangeBug
CELLSNET-58620Extra single quotes were added to the formula when saving xlsb to xlsmBug
CELLSNET-58684Array formulas are not fully calculatedBug
CELLSNET-58758Change default behavior of calculating AND/OR function with string parametersBug
CELLSNET-58760Table references with “@” was not calculated correctlyBug
CELLSNET-58761Excel hyperlinks break when copying rowsBug
CELLSNET-58775Calculated result of range for IFS function is incorrectBug
CELLSNET-58781Lambda functions not calculating properlyBug
CELLSNET-58791XLSM to PDF: Formulas not converted correctlyBug
CELLSNET-58792Incorrect workbook (formula) calculation when EnableCalculationChain = trueBug
CELLSNET-58804The AbstractCalculationEngine paramters sometimes reference incorrect valuesBug
CELLSNET-58719Incorrect formula processing for TOCOL and nested array multiplier with true of scan_by_columnBug
CELLSNET-58821SCAN function was not calculated correctlyBug
CELLSNET-58799DataLabels is not wrapped in TreeMap chart.Bug
CELLSNET-58826Chart labels are rendered incorrectly when converting to imageBug
CELLSNET-58850Image looks slightly different than in Excel after renderingBug
CELLSNET-52349The characters specified in the Variation Selectors are garbled when rendering to PDFBug
CELLSNET-53681Texts using IPAmj Mincho fonts show error when converting file to pdfBug
CELLSNET-55590Issue with Kanji Character Conversion from XLSX to PDFBug
CELLSNET-58372Text data displays garbled characters when converting file to pdfBug
CELLSNET-58505Some chars are garbled in Excel to PDF conversionBug
CELLSNET-58846Text is corrupted while converting to pdf with CJK edit language optionBug
CELLSNET-58687Unexpected reference after processing json smart martmarker.Bug
CELLSNET-58731Invalid vertical alignment of xlsbBug
CELLSNET-58743Outline levels not copying correctly with multiple source rangesBug
CELLSNET-58744Invalid ValidationAlertType string valBug
CELLSNET-58749Invalid referred array formulas when table was removedBug
CELLSNET-58753Duplicate named style when reading styles from xlsbBug
CELLSNET-58848Pivot tables with filters and without rows and columns lose formatting upon being refreshedBug
CELLSGRIDJS-1785Chart to image raise exception for the test fileBug
CELLSGRIDJS-1784Images do not appear after opening other pages and switching back to the worksheet in collaborative mode.Bug
CELLSGRIDJS-1787Unfreeze does not work as expectedBug
CELLSGRIDJS-1789Hide and unhide operations for rows and columns are not preserved in the downloaded fileBug
CELLSGRIDJS-1790Unfilter does not work as expectedBug
CELLSGRIDJS-1825Cell E1 displays duplicated text in the middle of the word wrapBug
CELLSGRIDJS-1831Hidden rows are still visible when loading the file CopyTO.xlsxBug
CELLSGRIDJS-1804Decimal numbers entered with commas as decimal separators are interpreted as dates.Bug
CELLSGRIDJS-1808Incorrect display of large percentage values with ‘pl’ localeBug
CELLSGRIDJS-1814Cross-origin issues when downloading files.Bug
CELLSGRIDJS-1823Range format does not work as expectedBug
CELLSNET-58765Exception “Object reference not set to an instance of an object” when merging named styles of workbooksException
CELLSNET-58766Exception “Object reference not set to an instance of an object” when saving as odsException
CELLSNET-58772OverflowException(Arithmetic operation resulted in an overflow) occurs when opening xlsx fileException

Public API and Backwards Incompatible Changes

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for .NET. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Adds enum ShapePathPointValueType.

Specifies the value type of ShapePathPoint object.

Adds ShapePathPoint.Type property.

Specifies the value type (position coordinate or angle marker) of the current object.

Adds ShapePathPoint.XPixel/YPixel properties.

When the object is a position coordinate, get or set the x/y coordinate in pixels.

Adds ShapePathPoint.XAngle/YAngle properties.

When the object is an angle marker, get or set the first/second angle in degrees.

Obsoletes ShapePathPoint.X/Y property.

Please use ShapePathPoint.XPixel/YPixel or XAngle/YAngle instead in units of pixels/degrees accordingly.

Obsoletes ShapePathPointCollection.Add method.

Please use the MoveTo, LineTo, CubicBezierTo and ArcTo methods of ShapePath instead.

Obsoletes WorkbookDesigner.Process(Range,Boolean) method and WorkbookDesigner.LineByLine property.

Please use range smart marker instead. In order to process all smart markers of a range before the version 25.8, the range must be named as _CellsSmartMarkers and WorkbookDesigner.LineByLine must be false.

For example: if we need to process all smart markers in the range A1:D4, in the old versions, we have to name the range A1:D4 as _CellsSmartMarkers and LineByLine as false, then we can process them together; Starting from 25.8, we only need to set the first smart marker in the range as &=table.column1(range:A1:D4).

Adds WorkbookDesigner.SortDataSource property.

Indicates whether to sort data source. Only works for JSON data source now.

Adds WorkbookSettings.SmartTagOptions property.

Gets the default settings for smart tags.

Adds PasteOptions.KeepOldTables property.

Indicates whether to keep tables in the destination range.

Adds MarkdownLoadOptions class.

Represents the options for loading markdown document.

Adds enum ChartColorPaletteType.

Enumerates all Monochromatic Palettes used in Excel chart.

Adds method SeriesCollection.ChangeColors(ChartColorPaletteType type).

Sets Monochromatic Palette for chart series.