Aspose.Cells for .NET 18.6 Release Notes

Key Summary Category
CELLSNET-46159 Render Slicer shape to image format  New Feature 
CELLSNET-46179 Update Slicer in XLSB and XLSX file formats New Feature 
CELLSNET-46167 Create Slicer in XLSB and XLSX file formats  New Feature 
CELLSNET-44455 Create or update Slicer in Excel 2013 using Aspose.Cells  New Feature 
CELLSNET-46130 Add API to get & set CustomXmlPart ID New Feature 
CELLSNET-46145 Improve converting line Callout to image Enhancement 
CELLSNET-46174 WorkbookRender.ToImage(pageIndex, fileName/stream) and Bitmap WorkbookRender.ToImage(int pageIndex) methods included  Enhancement 
CELLSNET-46178 Support DateTimeOffset format when importing custom objects Enhancement 
CELLSNET-46171 GroupShape definition is misleading Enhancement 
CELLSNET-46152 Relevant methods in Aspose.Cells API are added for GetRangeAddess(), GetCellCount(), GetEntireAddress() and GetOffset()  Enhancement 
CELLSNET-46122 Convert smart art from XLSX to XLS file format  Enhancement 
CELLSNET-46121 Convert smart art from XLS to XLSX file format  Enhancement 
CELLSNET-45961 Ink tools disappeared when converting to PDF Enhancement 
CELLSNET-45160 Portions of the picture in the spreadsheet renders in different color while converting worksheet to image Enhancement 
CELLSNET-43592 Ink Objects does not render while converting spreadsheet to PDF format Enhancement 
CELLSNET-45891 Some shapes are missing and some are dispersed (dis-positioned) - Excel to HTML conversion  Bug 
CELLSNET-46112 When Issue4 callout placement.xlsx converted to PDF, formatting is not good  Bug 
CELLSNET-45212 Displaced bigger image on converting an XLSM to PDF Bug 
CELLSNET-42636 Some drawing shapes are displaced or rendered wrongly in Excel to HTML rendering Bug 
CELLSNET-42627 Unable to extract smart art images correctly Bug 
CELLSNET-42618 Shape is displaced to cover data in Excel to HTML rendering Bug 
CELLSNET-46146 All previous columns and rows data stay in the PivotTable after filtering Bug 
CELLSNET-46127 Output HTML is good in Chrome but wrong in IE or Edge Bug 
CELLSNET-45005 Rows imported to single cell when importing HTML file format Bug 
CELLSNET-45004 Cell value truncated when importing HTML Bug 
CELLSNET-46162 Single quotes disappear from the formula when opening the file Bug 
CELLSNET-46069 Formulas (containing linked data source in other workbooks) are not calculated fine Bug 
CELLSNET-46142 Tab bar becomes hidden when user changes tab because Grid height grows up Bug 
CELLSNET-46177 Print from Aspose.Cells differs from Excel Bug 
CELLSNET-46176 PDF output ignores all the page breaks inside an MS Excel file Bug 
CELLSNET-46153 Shape color changes when convert to PDF file format Bug 
CELLSNET-46126 Excel document is slipping while saving as PDF  Bug 
CELLSNET-46125 Mixture of page 1 and page 2 in the output PDF  Bug 
CELLSNET-46114 Single word is splitted into two lines in Aspose.Cells' rendered output image Bug 
CELLSNET-45766 Unable to load password-protected ODS file Bug 
CELLSNET-46164 Pareto chart does not display in MS Excel file but it renders somewhat fine in PDF Bug 
CELLSNET-46155 The chart horizontal axis label is corrupted  Bug 
CELLSNET-46150 Saving XLT file as XLS after clearing chart’s data series causes red “Protected View” warning Bug 
CELLSNET-46140 Watermark works fine with the spreadsheets but nothing shows up on charts Bug 
CELLSNET-46129 Y-axis ticks in chart image do not match with MS-Excel Bug 
CELLSNET-46100 CellsException - System.OutOfMemoryException while converting Excel file to PDF  Bug 
CELLSNET-46082 Pie chart legend colors change after saving to PDF and do not match up with pie chart slices Bug 
CELLSNET-46072 Saving an XLT/XLTX file as XLS/XLSX causes red “Protected View” warning Bug 
CELLSNET-46166 Hyperlinks are corrupted when referencing to sheet with special characters in its name Bug 
CELLSNET-46141 Standardized way for last three numbers in the signature shape name Bug 
CELLSNET-46131 Resizing headless table corrupts the output MS Excel file Bug 
CELLSNET-46128 Output Excel File is corrupt after creating list object Bug 
CELLSNET-46134 When render an Excel document to PDF, the process never finishes Bug
CELLSNET-46175 Aspose.Cells.CellsException at Aspose.Cells.Workbook.Save() Exception 
CELLSNET-46147 Error initializing an XLSX file Exception 
CELLSNET-46138 EndOfStreamException when Aspose.Cells.Dll (latest assembly) is ilmerged Exception 
CELLSNET-46173 Exception: “File is corrupted” when loading an XLS file Exception 
CELLSNET-46137 ArgumentOutOfRangeException when Aspose.Cells (latest assembly) is ilmerged 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 Slicer, SlicerCollection, SlicerCache, SlicerCacheItem and SlicerCacheItemCollection classes

