Aspose.Cells for .NET 5.1.3 Release Notes

We are happy to announce Aspose.Cells for .NET v5.1.3!

What’s changed in Aspose.Cells:

  • Enhances the performance of saving PDF files.
  • 39 enhancements and fixes.

What’s changed in Aspose.Cells.GridWeb:

  • Supports clicking column header to select entire column, clicking top-left corner to select entire sheet’s cells similar to MS Excel’s behavior.
  • Provides support for iterative calculations.
  • Supports named ranges.
  • Allows obtaining data field name at client side.
  • Includes printing feature at client side.
  • Adds valuable functions to the supported formulas list: CELL, ERROR.TYPE, ISBLANK, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISTEXT, ISREF, N, NA, TYPE, COUNTBLANK, LARGE, MAXA, MINA, AVERAGEA, MODE, PERCENTILE, PERCENTRANK, RANK, CHOOSE, HLOOKUP, VLOOKUP.
  • 5 fixes and 1 enhancement.

What’s changed in Aspose.Cells.GridDesktop:

  • Allows undoing changes by code.
  • Supports undoing changes of comments.
  • Provides support to set visibilities of comments.
  • Supports to set indent (style) while formatting cells.
  • Imports or exports pictures of Excel files.
  • Adds valuable functions to the supported formulas list: ERROR.TYPE, ISBLANK, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISTEXT, ISREF, N, NA, TYPE, COUNTBLANK, LARGE, MAXA, MINA, AVERAGEA, MODE, PERCENTILE, PERCENTRANK, RANK, CHOOSE, HLOOKUP, OFFSET, INDIRECT.
  • 3 fixes.

Issues Resolved in Aspose.Cells for .NET v5.1.3.

Issue IDComponentSummary
19532GridWebEntered percent values are treated as string value.
19584GridWebWebWorksheets.AddCopy() misses copying formulas.
19622GridWebEnable to copy a WebWorksheet object from specified GridWeb control.
19656GridWebGridWeb control is rendered very tall in Visual Studio 2010.
19692GridWebA StackOverflowException will be raised
19849GridWebSerialization issue.
19246GridDesktopCells data format issue - Dates turn into numbers
19336GridDesktopAn exception is raised when merging 0 rows or 0 columns range.
19411GridDesktopVLOOKUP function does not support using double or int value
19721HtmlSaving Excel document as HTML takes very long
17485PdfMissing Logo and Fuzzy / Light Text
18114PdfPDF Conversion problem
19237PdfDifference in printing from Excel and Outputting to PDF
19392PdfImage width shrunk in conversion to PDF
19409PdfPDF look and feel differs from XLSX
19420PdfDate format
19425PdfFilesize = 0 when converted to PDF
19546PdfConvert this file to PDF
19651PdfExcel File cannot be converted to PDF due to Invalid pdf format error
19873PdfText comes out of table and fails to print completely
19430PivotTable2003 XLS with PivotTables corrupted
19542PivotTableDataBordyRange is not returning correct area
19852PivotTablePivot table causes errors in XLSX files but works fine in XLS
19942SpreadMLSpreadsheetML document opening issue with namespace attributes
19052XlsCopy Excel having Command button event handler
19238XlsgetPrecedents returns a column 164
19541XlsError on Named Range Array Formula
19586XlsProblems of save table as Excel97to2003
19587XlsExcel document with grouped images issue
19740XlsLoadOptions. ConvertNumericData
19895XlsIssue with Passwords and Excel 2003
19901XlsINDEX AND LOOKUP FORMULAS issue in GridWeb.
19911XlsLosing individual data point label formats
19931XlsProblem in adding Hyperlink to Cell
19934XlsImportTwoDimensionArray seems to invalidate some cells
19250XlsxExcel Found unreadable content error dialog
19334XlsxCannot open Excel workbook containing chart
19341XlsxProblems with worksheets with comma character
19325XlsxExact format of excel cell data not captured
19536XlsxLock cells not working
19544XlsxScroll bar issue
19585XlsxExcel found unreadable content in ‘file.xlsx’
19625XlsxError opening workbook
19722XlsxSparklines issue – Office 2010
19737XlsxExtracting values as a result of formula, the values come out wrong
19754XlsxIt gives error (Object reference not set to an instance) when I’m loading this simple Excel 2007 file
19764XlsxUnable to change cell borders