Released: Jun 16, 2023

Mises à jour de V23.6

Fonctionnalités

• Added support for traversing row/cell in reverse order.
• Added support for refreshing multiple consolidation ranges in a pivot table.
• Added support for extending rows when setting a total formula.
• Improved detection of Gzip files.

Correctifs

• Row with no data should be taken as blank and removed by Cells.DeleteBlankRows() even if there is merged cells intersect with it.
• Chart does not get updated when writing new lines to a listobject with Aspose.Cells.
• Arrow Shapes placed incorrectly after conversion to HTML.
• Arrow Shapes placed incorrectly after conversion to PDF.
• Text is upside down in some shapes - Excel to PDF conversion.
• Letters in the shapes become upside down in Excel to PDF conversion.
• RadioButtons are not displayed correctly in PDF and HTML.
• Tildes in a CONCATENATE function are turned into commas.
• Conditional formatting rule "not between" works differently than Excel.
• Comments are deleted when deleting blank rows.
• Generated XLSX file with volatile dependencies is not fully compatible with Open XML SDK.
• Time part "08:00" in MS Excel was formatted as "8:00" by Aspose.Cells.
• Last row is cut off while converting workbook to PDF with OnePagePerSheet set to true.
• XmlMap references not shifting when rows are imported.
• XML Import does not preserve column widths.
• Excel TIFF generation takes too much time.
• PDF conversion is making a few extra empty pages.
• The header and formats are not aligned properly when importing HTML to Excel.
• Saving HTML has visual issues with tables.
• File crash when adding data to the total row of the table.
• Provide some options/means to keep the format (style) for the values inserted into the Table/List Object.
• Style of Totals row covered by style of previous row when showing totals row.of the table.
• PowerQueries lost after replacement.
• Font and font size is not set to all lines in the textbox when exporting to XLS.
• Pivot table rows are not merged in PDF when the grand total is added.
• Aspose moves a graph beneath a table when totals row is enabled while Excel does not.
• InsertCutCells - Cutting rows and then inserting them somewhere else does not maintain formula references.
• The value of merged cells changed when copying columns.
• Chart is not being moved down after adding rows.
• Horizontal data in a chart is not expanded.
• When a sheet with ActiveX controls is copied to another workbook, some differences/issues occurred.
• Copied shapes become free forms.
• shape id changed after being saved and reloaded.
• Exception throw: 'Shape to image Error!'.
• Range merge exception while refreshing pivot table.