Released: Jul 13, 2021

Updates in V21.7

Features

• Added the option to apply conditional formatting on Pivot Tables.
• Added the ability to create conditional formatting on PivotTable via PivotField in row area, column area and data area.
• GridWeb - You can now run formulas similar to GridDesktop feature.
• Added GridWeb rows and columns grouping feature.
• Added the ability to preserve text formatting while converting from HTML to XLSX.
• Added the ability to show cell comments (rich text) exactly as in Microsoft Excel.
• Added support for pattern display in GridWeb.
• Added the ability to render workbook to Printer.
• Added support for WCAG 2.0 when creating PDF from Excel file.
• Improved measuring text length when the fonts can not be shown.
• Replaced the font that can’t render the character(glyph) for chart to image.
• Added support for PasteOptions when copying ranges via Range.Copy.

Fixes

• Formula cell value is not updated automatically after changing related cell value.
• Rich text styles are lost while converting from HTML to XLSX.
• Smart Art pictures in XLS are incorrectly displayed after converting to HTML.
• Issue of rendering shapes in Excel to PDF conversion.
• Callout position is changed while rendering the spreadsheet to PDF.
• Characters in the circle shapes are shifted to the left a little in the output PDF.
• Excel file with watermark is not properly rendered to HTML.
• Many texts are out of the object.
• Enormous conversion time and output file size while converting specific worksheet of XLSX to HTML.
• Image and pie-chart incorrectly positioned when converting XLSX to HTML.
• Excel to HTML conversion - some wrong “” added.
• Hang on while saving to HTML.
• Wrong formula calculation during Excel to PDF.
• Cells.ImportTwoDimensionArray stopped working properly.
• Chart.ToImage issues.
• Wrapping text or setting column width via GridCell.GetWidthOfValue() is not working properly.
• Datasource issue of GridWeb Worksheets Designer.
• Cell background color has changed to white while rendering spreadsheets to image.
• XLSX to PDF conversion produces longer document having more pages than it should.
• Spreadsheet to PDF: Shapes are either misplaced or distorted.
• Text space missing in rendered emf image.
• Aspose.Cells does not use installed fonts on the machine in rendering PDF.
• Graph changes after saving it.
• Some characters were cut off in Auto Shapes.
• Embedded Gif image is rendered as a black box in Excel to TIFF conversion.
• XLSX to PDF rendering issue.
• Data labels on Scatter chart are not rendered correctly in the output image.
• Excel to PDF conversion is creating different chart in Windows 10, Windows Server 2008 and 2016.
• The font of chart title int output PDF is different from Excel.
• SetChartDataRange did not recognize merged cells.
• Height and width scales are not effective for TIFF images by Worksheet.Pictures.Add() function.
• Shape to image failed.
• Shape to image raise exception in docker environment.
• Exception raised while loading HTML file without using “HtmlLoadOptions.AutoFitColsAndRows = true”.
• Invalid OperatorType string val.
• Copying sheets between XLSB files produces corrupted output file.
• Shape.ToImage raise exception.
• Exception thrown when copying worksheet.
• “Parameter is not valid.” exception when rendering XLSX to HTML.