Release Highlights

Aspose.Cells for .NET 25.3 (MSI) adds the ability to export Excel data to Apple Numbers files, retrieve cell display styles via Cells API, and enhances GridJs with Excel-style shortcuts and usability.

✳️ New Feature

• Export to Numbers File: Export cell data, styles, formulas, and comments to Numbers files.
• Get Display Style from Cells: Retrieve display style directly using Cells.GetCellDisplayStyle() without needing a Cell instance.
• Track Conditional Formatting Changes: Detect format condition formula changes after shifting cells.
• Font Binary Retrieval: Get binary content of fonts used in the workbook.
• Excel Shortcuts in GridJs: GridJs now supports shortcut operations: Ctrl+D, Ctrl+;, Ctrl+Shift+;, Ctrl+R.

🔧 Enhancement

• Apply Adjacent Cell Borders: Display style now reflects borders from neighboring cells.
• HTML Export: Inline styling inside HTML elements and highlight for selected sheet tab.
• GridJs Usability: Copy from Excel to multiple areas, use arrow keys in read-only mode, and more simplified APIs.

🛠 Fix

• Resolved layout issues in charts, including treemap, radar, bar, and legend rendering.
• Fixed incorrect formula results for MATCH, complex numbers, array formulas, and multi-sheet sums.
• Corrected display bugs in XPS/PDF conversion, including small caps overlap, strikethrough misalignment, and label rendering.
• Addressed dropdown list persistence, data label formatting, and validation display in Excel and GridJs.
• Fixed exceptions during workbook saving, pivot data source reading, and image/chart conversion.

🔁 Public API & Backwards Incompatible Changes

• New API for Cell Style:
  • Cells.GetCellDisplayStyle(int row, int column[, BorderType adjacentBorders])
  • Cell.GetDisplayStyle(BorderType adjacentBorders)
• Conditional Formatting Monitoring:
  • AbstractFormulaChangeMonitor.OnFormatConditionFormulaChanged(FormatCondition fc)
• Chart Layout Properties:
  • Obsoleted pixel-based properties for ChartArea, ChartFrame, PlotArea, and Title
  • Introduced ratio-based properties like XRatioToChart, WidthRatioToChart, etc.
• Font Binary Access:
  • FontConfigs.GetFontFileDataInfo(string fontName, bool isBold, bool isItalic, bool isExactStyle)
• Markdown Export Settings:
  • MarkdownSaveOptions.TableHeaderType, MarkdownSaveOptions.SheetSet
• Smart Marker Scoped Processing:
  • WorkbookDesigner.Process(Range, Boolean)
• GridJs Enhancements:
  • Added GridJsOptions, GridJsService, GridJsControllerBase
  • Added Config.BaseRouteName property

👉 You can view the full list of updates by visiting Aspose.Cells for .NET 25.3 Release Notes

cell display style api | export numbers file | chart layout ratios | excel shortcut keys gridjs | font binary info