Aspose.Cells for .NET 8.4.0 Release Notes

\1) Aspose.Cells

Other Improvements and Changes

New Features

(CELLSNET-43362) - Support to delete a PivotTable from Worksheet

(CELLSNET-43279) - Content Type Properties are not shown in XLS format

(CELLSNET-43276) - Workbook.ContentTypeProperties.Add(name, value, type) is needed

Enhancements

(CELLSNET-43368) - Customizing the generation of CSS while saving Excel to HTML

(CELLSNET-43361) - Cannot retain the Cell’s Number Format after ImportTwoDimensionArray

(CELLSNET-43454) - Aspose.Pdf does not validate output PDF/A-1B

(CELLSNET-43452) - PDFA1B compliance of the output PDF was not validated

(CELLSNET-42646) - Workbook RefreshChartCache works with regional and language settings

(CELLSNET-43408) - The whole workbook will have the text bold

(CELLSNET-43357) - Excel found unreadable content after setting up password

Performance

(CELLSNET-43438) - Spreadsheet to HTML generates a 1GB HTML file

(CELLSNET-43399) - Performance issue with CalculateFormula() method

Bugs

(CELLSNET-43460) - Background-color: rgba(0, 0, 0, 0); makes the background color black

(CELLSNET-43403) - First column disappears when second Pivot

(CELLSNET-43390) - Data in Static Pivot Tables is Re-arranged

(CELLSNET-43369) - Pivot Tables always label first column as ‘Row Labels’

(CELLSNET-43358) - Specifying the BaseItemPosition attribute produces an invalid file

(CELLSNET-43354) - PivotTable calculation issue: cell value is truncated

(CELLSNET-43337) - PivotTable.RefreshData corrupting content

(CELLSNET-43331) - Excel file becomes corrupted after creating pivot table

(CELLSNET-43328) - Position of images is wrong in the output PDF

(CELLSNET-43322) - Buttons appeared in the PivotChart when the file is re-saved

(CELLSNET-42919) - “Excel found unreadable…” error after refreshing Pivot Data

(CELLSNET-43451) - Alignment issue while rendering the worksheet to image

(CELLSNET-43414) - Gap between the header and the body is different

(CELLSNET-43411) - Newer version could not accept less than 96dpi

(CELLSNET-43410) - Incorrect spacing with each Environment.NewLine in output PDF

(CELLSNET-43348) - FitToPagesTall and FitToPagesWide attribute not working as expected

(CELLSNET-43385) - Incorrect rendering of the Chart Title while converting Chart to Image

(CELLSNET-43378) - Incorrect rendering of the Chart Title while converting Chart to Image

(CELLSNET-43375) - Chart Title is incorrectly rendered while converting Chart to Image

(CELLSNET-43352) - PDF size doubles when it is converted from XLSX

(CELLSNET-43351) - Chart Legend issue while converting XLSX to PDF

(CELLSNET-43350) - Chart Axis issue while converting XLSX to PDF

(CELLSNET-43349) - Graphic Issue while converting XLSX to PDF

(CELLSNET-43347) - Chart’s Series Shadow does not copy while copying the Workbook

(CELLSNET-43339) - Charts are not rendered properly in the output PDF

(CELLSNET-42573) - Pie chart labels are overlapping

(CELLSNET-42558) - Labels overlapping when rendering the pie chart

(CELLSNET-41725) - Pie Chart Data Labels overlapped

(CELLSNET-41001) - Issue with OLE Pie charts Data Labels / Leader Lines

(CELLSNET-43466) - Problem with Array formula

(CELLSNET-43463) - Cell values are replaced by values from other cells

(CELLSNET-43456) - Font color of WordArt changes after loading and saving xls

(CELLSNET-43441) - Conversion from XLSX to XLSB produce corrupted spreadsheet

(CELLSNET-43434) - Embedded Docm or Dotx in xls cannot be opened

(CELLSNET-43432) - Smart Markers stops merging data after X number of rows

(CELLSNET-43426) - Combining worksheets breaks apostrophe

(CELLSNET-43424) - Lookup formula is not calculated correctly