These APIs are used to create and modify the Slicer in the file.

Adds SlicerCacheItemSortType and SlicerStyleType enums

These APIs are used to create and modify the Slicer in the file.

Adds CellWatchCollection and CellWatch classes, Adds Worksheet.CellWatches property

Adds Cell Watch Item in the ‘watch window’.

Adds CustomXmlShape class and MsoDrawingType.CustomXml enum

Supports keeping custom xml shape.

Adds MsoDrawingType.SmartArt enum

Represents the smart art shape type.

Adds Font.SchemeType property and FontSchemeType enums

Gets and sets the scheme type of the font.

Adds CustomXmlPart.ID property

Gets and sets the Id of custom xml part.

Adds CustomXmlPartCollection.SelectByID() method

Gets Custom xml part by id.

Adds Range.Address, Range.CellCount, EntireColumn, Range.EntireRow and Range.GetOffset(System.Int32,System.Int32)

Enhancement for processing range.

Adds ColorDepth enum and ImageOrPrintOptions.TiffColorDepth property

Gets or sets bit depth to apply only when saving pages to the Tiff format.

Overloads WorkbookRender.ToImage() method

Renders the workbook to image by the page index.

Adds Legend.LegendEntriesLabels() method

Gets the labels of the legend entries after calling Chart.Calculate() method.

Adds CustomFilter.SetCriteria(FilterOperatorType filterOperator, object criteria) method

Sets the filter criteria.

Provides new APIs for supporting to get/set formulas in locale dependent format (the FormulaLocal function of Microsoft Interop)

Cell.GetFormula(bool isR1C1, bool isLocal) Cell.SetFormula(string formula, bool isR1C1, bool isLocal, object value) Name.GetRefersTo(bool isR1C1, bool isLocal) Name.SetRefersTo(string refersTo, bool isR1C1, bool isLocal) FormatCondition.GetFormula1(bool isR1C1, bool isLocal) FormatCondition.SetFormula1(string formula, bool isR1C1, bool isLocal) FormatCondition.GetFormula2(bool isR1C1, bool isLocal) FormatCondition.SetFormula2(string formula, bool isR1C1, bool isLocal) FormatCondition.GetFormula1(bool isR1C1, bool isLocal, int row, int column) FormatCondition.GetFormula2(bool isR1C1, bool isLocal, int row, int column) GlobalizationSettings.GetTableRowTypeOfHeaders() GlobalizationSettings.GetTableRowTypeOfData() GlobalizationSettings.GetTableRowTypeOfAll() GlobalizationSettings.GetTableRowTypeOfTotals() GlobalizationSettings.GetTableRowTypeOfCurrent() GlobalizationSettings.GetErrorValueString(string err) GlobalizationSettings.GetBooleanValueString(bool bv) GlobalizationSettings.GetLocalFunctionName(string standardName) GlobalizationSettings.GetStandardFunctionName(string localName) GlobalizationSettings.GetLocalBuiltInName(string standardName) GlobalizationSettings.GetStandardBuiltInName(string localName) GlobalizationSettings.ListSeparator GlobalizationSettings.RowSeparatorOfFormulaArray GlobalizationSettings.ColumnSeparatorOfFormulaArray