Released: Jun 13, 2022

Updates in V22.6

Features

• Added support for formatting an entire row of data in PivotTable.
• Added 'GridWorkbookSetting' to GridWeb.
• Enhanced 'LightCells' model when setting formulas.
• Added the ability to detect file format from streams with passwords.
• Improved reading of blank cells in XLSX files.
• Added support for BouncyCastle v1.71.

Fixes

• Thousand of the getResourceAsAStream calls causes high CPU load and memory consumption during report generation.
• When converting XLSX file to PDF, the date in the pivot table becomes a serial number.
• Excel file gets corrupt when opened and saved with Aspose.Cells.
• Condition formatting issue when deleting the row or column.
• Opening and saving with Aspose.Cells corrupts the workbook.
• picture position issue for print for the file fs.zip in GridWeb.
• issues for display ofd.zip in GridWeb.
• GridWeb display issues from customer.
• additional issue 1,column A background color is not same as in excel for yscl.xls at sheet4.
• additional issue 3,setCalculateFormula to false does not work.
• Include the caption tag/element for the table when loading HTML.
• The effect of Excel chart in excel is different from that in HTML.
• Unicode in JSON will break generated XLSX and CSV.
• Issue with ThreadedComment.setCreatedTime() method.
• Sorting not working after grouping the rows.
• Double value to string gives tailing zero which is incorrect when comparing with ms Excel’s result.
• implement search for freezepane.
• investigate the issue of setactivecell does not work sometimes.
• Graphic in print area not exported in Excel to HTML conversion.
• Chart is shifted to right while converting to HTML with print area.
• Multi-lines captions are lost except the first line in HTML to XLS conversion.
• Chart is missing while exporting chart to SVG in HTML.
• Issue with data display in the data table after the coordinate axis is set to logarithmic scale - Excel to HTML/PDF conversion.
• How to retain percentage format of certain pivot rows when expanding node data of a pivot column/field.
• Sorting not working after grouping the rows.
• Slow copy with conditional formatting using newer version.
• When sorting large groups with multiple keys, it throws “java.lang.ArrayIndexOutOfBoundsException”.
• Issue with Smart Markers feature since Aspose Cells 22.5.
• Clear content on copied sheet throws NullPointerException.
• Cells.getMaxDataColumn returning different (wrong) value in 22.5.
• Excel document page is messy when loading into Aspose.Cells.GridWeb(Java).
• Issue with data alignment when loading the XLS into Aspose.Cells.GridWeb (Java).
• Issue when loading the et file into Aspose.Cells.GridWeb (Java).
• The title of the axis in the chart is rotated in the output image - Chart to image conversion.
• Gray line drawn in the output image from XLS file.
• Loading ODS file hangs.
• Exception “java.lang.IllegalArgumentException: Invalid column index” when loading an XLSX file into GridWeb.
• “Not a numeric value” error when converting Excel sheet to HTML/PDF.