Released: May 12, 2026

V26.5 中的更新

特性

• Added new Workbook() with environment variables and default values.
• Added support for converting workbook to OFD (Open Fixed-layout Document).
• Added the ability to snap to cell boundaries in zoom in/out.
• Added an event to determine if transparent mode is currently active or inactive.
• Added support for multiple aggregations for GROUPBY function.
• Upgraded version of the referenced SkiaSharp to 3.119.0 for .NET 9/10 target framework.
• Provided a new method to set VerticalAxisMaxValueType and VerticalAxisMaxValue of SparklineGroup together.
• Enhanced adding pivot filter field with pagination.
• Added support for refreshing the format of pivot table view with indent setting.
• Added support for merging inserted blank rows of pivot table.
• Added a wrap for redaction label.
• Added support for showing tooltip when redaction label is not fully displayed.
• Added a redaction feature in lazy-loading.
• Added an event for adding/clearing the redaction reason.
• Redaction reason dropdown in toolbar shall always be 250px width instead of changing width based on length of the selected text.
• Added client API to load Excel files with batch redaction operations.
• Added support for customizing the "Add Redaction Reason" window.
• Refined event description for npm type declaration.
• Added client APIs to delete/clear redactions from sheet.
• Improved worksheet protection options.

修補程式

• "Unsupported function: CUBEMEMBER" exception on Workbook.CalculateFormula() method.
• Multiple Hyperlink in Single cell of Excel is not working when converting from HTML with .NET 8.0.
• Numbers wrap in the middle of the value in PDF despite disabled 'Allow Latin text wrapping' on Workbook.Save() method.
• Cell.StringValue returns #VALUE! when using complex data type cards.
• Data corruption and '#VALUE!' errors after converting to HTML.
• Sheet gets corrupted when attempting to edit the value in cell C1.
• CalculateFormula = true.
• Dynamic-array spill range over-allocated by one row (#N/A in trailing cell) on Workbook.RefreshDynamicArrayFormulas method.
• Sorted result is different from MS Excel for GROUPBY with aggregation function MIN.
• Data labels overlap chart lines and incorrect dashed line rendering on Chart.ToImage() method.
• Extra blank pages generated during Excel to PDF conversion on Workbook.Save() method.
• Overlap when text is rotated 90 degrees.
• Date values are left-algined in the resultant HTML.
• Save As Markdown render only Print Area.
• FileFormatType items not working.
• Data Indentation of the Pivot Table is lost while converting spreadsheet to PDF.
• Incorrect default VerticalAlignment in new Workbook.
• Repeated pivot item should be formatted too when refreshing pivot table.
• Invalid format of pivot table view.
• Aspose cells is reading cell value as numeric type cell and value differently from Excel.
• Possible to create corrupted Excel file by specifying out of bounds validation area.
• The sparkline inside the cell is rendering incorrectly.
• Lost content from merged cells when merged cells are to the left of a smart marker.
• Loss of VBA macros and worksheet controls when saving XLSM.
• Exception is thrown when refreshing pivot table.
• Useless media data was kept.
• Lost embedded images when converting to HTML.
• Exception was thrown when calculate pivot chart data.
• Invalid pivot table view.
• Invalid Power query formula definition.
• File corruption after saving.
• Power query parameter description is always null on PowerQueryFormula.Description property.
• Slicers are deleted after calling PivotTable.RefreshData() method.
• Power query functions are read the type as Formula.
• GETPIVOTDATA returning #REF! on Workbook.CalculateFormula method.
• Incorrect file format detection for OTG, ODB.
• Cannot click checkbox in GridJs.
• Fail to download in GridJs.
• Right-clicking on empty area was showing "remove redaction", it should still show "remove redaction" if it is right-clicked on redaction shape.
• Extra empty rows rendered.
• Drop down list searching works only for the first letter typed in Aspose.GridJs.
• Redaction shape becomes distorted after scrolling in a worksheet with freeze pane.
• Redaction zorder issue.
• Redaction shrinks and reverts to original position when moved to the first column.
• Support fuzzy search for drop-down options.
• Fail to set text for shape.
• Data loss and vertical scrollbar disappearance after Range.Copy operation.
• Row scrolling is is not pixel-based.when freeze panes is enabled and row height is excessive.
• Conditional formatting display is inconsistent with Excel.
• Dragging value from a cell over filtered-out rows affects those row values in Aspose.GridJs.
• Submenu options misalignment in context menu.
• When a cell with a dropdown text that is too long, the text is not shown properly.
• Chart loading renders into sheet that does not belong to it when chart sheet is frozen.