Aspose.Cells for .NET 18.3 Release Notes

CELLSNET-42655Group pivot fields in the Pivot Table  New Feature 
CELLSNET-45960Change the dot from NumPad to decimal separator (’,') - Aspose.Cells.GridWebNew Feature 
CELLSNET-45966Cause of exception during backward HTML-to-Cells conversionEnhancement 
CELLSNET-45976Error opening ODS file due to possibly different frameworks keep different precision for float valuesEnhancement 
CELLSNET-45981Add property to the StyleFlag to be set to false to not override the QuotePrefix valueEnhancement 
CELLSNET-45957Support keeping the map chart in the template file Enhancement 
CELLSNET-45941ActiveX control becomes picture when copying sheet from one workbook to another workbookEnhancement 
CELLSNET-45928Data validation - GridWeb should display a dialog with an error messageEnhancement 
CELLSNET-45935Workbook.CalculateFormula hangs infinitely when setting specific value to the cellPerformance
CELLSNET-45920Underline of text “KEY DRIVERS:” is broken in the output imageBug 
CELLSNET-45939Besides broken underline, text is also misaligned as shown in provided screenshotBug 
CELLSNET-45890Some shapes are not rendered completely as a few parts are missingBug 
CELLSNET-45878Output Excel file of new version crashes the Microsoft Excel 2016Bug 
CELLSNET-43360Style issue with HTML to Excel renderingBug 
CELLSNET-45979VLOOKUPS formula calculation is not working correctlyBug 
CELLSNET-45949Cell text alignment (having mixed fonts) is changed in the converted imageBug 
CELLSNET-45940Conditional formatting not applied while converting Excel file to PDF file format Bug 
CELLSNET-45896Unwanted borders appear around the image when Excel file is saved to PDF Bug 
CELLSNET-45942The cell reference for the data label gets lost after open/saveBug 
CELLSNET-45923Last axis label i.e. Jun 17 is missing from the chart imageBug 
CELLSNET-45911Bad position and line in the rendering of Market Risk chartBug 
CELLSNET-45908Bad position in chart rendering Bug 
CELLSNET-45906Missing label in chart rendering Bug 
CELLSNET-45884Smart Art chart on tab - cones edges are jagged in the output PDF file formatBug 
CELLSNET-45989Dialogs not saving correctly in XLSM filesBug 
CELLSNET-45977Worksheet.Protect(ProtectionType.Objects) does not work for XLS filesBug 
CELLSNET-45946Hyperlink with hyphen in scheme breaks during saveBug 
CELLSNET-45944ConvertToRange() method breaks the Names in Name ManagerBug 
CELLSNET-45905Excel hangs when try to open the output workbook i.e. “_function plot 2D.xlsx” twiceBug 
CELLSNET-45904Excel hangs when try to open the output workbook twiceBug 
CELLSNET-45959Aspose.Cells.GridWeb culture date issueBug
CELLSNET-45929Column group does not work in GridWebBug 
CELLSNET-45926Tabs are not visible or partially visible on GridWeb in IE 11Bug 
CELLSNET-45925Offset issue in GridWeb worksheet on IE 11Bug 
” is embedded into the cell on cell change in Aspose.Cells.GridWeb
CELLSNET-45914Formula disappear after validating/updating the value in the cellBug 
CELLSNET-45912Error after validating a cell according to the validation methodBug 
CELLSNET-45894Controls do not work correctly probably because of loading two GridWebsBug 
CELLSNET-45987Exception on opening an XLSX file via Aspose.Cells APIsException 
CELLSNET-45951Invalid formula throws exception at startException 
CELLSNET-45950Exception when loading an ODS fileException 
CELLSNET-45947Exception: Invalid formula:“=sheet3!#ref!” when opening an XLSX fileException 
CELLSNET-45938System.IndexOutOfRangeException on opening XLSB filesException 
CELLSNET-45937System.FormatException occurs while opening XLSX fileException 
CELLSNET-45903Loading XLSX causes StackOverflowExceptionException 

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 HtmlSaveOptions.ExportSimilarBorderStyle property

Indicates whether exporting the similar border style when the border style is not supported by browsers. If you want to import the HTML or MHT file to Excel, please keep the default value. The default value is false.

Adds Axis.AxisLabels property

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

Adds new enum type: GridValidationType.CustomServerFunction

Represents custom server-side function validation.

Adds ChartType.Map enum

Represents the map chart.

Adds OleObject.Label property

Gets and sets the display label of the linked Ole Object.

Adds BuiltInDocumentPropertyCollection.DocumentVersion property

Represents the version of the file.

Adds StyleFlag.QuotePrefix enum

Indicates whether applying the style’s QuotePrefix property.

Adds DialogBox class

Represents the dialog box sheet.

Adds PdfSaveOptions.DrawObjectEventHandler property

Gets and sets DrawObjectEventHandler to get DrawObject and Bound while rendering.

Adds DrawObject.Shape property

Gets the related Shape while rendering.