Released: Jul 13, 2024

V24.7 中的更新

特性

• Added support for the DROP function.
• Added support for outlining the star characters in the chart.
• Added support for DateOnly when calling ImportCustomObjects method.
• Added support for making an object as decorative in XLSX.
• Improved the performance of calculating LET function with complex parameters.
• Improved the performance of calculating MAKEARRAY function.
• Added support for swapping series.
• Changed ArgumentException to CellsException.
• Added "ApplyFont" in series datalabels.
• Renamed the methods of ChartDataTable.
• Optimized the display of the TreeMap Chart.
• Added support for trying to load local Office cloud font by default.
• Added support for placing the picture which is over cell in cell.
• Added the PivotTable.CalculateData() overload method.

修補程式

• Fixed the text box height when the Japanese text has a line break.
• Excel to PDF conversion - shapes rendered with missing text.
• Shape text (image caption) cut off in the output PDF and HTML.
• TextParagraph.IsHangingPunctuation Attribute does not work when converting files to PDF.
• Dashed lines were appearing as solid lines in the generated PDF.
• Calculated cell with RATE-function is #VALUE! after CalculateFormula().
• Shared formulas are ignored in custom calculation engine.
• Complex array function formula not working when calling CalculateFormula method.
• Complex array function formula returns #VALUE when calling CalculateFormula method.
• Out of memory error was caused when refreshing dynamic array formulas.
• ROWS/COLUMNS functions give different values from what MS Excel produces.
• Incorrect spill range and calculated results for function chain UNIQUE(SORT(FILTER(...))).
• Chart to Image - The x axis on the image does not match with Excel sheet chart.
• Chart data loss when converting file to image.
• HtmlSaveOptions.AddTooltipText does not work on format data.
• Excel table created based on HTML does not look the same.
• XLSX to HTML: Right to left format and borders not rendered correctly.
• Olap slicer cache corrupted when converting from XLSB to XLSX.
• Aspose.Cells corrupts XLS file when we try to add long hyperlinks.
• Extra space between thickBot and equal characters in XML tag.
• The Range is hidden when calling Cells.InsertCutCells method.
• The result file contains extra data after resetting the hyperlink address.
• Invalid column index when adding Sparkline.
• InsertCutCells is causing unexpected conditional formatting changes.
• xcel SUMPRODUCT #VALUE Issue.
• Expanding a table with placed empty merged cells under the table corrupted resultant file.
• Support keeping properties of Image Effect.
• Replacing text with FontSettings not working.
• Error on conditional formatting when converting XLS file to XLSX file.
• Workbook.Save very slow with rich text formatting.
• The result file is corrupt when copying sheets with slicers.
• ExportDataTable does not use current culture for double to string conversion.
• Export to/from JSON - JSON structure corrupted.
• Fixed tile order.
• issue when converting Numbers to XLSX.
• Fixed chart series reference cells from an external sheet.
• PivotTable.RefreshData crashes: "Formula is empty...".
• Excel to PDFA-1B conversion - CellsException "Length cannot be less than zero".
• IndexOutOfRangeException was thrown when calculating SORT function.
• System.ArgumentOutOfRangeException when rendering chart to image.
• Loading controls2.xlsx in GridWeb raised exception.
• Exception "This Excel files contains (Excel95 or earlier file format) records" when opening an older Excel XLS file.