Released: Aug 8, 2024

Updates in V24.8

Features

• Added support for visiting all cells that contain "Place in Cell" pictures.
• Added support for VALUETOTEXT Function.
• Added GridWeb support for .NET 6.0 on Linux.
• Added the ability to sort Pivot Table by Pivot Field Item.
• Added support for sorting by specific pivot item.
• Added support for editing formulas with blank spaces.
• Added configuration support for showing or hiding invisible shapes in GridJs.
• Optimized issues related to option switching and filling details.
• Enhanced input checking, error prompts will occur if the input isn't a formula or number.
• Added formula calculation support for list types.
• Implemented validation for the 'ignore blank' option.
• Optimized the setting of default values for reverse selection.

Fixes

• Do not encrypt document properties when encrypting file.
• Some characters are rendered in wrong positions in Excel to PDF.
• Rendering of text content to PDF is inconsistent with rendering to PDF via Excel.
• YEARFRAC formula issue with 29th of Feb and 1st of Jan.
• Hyperlinks in PDF cannot work after calling formula calculation.
• LET Function evaluated as "#VALUE!" error.
• Eval err. when converting spreadsheet.
• Some datalabels on the chart missing in the output image for worksheet rendering.
• The arrows/bullets that point at the intersection of the different sections of the charts is somehow not pointing at the intersection when rendering.
• Some charts are rendered with missing labels.
• The check marks in the charts are pushed further to the right when it's supposed to be closer to the box with the value.
• Alignment of Excel chart labels (legend entries) is not proper in the output image.
• Chart to image issue: Scatter chart with gaps displayed without the joining line.
• Aspose.Cells renders two pages instead of one page in Excel file to PDF conversion.
• Excel file to PDF conversion - Aspose.Cells renders two pages instead of one page.
• Text underline display error when converting file to PDF.
• Font size reduced to 1 for multiple bullet points when adding HTML rich text to worksheet cell.
• SpreadsheetML to XHTML produces invalid HTML.
• Image is shifted when converting XLSX to HTML.
• Pivot Table area formatting disappears after opening the resultant spreadsheet in Excel.
• Worksheet with PivotTables corrupt after save.
• Issue with sorting row field by values in specific field.
• Only first row in merged cells is rendered when blank rows are removed.
• Math equation lost in opening Excel spreadsheet.
• The result file crashes when resaving the sample file.
• Error message when opening an XLSX.
• Data misplacement and loss occurred when importing JSON into Excel.
• Single node is exported as attributes when exporting file to JSON.
• Lost outline border after refreshing pivottable.
• The output file is corrupt after copying worksheet with slicers.
• Empty strings in some built-in properties of an encrypted OOXML workbook.
• Tab Color not being Set for Tab with Themed Colors.
• Throws exception when setting corrupted license file.
• Image is duplicated when converting XLSB to XLSX.
• MS Excel shows error notifications while opening XLS file after XLS-XLSM-XLS conversion.
• Some built-in properties are lost during XLS-XLSM-XLS conversion of encrypted workbook.
• Fixed errors in comparison methods during formula validation.
• Corrected the date picker display issue in the new date validation.
• Resolved the issue of System.Object[] being returned in list type values.
• Fixed the issue where cells can't select list options after setting validation to list type.
• Conversion numbers to XLSX throws an exception of negative row index.
• Resolved conflict of merged cells when converting Numbers to XLSX.
• Invalid shared formulas when converting Numbers to XLSX.
• Workbook.AcceptAllRevisions() caused Exception : Destination array was not long enough.
• An exception occurred while loading the saved XPS.