Aspose.Cells for .NET 20.12 Release Notes

CELLSNET-47309IFS formulas are wrapped with curly braces after saving with ASPOSENew Feature
CELLSNET-47710Support Formula with Sheet() functionNew Feature
CELLSNET-47672Reduce output size when converting to HTMLEnhancement
CELLSNET-47674Display additional columns when text is overlapping next cellsEnhancement
CELLSNET-47749Remove ods macro in Workbook.RemoveMacroEnhancement
CELLSNET-47759Support h1 tag when setting Cell.HtmlStringEnhancement
CELLSNET-47771New worksheet is missing mc:Ignorable=“x14ac xr xr2 xr3”Enhancement
CELLSNET-47758Conversion complex XLSM to HTML takes a lot of timePerformance
CELLSNET-47578Invalid markup with unopened closing SPAN tag is produced while converting Cells document to HTMLBug
CELLSNET-47776DirectoryNotFoundException while trying to open HTMLBug
CELLSNET-47643Some extra columns in the new output in Excel to HTML renderingBug
CELLSNET-47688Some TDs will cause font error for Wingdings font in HTML to PDF renderingBug
CELLSNET-47690Conversion of Html to Xlsx does not respect styling of the html tableBug
CELLSNET-47718Images are aligned incorrectly when importing file to htmlBug
CELLSNET-47729Images are over lapping the text when importing html to excelBug
CELLSNET-47746Unencoded quotes in values of HTML attributesBug
CELLSNET-47747Differences while converting Excel to HTMLBug
CELLSNET-47763Series’s value is not correct after refreshing pivot data.Bug
CELLSNET-47731Incorrect PPMT formula execution resultBug
CELLSNET-47734Inserting column and changing formula deletes other formulasBug
CELLSNET-47738autofilter does not work as excelBug
CELLSNET-47764Number converted to scientific during conversion from XLSX to CSVBug
CELLSNET-47740Text is clipped (first line is not displayed) with custom font when auto-fitting rowsBug
CELLSNET-47753Border around icon when converting Excel to PDFBug
CELLSNETCORE-88SetFontFolders not working correctly with data series labelsBug
CELLSNET-47739Legend shows the name of the series instead of the label textBug
CELLSNET-47713Issue with copying sheets when “hidden name definition” exists in Excel fileBug
CELLSNET-47733Different behavior between version 20.3 and 20.11Bug
CELLSNET-47752Ole Object label not retrieved in Excel sheetBug
CELLSNET-47761File is corrupted after clearing chart title.Bug
CELLSNETCORE-89Deleting empty columns removes the comments in the columns after the deleted columnBug
CELLSNET-47732RefreshPivotData throws exceptionException
CELLSNET-47745Exception raised while importing sample filesException
CELLSNET-47711Exception when opening ODS fileException
CELLSNET-47712Exception is thrown When trying to load attached documentException
CELLSNET-47715Cannot load Xltx fileException
CELLSNET-47735Exception when opening XLSBException
CELLSNET-47741The column index should not be inside the pivottable report exception when calling DeleteBlankColumnsException
CELLSNET-47750Cannot open XLSXException
CELLSNET-47751Cannot convert XLSX to XLSMException
CELLSNET-47773ArgumentOutOfRangeException when converting worksheet to imageException

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 Cell.SetDynamicArrayFormula(string arrayFormula, FormulaParseOptions options, bool calculate) method.

Supports to set dynamic array formula and spill into neighboring cells if possible.

Adds Workbook.RefreshDynamicArrayFormulas(bool calculate) method.

Supports to refresh dynamic array formulas and spill into neighboring cells according to current data.

Adds Cell.Comment property.

Gets the comment of the cell.

Adds HtmlSaveOptions.ExportExtraHeadings property

Indicates whether exporting extra headings when the length of text is longer than max display column. The default value is false. If you want to import the html file to excel, please keep the default value.

Adds HtmlSaveOptions.ExportFormula property

Indicates whether exporting formula when saving file to html. The default value is true. If you want to import the output html to excel, please keep the default value.

Adds HtmlSaveOptions.MergeEmptyTdForcely property

Indicates whether merging empty TD element forcely when exporting file to html. The size of html file will be reduced significantly after setting value to true. The default value is false. If you want to import the html file to excel or export perfect grid lines when saving file to html, please keep the default value.

Adds LoadOptions.AutoFilter property

Indicates whether auto filtering the data when loading the files. Sometimes although autofilter is set, the corresponding rows is not hidden in the file.Now only works for SpreadSheetML file.

Adds WorkbookSettings.Author property

Gets and sets the author of the workbook.

Adds MultipleFilterCollection.Add() method.

Adds filter string of auto filter.