(CELLSNET-43423) - PageSetup.IsHFAlignMargins gets automatically true in the output Excel file

(CELLSNET-43419) - Hyperlinks without subaddresses are lost

(CELLSNET-43407) - Conditional Formatting - Cells should not have Red background

(CELLSNET-43401) - “Invalid data format” error after manipulating VBA codes

(CELLSNET-43398) - Updated formula not saving when it contains an external reference

(CELLSNET-43396) - Error occured with images in the template file

(CELLSNET-43363) - Formula value is not calculated correctly by Workbook.CalculateFormula

(CELLSNET-43355) - Spreadsheet built-in document property ‘Version’ inconsistency

(CELLSNET-43346) - Format of the Hyperlink changes while copying the range

(CELLSNET-43338) - Inserting columns in a table causes the unreadable warning

(CELLSNET-43336) - Issue with rendering conditional formatting - Excel to HTML

(CELLSNET-43335) - Issue with rendering conditional formatting - Excel to PDF

(CELLSNET-43333) - Insert Rows parameter is not working fine in Cells.ImportDataReader() method

(CELLSNET-43293) - Removing Border does not work in the output Excel file

Exceptions

(CELLSNET-43459) - Background-color: rgba(255, 255, 255, 0.1); throws an exception.

(CELLSNET-43442) - RGBA element inside of TD throws exception

(CELLSNET-43406) - System.IndexOutOfRangeException at PivotTable.CalculateData

(CELLSNET-43373) - PivotTable.RefreshData throws an exception

(CELLSNET-43320) - Null reference exception while saving as html

(CELLSNET-43314) - Exception thrown while opening an XLS file

(CELLSNET-43312) - Index was out of range exception on refreshing pivot table

(CELLSNET-43393) - Index out of bound exception on Cell.PutValue

(CELLSNET-43427) - System.OverflowException on opening the Excel file

(CELLSNET-43356) - Format error occurs when regional setting is set to French

(CELLSNET-43353) - System.NullReferenceException at Workbook.Combine

\2) Aspose.Cells Grid Suite

Other Improvements and Changes

Bugs

(CELLSNET-43437) - WebCells.SetRowCaption() is missing

(CELLSNET-43435) - Issue with Grid’s background color - GridWeb

(CELLSNET-43430) - Alignment of the GridWeb Rows is not correct

(CELLSNET-43429) - Chart is not refreshed when new Excel file is loaded

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.ExportBogusRowData attribute

Indicates whether exporting bogus bottom row data. the default value is true.

Adds HtmlSaveOptions.CellCssPrefix attribute

Gets and sets the prefix of the css name,the default value is “”.

Adds PivotTable.ShowInCompactForm() method

Layouts the PivotTable in compact form.

Adds PivotTable.ShowInOutlineForm() method

Layouts the PivotTable in outline form.

Adds PivotTable.ShowInTabularForm() method

Layouts the PivotTable in tabular form.

Adds PivotTableCollection.Remove(PivotTable pivotTable) method

Deletes the specified PivotTable

Adds PivotTableCollection.RemoveAt(int index) method.

Deletes the PivotTable at the specified index

Adds Aspose.Cells.Vba namespace, VbaPorject, VbaModuleCollection and VbaModule classes.

They are used to read and modify the VBA project in the file.

Adds Border.ThemeColor property.

Gets and sets the theme color of the border.

Adds TxtLoadStyleStrategy class and TxtLoadOptions.LoadStyleStrategy property.

Indicates the strategy to apply style for parsed values when converting string value to number or datetime.

Obsoletes TxtLoadOptions.KeepExactFormat methods.

Please use TxtLoadOptions.LoadStyleStrategy property instead.

Obsoletes Cells.GetCellByIndex() and Row.GetCellByIndex() methods.

Please use GetEnumerator() method to iterate all cells instead.

Obsoletes DrawObject.Image property

Please use DrawObject.ImageBytes property to get image data instead.

Adds DrawObject.ImageBytes property

Gets the bytes of image which is converted from Chart or Shape.