Released: Jan 13, 2025

V25.1.1 での更新項目

機能

• Added support for ignoring the calculation of custom functions to keep the original spilled range and values of dynamic array formulas.
• Added support for row/column insert/delete event for client API.
• Added pre-check event support for row/column delete/insert operation.
• Added a JS event for updating cell.
• Added support for API to show HTML node and interact with HTML node at specified cell position.
• Added support for different decimal separators for different locale settings.
• Added support for saving autoshapes and free shapes to ODS file.
• Added support for getting the expression of external table reference while calculating formulas with user's custom engine.
• Added support for calculating external table reference when external workbook source has been set.
• Aspose.Cells for .NET no longer uses vulnerable dependency.
• Improved trimming in Blazor WebAssembly publishing.
• Upgraded referenced SkiaSharp library to v3.116.1 for Blazor WebAssembly with .NET 9.0 target framework.
• Added support for Format 2 subtable in CMAP table of font.
• Added support for CSS custom properties when converting a file to HTML.
• Re-implemented pivot conditional formatting API.
• Added support for reading and writing Forms setting in the Table.
• Simplified importing of list of row data into cells.
• Added support for searching for filter list.
• Added the option to display formula tips and modify the default behavior to not display them by default.
• Added support for multiple instances in one page.
• Added support for showing total count for filter items.
• Optimized the logic of the validation failure popup button to be consistent with Excel.

不具合の修正

• Shape to image error when saving file to PDF.
• Issue of Equal filtering in non English environments.
• 30 2310469658 was trimmed and parsed as numeric value 30.
• TEXTSPLIT function was not calculated correctly when there is row separator only.
• The result of HYPERLINK function is incorrect for value types other than string.
• Solve the problem of text clipped and line breaks in bar chart.
• Strikethrough style lost when converting chart to XPS.
• Double strikethrough style lost when converting chart to XPS.
• Certain values in the chart not rendered fine in the chart to image conversion.
• Extra text is printed in chart.
• Fixed Area background color error in chart.
• Published Blazor WASM App unable to load Workbook.
• Error setting license in AOT Blazor App.
• XLSX to PDF: Chinese fonts are not applied in PDF file.
• The position of the text strikethrough line becomes lower when converting file to XPS.
• Text italics and bold styles are lost when converting file to XPS.
• Font name in the generated PDF is garbled while converting workbook to PDF.
• The result file is corrupted after calling workbook.CalculateFormula().
• Invalid refreshed result of filtering by Date Equal.
• Pivot table conditional formatting not working.
• After pivot replacement wrong data source was shown.
• Conditional format is not same as in MS Excel.
• PivotFilter is not being applied when adding filter to pivot table to filter "(blank)" value.
• Charts overlap with the tables when saving file bytes to XLSX.
• INDIRECT function failed due to case sensitivity in table column names.
• Data misalignment when exporting data to DataTable.
• Font size and font style getting changed after saving Excel file.
• The generated XLSX file is corrupted after converting an ODS file.
• Invalid pivot format.
• The smart tags in the template file are still retained after calling WorkbookDesigner.Process(false).
• Issues with percentage formatting and decimal separator.
• Issue with Text Input.
• Unnecessary Border Lines Between Columns.
• Vertical alignment settings are applied.
• Data validation issue.
• Fixed the error in the decimal validation check.
• Render conditional style issue.
• HTML page input text box get affected by GridJs.
• Formulas are not removed when deleting cells with formulas.
• Fail to importExcelFileFromJson in GridJs Java version for JSON string with merge area.
• NullReferenceException occurs when importing JSON as data source of smartmarker.