Aspose.Cells for .NET 20.11 Release Notes

CELLSNET-47706Support locale-dependent formatting pattern “aaaa” for year in Spain regionEnhancements
CELLSNET-47641Warning raised while adding 29 sheets and opening the output XLS file in MS ExcelPerformance
CELLSNET-46716Text was cut when rendering PDFBugs
CELLSNET-47618An image becomes all white and some text corruption in other images/shapesBugs
CELLSNET-47635Slicer on different table generates corrupted fileBugs
CELLSNET-47642XLSB file is corrupted after load and saveBugs
CELLSNET-47660Chart field containing dates has different format in PDF formatBugs
CELLSNET-47661Aspose.Cells generates invalid HTML markup for particular worksheet of particular Cells documentBugs
CELLSNET-47680Pivot tables were not refreshedBugs
CELLSNET-47659Issue of finding cells with specific stylesBugs
CELLSNET-47679Difference in calculation of Aspose.Cells and ExcelBugs
CELLSNET-47666Workbook cannot be displayed in SharePointBugs
CELLSNET-47698Shift in logo position while converting XLS file to PDFBugs
CELLSNET-47651Export of polar chart to pdf is skewedBugs
CELLSNET-47662Wrong data Labels appear on converting excel Chart to imageBugs
CELLSNET-47667Missing bars in bar chart in the output imageBugs
CELLSNET-47697Some Y-axis values are going outside the chart in the output PDFBugs
CELLSNET-43579WortArt text’s curvature is changed while converting from Excel to PDFBugs
CELLSNET-47675Content of XLS file is changed after loading and savingBugs
CELLSNET-47704Custom Properties vanished after edit/save a password protected (encrypted) XLS fileBugs
CELLSNET-47708Sort order was not working correctly with dynamic formulas (Smart Markers)Bugs
CELLSNET-47682Exception when loading particular HtmExceptions
CELLSNET-47683Exception when loading particular HtmExceptions
CELLSNET-47684Exception when loading particular HtmExceptions
CELLSNET-47689Exception when converting XLSB to PNG and HTMLExceptions
CELLSNET-47701Failed to create copy of XLTX workbookExceptions
CELLSNET-47628Deleting blank rows from cells causes ArgumentOutOfRangeExceptionExceptions
CELLSNET-47629Calling cell values after deleting blank rows and columns causes ArgumentExceptionExceptions
CELLSNET-47700CalculateFormula throws InvalidCastExceptionExceptions
CELLSNET-47703Exception raised while calling Workbook.CalculateFormula()Exceptions
CELLSNET-47669Invalid column index ArgumentException is thrown while converting 1st worksheet to HTMLExceptions
CELLSNET-47677DataBar.ToImage raise exception if the row is hidden.Exceptions
CELLSNET-47686Cannot convert XLSB to XLSXExceptions
CELLSNET-47687Cannot load OdsExceptions
CELLSNET-47694Exception when open document XLSX fileExceptions
CELLSNET-47695Invalid cell name after DeleteRangeExceptions
CELLSNET-47699Exception when open ODS fileExceptions
CELLSNET-47702Exception occurred when loading the encrypted “Microsoft Excel 5.0/95 Workbook” filesExceptions

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.

Deletes obsoleted CellsHelper.IsProtectedByRMS() method

Use FileFormatUtil.DetectFileFormat().IsProtectedByRMS property instead.

Deletes obsoleted CellsHelper.DetectLoadFormat() and CellsHelper.DetectFileFormat() method

Use FileFormatUtil.DetectFileFormat() instead.

Deletes obsoleted CellsHelper.FontDir property.

Use FontConfigs.SetFontsFolder(string, bool) instead.

Deletes obsoleted CellsHelper.FontDirs property.

Use FontConfigs.SetFontFolders(string[], bool) instead.

Deletes obsoleted CellsHelper.FontFiles property.

Use FontConfigs.SetFontSources(FontSourceBase[]) instead.

Adds CellsHelper.IsCloudPlatform property.

Indicates whether running on the could platform.

Adds Shape.Worksheet property.

Gets the worksheet which contains this shape.

Adds SaveOptions.SortExternalNames property.

Indicates whether sorting external names when saving .xlsx files.

Adds ListObject.Filter() method.

Filters the table.

Adds XmlMapCollection.Clear() method.

Clears all xml maps.

Adds SaveFormat.Docx enum.

Represents that saving as .docx files.

Adds ImageType.OfficeCompatibleEmf enum.

Windows Enhanced Metafile which is more compatible with Office.