Released: Oct 11, 2024

V24.10 中的更新

特性

• Added support for implementing custom functions through Aspose.Cells API using AbstractCalculationEngine functionality.
• Added support for using Object type objects as function parameters.
• Added support for functions that return Object type objects.
• You can now delete blank rows/columns between a user specified range.
• Added support for getting the source of a pivot table from a corresponding external connection.
• Added support for getting the source of DataModelConnection.
• Added the ability to create compact pivot tables.
• Added support for formatting date as 1900-2-29 to mimic Microsoft Excel's behavior.
• Enhanced converting pivot area to range.
• You can now append file protocol to the address of shared directory/file when setting hyperlink.

修補程式

• Rows covered by shapes are deleted when deleting blank rows.
• Writing to range causes hang if automatic calculating formulas.
• Invalid cell name exception occurs when parsing OleObject.
• Corrupted XLSX file when converting from XLS with olap pivot tables.
• Lock aspect ratio is still not selected when setting the IsAspectRatioLocked property to true.
• Shape to image error when converting file to PDF.
• Custom function not parsed into formula when loading Excel file.
• Custom Format is removing negative sign for a value field.
• Generated XLS file is corrupted after re-saving from XLSX.
• Default value of DeleteBlankOptions.MergedCellsShrinkType is expected as KeepHeaderOnly but actually was None.
• Changing DeleteBlankOptions.EmptyFormulaValueAsBlank takes no effect.
• SUM with XLOOKUP function disappears in sheet after calling Workbook.CalculateFormula method.
• Workbook.RefreshDynamicArrayFormulas issue(s).
• MATCH function does not give the correct value when search value in result of HSTACK function.
• Calculated results of some formulas are different from MS Excel.
• Histogram cannot display correctly when converting files to PDF.
• Column chart cannot display correctly when converting files to PDF.
• Bubble chart axis display error when converting file to PDF.
• Chart.Calculate did not populate all points DataLabels Text with UpdateAllPoints=true.
• Text and chart overlap when converting chart to emf.
• Chart was not rendered properly.
• Combo Chart was not rendered properly.
• Horizontal lines disappeared and text overlapped when converting Excel file to PDF.
• Adding a bookmark with SecurityOptions creates a garbled text PDF bookmark.
• Setting a multiline watermark to the PDF with \n or \r\n does not work properly.
• Save as HTML places shape on different place.
• Lost OLAP pivottables when converting XLSB to XLSX.
• Some issues with Excel spreadsheet to .ODS format.
• Excel repairs workbook after copying and saving it.
• Regression: Changing ExternalLink DataSource corrupts XLSX files in versions later than 24.2.
• Resaving Workbook corrupts OpenXML structure.
• Worksheet UniqueId is unreliable for XLSB files.
• ArgumentException occurs when saving file to dif format.
• Date format lost when saving an ODS file as CSV.
• Invalid pivot area format after converting XLSX to XLSB.
• Protection lost on chart sheet when file saved in XLSX or XLSM.
• CategoryAxis AxisLine.Color is not working properly.
• This pivot field has more unique items than can be used in a pivot table when calling AddFieldToArea method.
• The function of data pivot field lost when loading ODS file.
• Invalid location of pivot field when loading ODS file.
• Incorrect pivot table of XLS file.
• IndexOutOfRangeException when calling Workbook.CalculateFormula() method.
• IndexOutOfRangeException when calculating Pivot Table.