Aspose.Cells for .NET 5.1.3 Release Notes
Contents
[
Hide
]
This page contains release notes for Aspose.Cells for .NET 5.1.3
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 ID | Component | Summary |
|---|---|---|
| 19532 | GridWeb | Entered percent values are treated as string value. |
| 19584 | GridWeb | WebWorksheets.AddCopy() misses copying formulas. |
| 19622 | GridWeb | Enable to copy a WebWorksheet object from specified GridWeb control. |
| 19656 | GridWeb | GridWeb control is rendered very tall in Visual Studio 2010. |
| 19692 | GridWeb | A StackOverflowException will be raised |
| 19849 | GridWeb | Serialization issue. |
| 19246 | GridDesktop | Cells data format issue - Dates turn into numbers |
| 19336 | GridDesktop | An exception is raised when merging 0 rows or 0 columns range. |
| 19411 | GridDesktop | VLOOKUP function does not support using double or int value |
| 19721 | Html | Saving Excel document as HTML takes very long |
| 17485 | Missing Logo and Fuzzy / Light Text | |
| 18114 | PDF Conversion problem | |
| 19237 | Difference in printing from Excel and Outputting to PDF | |
| 19392 | Image width shrunk in conversion to PDF | |
| 19409 | PDF look and feel differs from XLSX | |
| 19420 | Date format | |
| 19425 | Filesize = 0 when converted to PDF | |
| 19546 | Convert this file to PDF | |
| 19651 | Excel File cannot be converted to PDF due to Invalid pdf format error | |
| 19873 | Text comes out of table and fails to print completely | |
| 19430 | PivotTable | 2003 XLS with PivotTables corrupted |
| 19542 | PivotTable | DataBordyRange is not returning correct area |
| 19852 | PivotTable | Pivot table causes errors in XLSX files but works fine in XLS |
| 19942 | SpreadML | SpreadsheetML document opening issue with namespace attributes |
| 19052 | Xls | Copy Excel having Command button event handler |
| 19238 | Xls | getPrecedents returns a column 164 |
| 19541 | Xls | Error on Named Range Array Formula |
| 19586 | Xls | Problems of save table as Excel97to2003 |
| 19587 | Xls | Excel document with grouped images issue |
| 19740 | Xls | LoadOptions. ConvertNumericData |
| 19895 | Xls | Issue with Passwords and Excel 2003 |
| 19901 | Xls | INDEX AND LOOKUP FORMULAS issue in GridWeb. |
| 19911 | Xls | Losing individual data point label formats |
| 19931 | Xls | Problem in adding Hyperlink to Cell |
| 19934 | Xls | ImportTwoDimensionArray seems to invalidate some cells |
| 19250 | Xlsx | Excel Found unreadable content error dialog |
| 19334 | Xlsx | Cannot open Excel workbook containing chart |
| 19341 | Xlsx | Problems with worksheets with comma character |
| 19325 | Xlsx | Exact format of excel cell data not captured |
| 19536 | Xlsx | Lock cells not working |
| 19544 | Xlsx | Scroll bar issue |
| 19585 | Xlsx | Excel found unreadable content in ‘file.xlsx’ |
| 19625 | Xlsx | Error opening workbook |
| 19722 | Xlsx | Sparklines issue – Office 2010 |
| 19737 | Xlsx | Extracting values as a result of formula, the values come out wrong |
| 19754 | Xlsx | It gives error (Object reference not set to an instance) when I’m loading this simple Excel 2007 file |
| 19764 | Xlsx | Unable to change cell borders |