Aspose.Cells for .NET V24.6

Released: Jun 14, 2024

Updates in V24.6

Features

  • Added color saturation and color temperature adjustment functions for images.
  • Image Recoloring: Added the ability to render duotones.
  • Added support for outlining the star characters in chart.
  • Added support for Range.ToHtml() method.
  • Added support for aligning axis x values to the right when converting chart to image.
  • Added support for converting workbooks containing Webp images to PDF and image for .NET 6.0, 7.0 and 8.0 on Linux.
  • Added support for Range.ToImage() method.
  • Enhanced merging range of pivot table.
  • Enhanced "Show Values as" of pivot field.
  • You can now handle the "Index was out of range" exception when reading template file which contains invalid data.
  • You can now handle the "Destination array is not long enough" exception when reading template file which contains invalid data.

Fixes

  • Asian multi-line text break issue for shapes when rendering Excel file to PDF.
  • Some hyperlinks for SmartArts are no longer available in the output PDF.
  • Image Recoloring: Fix rendering failure after setting grayscale and black and white coloring.
  • Fixed algorithm error in code regarding 'satMod'.
  • The added scroll bar object is not visible.
  • Data loss occurs when converting a chart to an image.
  • Saving workbook is treating chart titles as All caps by default instead of None.
  • Further optimize the data label location for the combined chart.
  • Last bar in Bar-Chart is not displaying when converting file to PDF.
  • Vertical line in chart is misaligned in the output SVG.
  • Incorrect chart representation when converting XLSX to PDF.
  • Iconset conditional formatting is covered by numbers when rendering sheet to image.
  • Save Excel to PDF cause Picture changed to other Picture.
  • XLSX to PDF: Pagination different than in MS Excel.
  • Preserving hyperlink function not working when converting Excel file to PDF.
  • Punctuation symbol display error when converting file to PDF.
  • Justified text is further left than left aligned text in PDF, but not in Excel.
  • Image format messed up after converting to PDF.
  • The bold font becomes normal when converting HTML to XLSX.
  • Issue with hyperlink in cell.
  • Some letters in the cell not visible even after using Worksheet.AutoFitColumns when rendering worksheet to HTML.
  • The HtmlSaveOptions.AddTooltipText and HtmlSaveOptions.FormatDataIgnoreColumnWidth properties are invalid when saving file to HTML.
  • The position and order of notes are incorrect when converting file to HTML.
  • Improve layout of pivot table contains pivot calculate items.
  • Support Converting range to JSON.
  • Convert pivot table which data is consolidation from XLSX to XLS.
  • Corrupted XLSX file was generated when pivot calculated item refers to a numberic label.
  • Row data hiding error when filtering blanks.
  • Lost time value when reading xlsb which contains time pivot fields.
  • Cells.UnMerge() unmerged more rows than the specified range.
  • Notes formatting is lost when copying worksheet.
  • Properties from Custom XML part are added as custom properties while saving XLSM to XLS.
  • Font color of "notes" or "comments" changed to white when copying selective data from Excel workbook to other workbooks.
  • Repair corrupted file which defined names' text is greater than limitation.
  • OleObject.ObjectSourceFullName is null for an embedded image in the worksheet.
  • Obtain incorrect value when calling the NeedQuoteInFormula method.
  • Generated XLS file is corrupted when we try to add long hyperlinks.
  • Generated XLSX file is corrupted when embedding an XLSX file.
  • Copied slicer Shape to image Error.
  • Worksheet.AutoFitColumns() is throwing error.
  • Named range for pivot table is translated when opening/saving file with Aspose.Cells in German Excel.
  • Comments were misplaced when moving rows.
  • Refreshing a Pivot table with calculated items causes an exception after importing XML.
  • ArgumentOutOfRangeException when saving file after copying the workbook data to other workbook.