Aspose.Cells for .NET 18.1 Release Notes

Major News

Xamarin

Aspose.Cells for for .NET now also includes Aspose.Cells for iOS via Xamarin and Aspose.Cells for Android via Xamarin assemblies with its regular .NET Dlls.

KeySummaryCategory
CELLSNET-45740Find the children Pivot Tables of parent Parent Pivot TableNew Feature 
CELLSNET-45771Handle automatic axis units like Microsoft ExcelNew Feature 
CELLSNET-45668Read and write tableSingleCells of XLSB file New Feature 
CELLSNET-45830Add events after deleting rows and columns in Aspose.Cells.GridDesktopNew Feature 
CELLSNET-45805GridWeb does not render Scrollbars correctlyNew Feature 
CELLSNET-45845Unsupported external stylesheet during round-trip conversionEnhancement 
CELLSNET-45803XLS format should match with MS Excel 2016Enhancement 
CELLSNET-45842FontSettings are overwriting each other while MS Excel keeps both of themEnhancement 
CELLSNET-45653Filtering in GridDesktop does not work properly or like Microsoft ExcelEnhancement 
CELLSNET-45763Shape text is rotated in Excel to PDF conversionBug 
CELLSNET-45669Characters overlap when converting to ImageBug 
CELLSNET-45841XLSB file dealing with Power Pivot corrupts on opening and re-savingBug 
CELLSNET-45819Borders are not shown when export from HTML to ExcelBug 
CELLSNET-45807Gridlines do not appear when HtmlSaveOptions.ExportActiveWorksheetOnly property is set to trueBug 
CELLSNET-45788Support exporting the separate stylesheet for a single-tab documentBug 
CELLSNET-45826Image properties (Title and Subject) are lost after converting XLSX to PDFBug 
CELLSNET-45811Rendering Excel cuts the right border with some data lossBug 
CELLSNET-45808Converting Excel to PDF cuts word with apostrophes when using RTL languageBug 
CELLSNET-45840Chart is stretched up after saving to XLS format - “mouseover event - embedded.xls”Bug 
CELLSNET-45815Chart.Calculate is hanging when QAR_symbol is set as “丿.兀.”Bug 
CELLSNET-45765Charts could not be exported when custom format is using “mm” formatBug 
CELLSNET-45756Sheet having chart shows changes when the Excel file is opened and re-savedBug 
CELLSNET-45580Graph size is changed in a specific XLS fileBug 
CELLSNET-45018Excel Graph changed after load and saveBug 
CELLSNET-44901Legend entries have moved slightly down after simple resaveBug 
CELLSNET-45775Second vertical axis label is missing when converting chart to imageBug 
CELLSNET-45850Error when copying sheet from one book to anotherBug 
CELLSNET-45847SpreadsheetML to XLSX - Aspose.Cells sets protection settingsBug 
CELLSNET-45846MS Excel prompts an error message when opening the re-saved file into itBug 
CELLSNET-45838Left graph i.e. “Seasonal Adjustment” - the Bars size changes in the output Excel fileBug 
CELLSNET-45837Spreadsheet XML gets invalidated because it contains elements with double prefixBug 
CELLSNET-45835Cell.R1C1Formula returns null when referencing named range(s)Bug 
CELLSNET-45834Embedded Pdf Image is broken after inserting OLE objectBug 
CELLSNET-45831Calculation chain part missed after conversion (XLSB -> XLSM)Bug 
CELLSNET-45827ImportCustomObjects does not import field names when list count is zeroBug 
CELLSNET-45816Invalid formula error on opening the fileBug 
CELLSNET-45814Vertical alignment is not applying to the range of cellsBug 
CELLSNET-45812Absolute path changes to relative path when re-saving an XLSX fileBug 
CELLSNET-45810RGB(255, 0, 0) is not a valid value for Int32 on HtmlString assignmentBug 
CELLSNET-44690Re-saving the XLS stretches the chart verticallyBug 
CELLSNET-44621Conversion from XLSB to XLSM: Resulting file does not contain xl\queryTables\queryTable1Bug 
CELLSNET-45800When click on cell A1, it jumps to other cell and focused cell position is wrongBug 
CELLSNET-45793Group status is wrong after collapse/expand - Aspose.Cells.GridDesktopBug 
CELLSNET-45829When XLSX is saved as HTML, an exception IndexOutOfRangeException occursException 
CELLSNET-45825System.OutOfMemoryException when rendering image of the chartException 
CELLSNET-45844Excel file is opened from Email fine but it does not open using Aspose.CellsException 
CELLSNET-45823Exception when opening a SpreadsheetML fileException 
CELLSNET-45817Exception when setting HtmlString on a cell to specific valueException 
CELLSNET-45832Exception when loading an XLSM file into GridWebException 
CELLSNET-45806Index out of rang exception with Time field subtraction formula in Aspose.Cells.GridDesktopException 

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 LoadOptions.ParsingPivotCachedRecords property

Indicates whether parsing pivot cached records when loading the file.The default value is false.Only applies to Excel Xlsx, Xltx, Xltm, Xlsm and Xlsb file formats.

Adds HtmlSaveOptions.ExcludeUnusedStyles property

Indicates whether excluding unused styles.The default value is false. If you want to import the HTML or Mht file to Excel, please keep the default value.

Adds HtmlSaveOptions.ExportDocumentProperties property

Indicates whether exporting document properties.The default value is true. If you want to import the HTML or Mht file to Excel, please keep the default value.

Adds HtmlSaveOptions.ExportWorksheetProperties property

Indicates whether exporting worksheet properties.The default value is true. If you want to import the HTML or Mht file to Excel, please keep the default value.

Adds HtmlSaveOptions.ExportWorkbookProperties property

Indicates whether exporting workbook properties.The default value is true. If you want to import the HTML or Mht file to Excel, please keep the default value.

Adds PivotTable.GetChildren() method

Gets the the children Pivot Tables which use this PivotTable data as data source.