Browse our Products

Aspose.Cells for .NET 19.11 Release Notes

CELLSNET-44956Support to hide selected ranges and sort the displayed results of Pivot TableNew Feature
CELLSNET-46852Support reading and writing table whose data source is a query table in the XLS file.New Feature
CELLSNET-46967Support to get indent size in unit of pixelsNew Feature
CELLSNET-46973Excel formula not working in generated XLS fileEnhancement
CELLSNET-46981Support to read/write with memory stream for Workbook.ImportXml and Workbook.ExportXmlEnhancement
CELLSNET-46905No changes for link source saved in XLS fileEnhancement
CELLSNET-46898The background of the 3D model turns blueBug
CELLSNET-46314Issues while refreshing Pivot Table with “Show value as % of grand total”Bug
CELLSNET-46789CalculateData method does not work correctly with PDF formatBug
CELLSNET-46955HTML to Excel file raises exception “Item has already been added”Bug
CELLSNET-46987Can’t calculate formula when referencing cellsBug
CELLSNET-46968The indirect formula does not work properly in MS ExcelBug
CELLSNET-46991XLSX file is corrupted.Bug
CELLSNET-46994#Value! in the output Excel file (Opened in Excel 365)after calling the Calculate FormulaBug
CELLSNET-47001CalculateFormula() causes NullReferenceExceptionBug
CELLSNET-46953Content is cut when printingBug
CELLSNET-46966Right Border missing when HorizontalAlignment is set to FillBug
CELLSNET-45362Tile picture options don’t work for chart backgrounds in XLS filesBug
CELLSNET-46949OLE objects become pictures when copying worksheetsBug
CELLSNET-46963Chart labels lose formatting after saving Excel fileBug
CELLSNET-46965Calling Chart.Calculate() on an empty chart that has an empty auto-text title throws an errorBug
CELLSNET-46971The newly copied sheet is un-hiding any hidden columns and also resetting columns widthBug
CELLSNET-46972Comma removed from chart titles once Excel file is decryptedBug
CELLSNET-46912StackOverflowException thrown while converting XLSX to HTMLException

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 methods: Validation.AddArea(CellArea,bool,bool),AddAreas(CellArea[], bool, bool),RemoveAreas(CellArea[])

Adds/Removes validation settings from given area(s) with performance consideration.

Adds Workbook.ImportXml(Stream stream, string sheetName, int row, int col) method.

Imports an XML file stream into the workbook.

Adds Workbook.ExportXml(string mapName, Stream stream) method.

Export XML data to a stream.

Adds HtmlSaveOptions.ExportArea property

Gets or Sets the exporting CellArea of current active Worksheet. If you set this attribute, the print area of the current active Worksheet will be omitted. Only the specified area will be exported when saving the file to HTML.

Adds classes : DataMashup,PowerQueryFormula,PowerQueryFormulaCollection,PowerQueryFormulaItem and PowerQueryFormulaItemCollection

Gets info in the DataMashup.

Adds DBConnection.SeverCommand property.

Gets and sets a second command text string that is persisted when PivotTable server-based page fields are in use. 

Adds CellsHelper.GetTextWidth() method.

Gets the width of the text in the unit of points.