Aspose.Cells for .NET 20.12 Release Notes
| Key | Summary | Category |
|---|---|---|
| CELLSNET-47309 | IFS formulas are wrapped with curly braces after saving with ASPOSE | New Feature |
| CELLSNET-47710 | Support Formula with Sheet() function | New Feature |
| CELLSNET-47672 | Reduce output size when converting to HTML | Enhancement |
| CELLSNET-47674 | Display additional columns when text is overlapping next cells | Enhancement |
| CELLSNET-47749 | Remove ods macro in Workbook.RemoveMacro | Enhancement |
| CELLSNET-47759 | Support h1 tag when setting Cell.HtmlString | Enhancement |
| CELLSNET-47771 | New worksheet is missing mc:Ignorable=“x14ac xr xr2 xr3” | Enhancement |
| CELLSNET-47758 | Conversion complex XLSM to HTML takes a lot of time | Performance |
| CELLSNET-47578 | Invalid markup with unopened closing SPAN tag is produced while converting Cells document to HTML | Bug |
| CELLSNET-47776 | DirectoryNotFoundException while trying to open HTML | Bug |
| CELLSNET-47643 | Some extra columns in the new output in Excel to HTML rendering | Bug |
| CELLSNET-47688 | Some TDs will cause font error for Wingdings font in HTML to PDF rendering | Bug |
| CELLSNET-47690 | Conversion of Html to Xlsx does not respect styling of the html table | Bug |
| CELLSNET-47718 | Images are aligned incorrectly when importing file to html | Bug |
| CELLSNET-47729 | Images are over lapping the text when importing html to excel | Bug |
| CELLSNET-47746 | Unencoded quotes in values of HTML attributes | Bug |
| CELLSNET-47747 | Differences while converting Excel to HTML | Bug |
| CELLSNET-47763 | Series’s value is not correct after refreshing pivot data. | Bug |
| CELLSNET-47731 | Incorrect PPMT formula execution result | Bug |
| CELLSNET-47734 | Inserting column and changing formula deletes other formulas | Bug |
| CELLSNET-47738 | autofilter does not work as excel | Bug |
| CELLSNET-47764 | Number converted to scientific during conversion from XLSX to CSV | Bug |
| CELLSNET-47740 | Text is clipped (first line is not displayed) with custom font when auto-fitting rows | Bug |
| CELLSNET-47753 | Border around icon when converting Excel to PDF | Bug |
| CELLSNETCORE-88 | SetFontFolders not working correctly with data series labels | Bug |
| CELLSNET-47739 | Legend shows the name of the series instead of the label text | Bug |
| CELLSNET-47713 | Issue with copying sheets when “hidden name definition” exists in Excel file | Bug |
| CELLSNET-47733 | Different behavior between version 20.3 and 20.11 | Bug |
| CELLSNET-47752 | Ole Object label not retrieved in Excel sheet | Bug |
| CELLSNET-47761 | File is corrupted after clearing chart title. | Bug |
| CELLSNETCORE-89 | Deleting empty columns removes the comments in the columns after the deleted column | Bug |
| CELLSNET-47732 | RefreshPivotData throws exception | Exception |
| CELLSNET-47745 | Exception raised while importing sample files | Exception |
| CELLSNET-47711 | Exception when opening ODS file | Exception |
| CELLSNET-47712 | Exception is thrown When trying to load attached document | Exception |
| CELLSNET-47715 | Cannot load Xltx file | Exception |
| CELLSNET-47735 | Exception when opening XLSB | Exception |
| CELLSNET-47741 | The column index should not be inside the pivottable report exception when calling DeleteBlankColumns | Exception |
| CELLSNET-47750 | Cannot open XLSX | Exception |
| CELLSNET-47751 | Cannot convert XLSX to XLSM | Exception |
| CELLSNET-47773 | ArgumentOutOfRangeException when converting worksheet to image | Exception |
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.