Released: Sep 15, 2023

Updates in V23.9

Features

• Added support for calculating LAMBDA, MAP and SCAN functions.
• Added support for parsing and calculating formulas with user defined custom function and definition.
• Added support for excluding specific data when exporting data to DataTable.
• Added localization support to GridDesktop.
• Added support for picture click event to GridDesktop.
• You can now auto extend empty rows/columns when scrolling down/right like Microsoft Excel.
• Added support for selecting text within a textbox control while in read only mode.
• Added support for outputting thread comments to sheet end while rendering to PDF.
• Added support for obtaining default table style and default pivot table style.
• Added APIs to get filtered chart series.
• Added support for encoding VBA projects.
• Added support for data type detection when exporting data to DataTable.
• Added support for refreshing all workbooks.

Fixes

• Issue with evaluating dynamic array formula within custom calculation engine.
• Dynamic array formula cannot be refreshed correctly when one depends on the calculated result of another one.
• Regression: Cell.StringValueWithoutFormat() not returning correct value.
• The program runs continuously during Trim formula calculation without ending.
• IF function with array condition and reference values of blank cells cannot be calculated correctly when it is used by other functions.
• The series rendering of combo charts is incomplete.
• Graph lines disappear when converted to PDF or PNG.
• label position is not correct for the chart.
• Legend items are not correct for the chart.
• Upgrading Aspose.Cells causes saving an image of a bubble chart to be distorted.
• Switch to another worksheet after the newly inserted image is not fully loaded will cause the image never show.
• Spreadsheet selector range has fractional eci.
• Support select on the images and shapes in readonly mode.
• Border display not same as in Excel.
• Merge area does not render correct in print view.
• Right click on textbox does not show context menu.
• XLSX to PDF: Content shifted to next page.
• Not able to print comments using Aspose.Cells when generating PDF with empty Excel sheet which has only comments and notes.
• Incomplete content display when saving file to PDF.
• Page size is not reflected when converting file to PDF.
• Wrap text property not working when saving Excel to HTML.
• The Japanese display name of VBA module is not correct in navigation bar.
• Keep the same paper size when converting Excel to Word.
• File crashes after deleting the worksheet and resaving the file.
• Data error in pivot table after refreshing pivot tables.
• Check box status changes for selecting multiple items after refreshing pivot tables.
• GetValidation() returning the wrong validation values list.
• Conditional formatting extended but created individual styles per cell instead of a single style for the whole range.
• Aspose.Cells corrupts password-protected XLS files with ActiveX controls after re-save.
• Aspose.Cells does not save modified text in an ActiveX control in non-password-protected XLS files.
• Issue with copying a range when cells have the "Wrap text" flag set to true.
• Check the released 23.8.
• Issue with pivot table which is removed after opening and re-saving the Excel file.
• The color of display unit label should be red.
• Split type of series should be Position not automatic.
• Formula is not correct after calling Cells.InsertCutCells method.
• Broken numbering in Excel to SVG conversion.
• Range merge exception while refreshing pivot table after setting IsHidden property.
• NullReferenceException occurs while refreshing pivot table.