Browse our Products

Aspose.Cells for .NET 5.1.0 Release Notes

We are happy to announce Aspose.Cells for .NET v!

What’s changed in Aspose.Cells:

  • Includes Smart Tags support for XLSX files. Converts Sparklines to images. Provides support for image Smart Markers. Supports Cell’s gradient fills and theme of XLS file. Renders Cell’s pattern fills in the generated PDF file.  Adds support for Pdf/A-1b compliance. Improves performance and quality of the generated PDF files. 46 enhancement and fixes.

What’s changed in Aspose.Cells.GridWeb:

  • Converts hierarchical custom collections to Dataset which contain relations.

1 fix.

What’s changed in Aspose.Cells.GridDesktop:

  • Includes Scroll event.

Provides an overloaded version for the SumSelectedRanges method to exclude hidden cells.

1 fix.

Issues Resolved in Aspose.Cells for .NET v

Issue IDComponentSummary
17474GridWebBorders are not rendered for the merged cells
15467GridDesktopChanges the duplicate worksheet’s name in ImportExcelFile method
17581Chart2ImageConverts chart to image
17762Chart2ImageData tables, Values and Category are lost for XY Scatter graphs
17900Chart2ImageExcel Chart to image problem
18023Chart2ImageBubble charts
18190Chart2ImageAspose.Cells throwing out of memory exceptions in Azure
18012CSVExport different to Excel’s
16207PdfFind error saving PDF File
17535PdfOne font in XLSX results in two fonts in PDF
17537PdfCurrency formatted blank cells
17776PdfIssue of converting Excel to PDF
17804PdfDecimal values are not displayed if only zeroes are there
17821PdfBuilt In Properties
17981PdfExcel to PDF Conversion Issue
18021PdfSaving to PDF - Troubles with font
18038PdfPDF document appears to be corrupted
18136PdfIssue of saving PDF
18258PdfCalculated formulas not updating on conversion from Cells to PDF
18316PdfConversion Issue with Data showing up as Number signs
18258PdfCalculated formulas not updating on conversion from Cells to PDF
18316PdfConversion Issue with Data showing up as Number signs
18239SpreadsheetMLInvalid end column index exception
17111Worksheet2ImageNot Properly Format Numeric data
17633Worksheet2ImageLine in graphics not converted
17903Worksheet2ImageThe performance of worksheet2image
18310Worksheet2ImageNo response from SheetRender
17656xlsHow to find grouped rows and columns
17761XlsCalculate external formulas
17789XlsConditional formatting formula
17810XlsMoving range behaves incorrect
17820XlsThis file was created using a later version
17907XlsSorting within groups does not work
17999XlsSupports adding Tif Image with Pictures.Add() method
18054XlsWorsheet.Copy is pegging CPU at 100%
18135XlsSupports PageLayoutView
18160XlsCompatibility Problem with MS Excel
18297XlsIncorrect Formula(Cell.formula and ExternalLink)
18366XlsSupports copying hyperlink in copying range.
16656XlsxLost macros when saving in XLSM-format
17041XlsxHow to set transparent color to a picture
17652XlsxHow to move the Command Button
17664XlsxExisting Conditional Formatting Changes
17719XlsxValue was either too large or too small for an Int16
17982XlsxPivot Table Page Fields not working in Excel 2007
18004XlsxSubtotals Issue
18036XlsxThe issue of opening XLSM file.
18161XlsxInvalid end column index exception with XLSX file
18356XlsxChart title with formula issue
Notable Changes for Existing Users

In this release (Aspose.Cells for .NET v5.1.0), we have renamed certain classes of Aspose.Cells component to clean the API Structure. We have some collection classes but their names do not justify them according to .NET standards. So, after deep analysis and reviews, we have decided to change some classes’ names. This change has some major aspects that we need to follow. Following is the list of classes that are renamed now.