Released: Dec 5, 2024

18 中的更新

特性

• PDF Export
  • Spread WinForms and WPF now supports saving a spreadsheet document to a much higher resolution PDF, with many of the same behaviors as Microsoft Excel. This can be achieved in multiple ways:
    • Saving a Sheet to PDF.
    • Saving a Workbook to PDF.
    • Printing a PDF.
  • The new PDF export supports Excel-compatible printing and now retains image quality. Some other printing enhancements include:
    • Rich text support.
    • Flat Style Mode format.
    • Image on header/footer.
    • Shapes with transparent colors.
• New WPF Spreadsheet Version
  • With the Spread.NET v18 release, MESCIUS have introduced an entirely new and improved WPF version of the spreadsheet. Some new features introduced with this release include:
    • Calculation Enhancements
      • External References.
      • Iterative Calculation.
      • Asynchronous Functions.
      • Dynamic Arrays.
      • New Excel Functions.
      • Sparkline Functions.
      • External Variables.
      • Fields and Rich Value Structures
    • New Chart Engine for more Excel Compatible Charts (Data Table, Trendline, etc.)
      • Chart Color and Style.
    • Formula Textbox.
    • Exchangeable XLSX.
    • XML Data File Support.
    • Table Data Binding.
    • Sorting by colors, icons, etc.
    • Removing duplicates.
    • Excel-like Fill (Gradient, Pattern, Theme Colors).
• Copying Skip Invisible Ranges
  • When copying a range of cells, hidden cells can be excluded from the copy. The RichClipboard property must be set to true, as well as the CopySkipInvisibleRange property.
• Table Auto Update Filter
  • Spread for WinForms now gives you the ability to change a table's filter to be updated automatically after a user edits a cell or a data source is changed.
• Context Menu without Ribbon Control
  • In previous releases, the context menu could only be shown when the ribbon control was being used. With v18, the context menu can now be used without the Ribbon control by simply creating a new SpreadContextMenuStrip instance.
• Copy Width/Height and Style when Inserting Rows and Columns
  • Inserting rows and columns into a WinForms spreadsheet now copies the row or column size and style from the previous row or column to the newly inserted one. This is supported via the context menu in both the Designer and at runtime, the ribbon bar, and using Ctrl+Shift+”+”.
• Display and Execute Undo/Redo History
  • The Quick Access Toolbar in the Designer now supports an undo/redo actions history where the action can be executed again or undone. This is achieved by clicking on the Undo/Redo dropdown button in the Quick Access Toolbar.
• Highlight Formulas
  • The DisplayFormulas property has been enhanced to highlight formulas for the active cell.
• Get Cell Reference from Pointer Location
  • A new API has been added to get the cell at a specific x,y coordinate in pixels. This can be useful for laying out charts and shapes at specific cell coordinates or getting a cell reference from a specific point.