Released: Jan 10, 2024

Updates in V24.1

Funktionen

• Added the ability to keep the header row in each worksheet when converting a CSV to Microsoft Excel.
• Added support for Microsoft .NET 8.
• Added a new GridDesktop auto-fill feature.
• Added support for adding custom styles when exporting files to HTML.
• Added auto-fill support for the merge area.
• Added support for setting wrap using the UI.
• Added support for setting text rotation using the UI.
• Auto-fill data from right to left and bottom to up.
• Show the active sheet background in the bottom tab bar.
• Support for reading and writhing the min and max value of a pivot field in XLSX.

Fehlerkorrekturen

• SetDynamicArrayFormula with large content generates corrupted XLSX.
• Image orientation is different after Excel to PDF conversion.
• Fails in converting SVG to image.
• Comment text color is missing when saving file to PDF.
• Aspose.Cells.Drawing.TextBox AutoSize issue.
• DataSorter sorting not working when sorting from right to left.
• The SEQUENCE formula cannot obtain the correct values after copying the range.
• Some Excel functionality (data validation, formulas evaluation, etc.) not working properly.
• Shape size does not change in zoom in/out operation in GridDesktop.
• Fail to open the customer's file in GridWeb .NET 6.
• After entering invalid formula value, the formula bar lost focus when clicking in sheet cell in GridDesktop.
• Picture.Width is wrong after inserting TIFF image to sheet in .NET 6.0.
• Focus cell position can not be changed by using key board navigation after load spreadsheet file.
• Data loss when converting XLSX file to PPTX.
• The result file has heavier borders and a wider table compared to table generated by copying/pasting.
• The state of the hidden column changes when calling Worksheet.AutoFitColumns and set AutoFitterOptions.IgnoreHidden is true.
• Slicer filtering: after canceling filtering, the value of the cell is incorrect.
• Merge PivotTable.copyRows and copyColumns,copy methods.
• Excel file corrupted after adding pivot table and pivot chart to it.
• FileFormatUtil.VerifyPassword not working.
• A few possible faulty cases with NeedQuoteInFormula.
• Support rotation 255 setting.
• An exception occurs when rendering SVG into a picture.
• Shape to image raise exception in docker enviroment for the file Defects List (24-06).xlsx.
• Loading XSLX file raises NullReferenceException.
• ArgumentOutOfRangeException occurs when saving file to HTML.