Aspose.Cells for .NET 17.7 Release Notes

KeySummaryCategory
CELLSNET-45437Support errors and Boolean value in Russian locale in Excel to PDF renderingNew Feature 
CELLSNET-45456Reading cells’ data, formula and style from numbers file New Feature 
CELLSNET-45483Support to change the row index start value to 0 (instead of 1) in Aspose.Cells.GridDesktopNew Feature 
CELLSNET-45434GridWeb ViewPanel is not always VisibleNew Feature 
CELLSNET-45224Render PivotTable in GridDesktopNew Feature 
CELLSNET-45490Throw error or exception when wrong name is assigned to ListObject.DisplayName propertyEnhancement 
CELLSNET-45470Link Source DataSource vs. OriginalDataSource vs. Excel=>Data => Edit linksEnhancement 
CELLSNET-45439GridDesktop.GetVersion() method needed to check the version number of GridDesktop on runtimeEnhancement 
CELLSNET-45457Application gets stuck while trying to get picture’s propertyPerformance
CELLSNET-45388Arrow shape is not rendered fine in Sheet to Image (.jpg) renderingsBug 
CELLSNET-45426Chart data is unable to refresh data from Pivot TableBug 
CELLSNET-45447Excel file corrupted when adding PivotTable after importing source dataBug 
CELLSNET-45396Formatting error when Excel file is converted to HTMLBug 
CELLSNET-45402Cell.DisplayStringValue does not match with the original valuesBug 
CELLSNET-45479Aspose.Cells 17.5 - Incorrect Digital signing with DSA certificateBug 
CELLSNET-45420DefaultFont setting not workingBug 
CELLSNET-45364Some shapes/objects are cut in the output PDFBug 
CELLSNET-45491Some black blur thing attached to the data labels appeared in the output image of the chartBug 
CELLSNET-45476The date format of the X-axis labels are changed and overridden on Legend entriesBug 
CELLSNET-45471Text “III.LowerQualityAboveSML” on 2nd page of PDF is brokenBug 
CELLSNET-45454Bubble colors are changed a bit for different charts even using the same lines of codeBug 
CELLSNET-45452Sparklines are not rendered correctly in the output PDFBug 
CELLSNET-45493Resizing the ListObject do not get custom formatting carried acrossBug 
CELLSNET-45482Some shapes are lost in XLS file when extracting and re-inserting imagesBug 
CELLSNET-45466Some additional borders are automatically getting addedBug 
CELLSNET-45464Axis type of the chart is changed after Workbook.Combine()Bug 
CELLSNET-45463Row heights and chart sizes become smaller when using Workbook.Combine() methodBug 
CELLSNET-45462Wrong paper size value is returned when worksheet doesn’t have PageSetup settingsBugs
CELLSNET-45453Formatting of the worksheet changed after Workbook.Combine()Bug 
CELLSNET-45428Cells.DeleteBlankRows/DeleteBlankColumns removes the charts in the worksheetBug 
CELLSNET-45488The GridWeb does not display all rows and encounters an errorBug 
CELLSNET-45438Rotating text of cell to 90 degree spoils the text alignment of the cellBug 
CELLSNET-45425GridWeb adds space to Excel dropdown entryBug 
CELLSNET-42363Issue with pivot fields’ captions in PivotTable (GridWeb)Bug 
CELLSNET-45486NullReferenceException occurred when saving Excel workbook (having merged cells) to HTML file formatException 
CELLSNET-45478Exception on opening a corrupted MHTML file via Aspose.Cells APIsException 
CELLSNET-45467‘System.ArgumentOutOfRangeException’ occurred when loading an MHTML fileException 
CELLSNET-45485Exception occurred when calculating a valid formulaException 
CELLSNET-45433Exception occurs on opening fd1507a97b7f40fb85f9725535ecd215.xlsbException 
CELLSNET-45432Exception occurs on opening 0c29bc12429844fe983c2a152fa9b744.xlsbException 
CELLSNET-45431Exception occurs on opening 000bc1ec5fda4528a18f267f4dfe4a98.xlsbException 
CELLSNET-45430Exception occurs on opening failed_to_saved_in_xlsb_type.xlsxException 

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 GlobalizationSettings.GetBooleanValueString()/GetErrorValueString() methods

Gets custom display string value for cell’s Boolean and error value when formatting/rendering.

Removes obsoleted ValidationCollection.Add() method

Use ValidationCollection.Add(CellArea) method instead.

Adds PdfSaveOptions.CheckWorkbookDefaultFont property

Indicates whether to try to use workbook’s default font firstly to show the characters which font is not set correctly.

Adds ImageOrPrintOptions.CheckWorkbookDefaultFont property

Indicates whether to try to use workbook’s default font firstly to show the characters which font is not set correctly.

Adds FileFormatType.Numbers, LoadFormat.Numbers and SaveFormat.Numbers enum

Represents the Numbers spreadsheet file format by Apple Inc/.

Adds Worksheet.AdvancedFilter() method

Filters data using complex criteria.

Adds WorkbookSettings.SignificantDigits property

Gets and sets the number of significant digits.

Obsoletes Validation.AreaList property and adds Validation.Areas property

Gets all area which contains the data validation settings.

Adds PageSetup.IsAutomaticPaperSize property

Indicates whether the paper size is automatic.

Adds FontSettingCollection.Replace() method

Replaces the text of the shape.

Adds Cells.importResultSet(ResultSet rs, int rowIndex, int columnIndex, ImportTableOptions options)/Cells.importResultSet(ResultSet rs, String startCell, ImportTableOptions options) (for Java only)

Supports importing ResultSet with more options.

Adds GridWorksheet.CustomColumnCaption property

Gets or sets the custom column caption for the worksheet - Aspose.Cells.GridDesktop.

Adds GridWorksheet.CustomRowCaption property

Gets or sets the custom row caption for the worksheet - Aspose.Cells.GridDesktop.

Adds GridDesktop.GetVersion() method

Get the release version.

Adds GridWebInstance.resize() function in GridWeb client js,(GridWebInstance is the GridWeb control object)

Makes the GridWeb control to be compatible with current browser window size.

Usage Examples

Please check the list of help topics added in the Aspose.Cells Wiki docs: