Aspose.Cells for .NET 6.0.0 Release Notes

We are pleased to announce Aspose.Cells for .NET v6.0.0 for the users!

\1) Aspose.Cells

New Features

13872 Export to XPS file

28363 Create write-protected XLSX files

Enhancements

27285 Show expand/collapse buttons for Pivot Table

27781 Chart’s legend is shrinking when Excel workbook is saved

27794 Excel Chart Data Labels are moving when Excel file is saved

28190 Apply Date format to Nullable date fields

26884 Lost sorting for a column after Save

27760 Support Table source as named ranges

27955 Specify Dynamic Print Area while printing or rendering to PDF

Performance

28139 Excel to PDF performance issue

27095 Problem with Workbook.CalculateFormula() method

27348 The process is hangs when opening a file which contains shapes

27367 Opening an XLSX file is slow

Exceptions

28221 Opening Workbook Causes Exception

27382 Broken picture causes Aspose.Cells to crash

27998 Exception thrown when opening legitimate XLSX file

28318 An exception occurred when saving an XLS workbook in XLSM format

Bugs

27472 Fail to evaluate some Excel formulas/functions

27820 Invalid formula obtained if table’s column title contains simple quotes

27950 Not calculating the array formulas properly

28070 Workbook.CalculateFormula() is not calculating correctly

28230 Bug with evaluating Convert function

28399 ROUND function gives value other than MS Excel

28369 Special Characters in the formula

28024 Get Named Ranges and Tables

18503 Diagonal Lines are not showing correctly in PDF

27168 Grouped shapes are distorted when saving to PDF

27240 Excel to PDF Conversion - Chart Ranges Issue

28112 Saving Excel (XLS) file as PDF results in an issue

27061 Protected view warning in MS Excel 2010

27956 Set an existing tables data source to named range(s)

28045 Pivot Table corrupted after updating source data sheet

27687 Borders missing on the right and bottom of image in Sheet to Image feature

27951 Bullets missing in the exported image in Sheet to Image feature

28413 Column’s format in TIFF Conversion is not correct

27906 Escape character in Smart Markers

27342 An issue of opening SpreadsheetML file

28269 AutoRow height issue while creating rows that exceed maximum height

26941 AutoFilter issue between XLS and XLSX files

28036 Problem with cell formatting in generated file

28046 Formulas are not refreshing properly

\2) Aspose.Cells.GridWeb

Enhancements

26523 Load data asynchronously

27835 Support IE9 without using compatibility mode

28145 Issues on Google Chrome browser

26368 Unable to locate a cell by clicking on a hyperlink

27799 Setting ShowDefaultGridLine = false is not available when GridWeb’s XhtmlMode is set to “true”

\3) Aspose.Cells.GridDesktop

New Features

27280 Set background image for a cell’s Button control