Aspose.Cells for .NET 20.9 Release Notes
| Key | Summary | Category |
|---|---|---|
| CELLSNET-47567 | Support Get/Set the slicer shape properties | New Feature |
| CELLSNET-47549 | Client api for add /remove comments for GridWeb | New Feature |
| CELLSNET-47555 | Chart does not allow treating #N/A as empty cells when saving as PDF | Enhancement |
| CELLSNET-47579 | Kaiti font is not properly rendered | Enhancement |
| CELLSNET-47154 | Query tables are not loaded from ODS file | Enhancement |
| CELLSNET-47556 | Enhancement for freezing and splitting worksheet | Enhancement |
| CELLSNET-47570 | Macros should removed when combining/copying workbooks | Enhancement |
| CELLSNET-47543 | Issue with Smart Markers having conditional formatting applied | Bug |
| CELLSNET-47561 | Currency with custom format is shown outside of cell in HTML | Bug |
| CELLSNET-47562 | Saving empty sheet with exported grid lines settings to HTML | Bug |
| CELLSNET-47569 | Pivot Table isn’t properly shown after XLSX to PDF conversion | Bug |
| CELLSNET-47475 | CalculateFormula() calculates differently than MS Excel | Bug |
| CELLSNET-47531 | Formulas containing names that don’t exist show up as WorkbookName!Name |
Bug |
| CELLSNET-47545 | Custom negative number rendered incorrectly to PDF | Bug |
| CELLSNET-47548 | Issue with importing text file with double quotes | Bug |
| CELLSNET-47558 | Custom negative numbers (using Switzerland region) rendered incorrectly to PDF | Bug |
| CELLSNET-47075 | Need to sync scrolling of two grids just like excel’s SyncScrollingSideBySide. | Bug |
| CELLSNET-47559 | Unable to select cells using keyboard arrow keys when sheet set as readonly | Bug |
| CELLSNET-47360 | Transparent marker points in chart in the Excel file are getting distorted in the output PDF | Bug |
| CELLSNET-47565 | Foreground footer image becomes background | Bug |
| CELLSNET-46502 | XLSX to TIFF conversion results in a black box | Bug |
| CELLSNET-46821 | Converting worksheet to TIFF - Image is blacked out | Bug |
| CELLSNET-47458 | Shape distortion after conversion to PDF file | Bug |
| CELLSNET-47551 | X-axis not correct while converting Excel chart to PDF | Bug |
| CELLSNET-47546 | Delete blank rows/columns corrupts Excel document | Bug |
| CELLSNET-47552 | Wrong PowerQueryFormula.FormulaDefinition | Bug |
| CELLSNET-47573 | Unable to produce desired formatting using shift | Bug |
| CELLSNET-47574 | XLS to HTML produces empty file | Bug |
| CELLSNET-47581 | MaxColumn is set to Column XFD after calling InsertCutCells() | Bug |
| CELLSNET-47586 | Workbook with Waterfall chart cannot be opened using Excel 2016 after copy | Bug |
| CELLSNET-47547 | Exception raised while adding slicer for table | Exception |
| CELLSNET-47553 | Exception when saving an XLS file to XLSX | Exception |
| CELLSNET-47563 | Exception “File is corrupted” when loading an XLS file format | Exception |
| CELLSNET-47580 | ArgumentOutOfRangeException when converting excel | Exception |
| CELLSNET-47592 | Exception when converting particular XLSX to XLS | Exception |
| CELLSNET-47557 | Some properties are missing when combining workbooks | Regression |
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 AbstractCalculationEngine.ProcessBuiltInFunctions property
For performance and user’s convenience consideration, we added this property and made its default value as false so user can concentrate on those functions that have not been supported by built-in engine. If user’s existing implementation of AbstractCalculationEngine changed some built-in functions' calculation, user should override this property to make it as true from 20.9.
Adds TxtLoadOptions.HasTextQualifier property
Denotes whether there is text qualifier for cell values in the template file.
Adds TxtLoadOptions.TextQualifier property
Specifies the text qualifier for cell values in the template file.
Adds HtmlSaveOptions.ImageScalable property
Indicates whether to use scalable unit to describe the image width. The default value of the property is true.
Adds Slicer.AlternativeText property
Gets or sets the descriptive (alternative) text string of the Slicer object.
Adds Slicer.ColumnWidthPixel property
Gets or sets the width in unit of pixels for each column of the slicer.
Adds Slicer.HeightPixel property
Gets or sets the height of the specified slicer, in pixels.
Adds Slicer.IsLocked property
Indicates whether the slicer shape is locked.
Adds Slicer.IsPrintable property
Indicates whether the slicer object is printable.
Adds Slicer.LeftPixel property
Gets or sets the horizontal offset of slicer shape from its left column, in pixels.
Adds Slicer.LockedAspectRatio property
Indicates whether locking aspect ratio.
Adds Slicer.Placement property
Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet.
Adds Slicer.RowHeightPixel property
Returns or sets the height, in pixels, of each row in the specified slicer.
Adds Slicer.Title property
Specifies the title of the current Slicer object.
Adds Slicer.TopPixel property
Gets or sets the vertical offset of slicer shape from its top row, in pixels.
Adds Slicer.WidthPixel property
Gets or sets the width of the specified slicer, in pixels.
Adds Worksheet.PaneState property and PaneStateType enum.
Represents the state of pane in the worksheet.
Adds OdsLoadOptions.RefreshPivotTables property.
Indicates whether refreshing pivot table when loading .ods files.
Adds FilterColumn.IsDropdownVisible property.
Indicates whether the AutoFilter button for this column is visible.
Obsoletes Filter.Visibledropdown property.
Use FilterColumn.IsDropdownVisible instead.
Adds CopyOptions.KeepMacros property.
Indicates whether keeping the macors in the target workbook. It only effects when original workbook does not contains macros.
Adds overload Workbook.Copy(Workbook,CopyOptions) method.
Copies workbook with options.
Adds WarningType.InvalidAutoFilterRange enum.
Represents the warning type that the range could not autofiltered.
Adds Chart.DisplayNaAsBlank property.
Indicates whether displaying #N/A as blank value.
Adds CrossType.Minimum enum.
Represents the axises cross at the minimum value.
Adds XlsbSaveOptions.ExportAllColumnIndexes property.
Indicates whether exporting column indexes for all cells.