Aspose.Cells for .NET 18.9 Release Notes

CELLSNET-42992Applying text alignment to partial text inside the TextBoxNew Feature 
CELLSNET-46308Export custom document properties to PDF  New Feature 
CELLSNET-46301Get XML path from List Object/TableNew Feature 
CELLSNET-46315Support stock chart in ODS file New Feature 
CELLSNET-46304Add Row.FirstDataCell property to retrieve the first data cell in the rowEnhancement 
CELLSNET-46298Create safe sheet names similar to Apache POIEnhancement 
CELLSNET-46319FilterOperatorType.Contains missing from APIEnhancement 
CELLSNET-46297Retrieve range of Query TableEnhancement 
CELLSNET-46294Name worksheet same as source file name while converting CSV/TSV to SpreadsheetEnhancement 
CELLSNET-46289Include unsigned Dlls of Aspose.CellsEnhancement 
CELLSNET-46290Wrong colors rendered for shapes in Excel to PDF conversionBug 
CELLSNET-46282Quite small images rendered in PDFBug 
CELLSNET-46328Broken hyperlink in HTMLBug 
CELLSNET-46322Issues in number and date values while calling the AutoFitColumns()Bug 
CELLSNET-46312Pivot tables not working after load and saveBug 
CELLSNET-46291Issues in Pivot tables while refreshing and hiding pivot itemsBug 
CELLSNET-46279PivotTable.RefreshData throws ‘Index out of range’ exceptionBug 
CELLSNET-46303Formula not calculated properlyBug 
CELLSNET-46327Named ranges when converted into SVG, not capturing the exact fonts and spacingBug 
CELLSNET-46313Issues in output PDF when using German keywords in scripting headers and footersBug 
CELLSNET-46300Table/List Object overlapped the data below the table when importing xml data into the spreadsheetBug 
CELLSNET-46318Vertical gridlines appeared in the chart after calling Chart.Calculate() methodBug 
CELLSNET-46287Horizontal axis is missing in rendered images from Excel chartBug 
CELLSNET-46286Issue while setting rotation angle of category axisBug 
CELLSNET-46333Application GUID is changedBug 
CELLSNET-46332Storages and streams missing from OLE Package after re-saving an encrypted XLSX fileBug 
CELLSNET-46325Graphs lost while copying worksheet from one workbook to anotherBug 
CELLSNET-46316Conditional formatting is applied without font and shading colors when merging workbooksBug 
CELLSNET-46305Text out of print area rendered in PDFBug 
CELLSNET-46296Autofit columns or rows disturbing the grouped shapesBug 
CELLSNET-46292Difference in XML filesBug 
CELLSNET-46283Missing border in ODS Excel outputBug 
CELLSNET-46331Exception when converting an XLSX file to PDF file formatException 
CELLSNET-46270ArgumentOutOfRangeException raised while calling Slicer.Refresh()Exception 
CELLSNET-46323Data validation issue when trying to change cell value with one of the dropdown valueException 
CELLSNET-46307Exception when retrieving the url of the list object’s xml data binding mapException 
CELLSNET-46336System.OverflowException raised while calling Chart.CalculateException 
CELLSNET-46293Exception while saving the documentException 

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 CellsHelper.CreateSafeSheetName(string nameProposal)/CreateSafeSheetName(string nameProposal, char replaceChar) methods

Methods for user’s convenience to create valid sheet name.

Adds Row.FirstDataCell

Gets the first non-blank cell in the row.

Adds MapChartLabelLayout enum

Represents the label layout type of the map chart.

Adds MapChartProjectionType enum

Represents the projection type of the map chart.

Adds MapChartRegionType enum

Represents the region type of the map chart.

Adds QuartileCalculationType enum

Represents the quartile calculation type of the chart.

Adds Series.LayoutProperties property and class SeriesLayoutProperties

Represents the layout properties of the series.

Adds TickLabels.IsAutomaticRotation property

Indicates whether the rotation of the tick labels is automatic.

Adds FilterOperatorType.BeginsWith, Contains, EndsWith and NotContains enum

Represents the text filter operator type.

Adds Cell.GetDisplayStyle(bool) method

Gets the display style of the cell.

Adds GlobalizationSettings.GetStandardHeaderFooterFontStyleName(string localFontStyleName) method

Gets standard English font style name (Regular, Bold, Italic) for Header/Footer according to given locale font style name.

Adds PdfCustomPropertiesExport enum

Specifies the way CustomDocumentPropertyCollection are exported to PDF file.

Adds PdfSaveOptions.CustomPropertiesExport property

Gets or sets a value determining the way CustomDocumentPropertyCollection are exported to PDF file. Default value is None.

Adds class XmlDataBinding

Represents Xml Data Binding information.

Adds ListObject.XmlMap property

Gets an XmlMap used for this list.

Adds XmlDataBinding.Url property

Gets source url of this data binding.

Adds XmlMap.DataBinding property

Gets an XmlDataBinding of this map.