What's New in Spread.NET v19

Spread.NET v19.1 - May 19, 2026

We’re excited to announce the release of Spread.NET v19.1—bringing powerful new capabilities and usability enhancements to both Windows Forms and WPF developers. This release focuses on improving data interaction, visualization, and productivity, helping you build richer spreadsheet experiences with less effort.

Spread Windows Forms & Spread WPF Enhancements

New Pivot Table Style Options

Take greater control over how your PivotTables look and feel. With new style options, you can now customize header appearances and apply banded row and column formatting. The result is cleaner, more readable PivotTables that make complex data easier to interpret at a glance.

.NET Developer Solution: Spreadsheet Designer Toolbar for Pivot Table Styles

Column Header, Row Header and Banded Row Style Formatting | Spread for Windows Forms Example

WinForms | WPF

Group Dialog for Pivot Fields

Grouping data is now more intuitive than ever. In addition to existing API-based grouping for numbers and dates, V19.1 introduces a designer-based dialog that supports grouping for numbers, dates, and now text. This enhancement simplifies data organization directly within your workflow.

Group numbers, dates, and text (Spread for Windows Forms)

View the Spread.NET Group Dialog Documentation: WinForms | WPF

Active Cell Focus Highlighting

Navigating large datasets just got easier. With the new FocusCellMode property, you can highlight the active cell’s row, column, or both—making it simple for users to track their position and reduce errors during data entry or analysis.

View the ActiveCell Highlight Documentation: WinForms | WPF

Support for .NET 10 and Visual Studio 2026

Stay up to date with the latest development platforms. Spread for Windows Forms and Spread WPF v19.1 fully supports .NET 10 and Visual Studio 2026, ensuring compatibility with modern development environments and future-ready applications.

Spread Windows Forms Enhancements

New PivotTable Protection Option

Enable secure interaction with PivotTables even on protected worksheets. The new “Use PivotTable” option allows users to work with PivotTables without removing sheet protection. Configure it easily through the Designer or programmatically via the AllowUsingPivotTables property.

PivotTable ProtectSheet within a WinForms Spreadsheet Control

View the WinForms AllowUsingPivotTables Documentation to learn more.

Paste Data Beyond Sheet Boundaries

Handling large data imports is now more flexible. The new PastingExceededValues option lets you control how pasted data behaves when it exceeds worksheet limits. Combined with the new ClipboardPastingEventArgs event, you gain fine-grained control over row and column expansion during paste operations.

To learn more, see the WinForms PastingExceededValues Documentation.

Seamless Hierarchical Scrolling Transition

Working with hierarchical (parent-child) data views is smoother than ever. Spread Windows Forms now supports seamless scrolling transitions between child and parent views, improving navigation and delivering a more natural user experience.

Support for Hierarchical Spreadsheet Scrolling in WinForms Apps

Check out the WinForms AllowScrollChainingDocumentation.

Spread WPF Enhancements

Drag Fill Support

Boost productivity with built-in drag fill functionality. Users can quickly populate cells by dragging across rows or columns—mirroring the familiar auto-fill experience found in spreadsheets like Excel.

Drag Fill Support in WPF Spreadsheet Apps View the Spread WPF DragFill Documentation to learn more.

Data Visualization Functions

Bring your data to life directly within cells. Spread WPF now supports data visualization functions, enabling you to create custom-rendered visuals such as sparklines and other graphical indicators. These functions combine calculation logic with rendering capabilities, opening the door to highly interactive and insightful spreadsheet designs.

This basic example paints a colored border around a cell that contains an error:

Data Visualization Functions within WPF Spreadsheets

View the WPF spreadsheet VisualFunction Documentation.

Spread.NET v19 - January 5, 2026

Spread.NET v19 delivers major new enhancements across both Spread for Windows Forms and Spread for WPF. This release expands analytical capabilities, improves usability, and offers deeper customization options—making it easier than ever for developers to build powerful, spreadsheet-driven .NET applications.

Spread Windows Forms - New Enhancements

Pivot Table Engine

Spread WinForms now includes a powerful pivot table engine that enables users to summarize, analyze, and explore large datasets directly within the spreadsheet. Developers can now offer interactive data aggregation—including grouping, filtering, and multidimensional analysis—without external tools.

To learn more, see the Spread for WinForms Pivot Table Documentation.

Formula Auto Indent

The FormulaTextBox now supports a more readable, structured view of complex formulas.
With AutoIndent = true, formulas automatically break into multiple lines with indentation based on the expression tree. You can also customize indentation using the IndentSize property—making long formulas far easier to read, debug, and edit.

Check out the WinForms Formula Documentation to learn more.

Set Pinned Rows or Columns

New methods—TogglePinnedRows() and TogglePinnedColumns()—make it easy to pin important rows or columns so they remain visible during scrolling. This is especially useful for comparing data, freezing headers, or keeping key information in view.

See the Set Pinned Rows or Columns Documentation.

Sheet Tab Style

Spread for WinForms now allows you to customize sheet tabs by adding icons, setting hover colors, and applying protected colors.

See our Tab Strip Appearance Documentation to learn more.

New Calculation Functions

The Calc Engine has been expanded with several new functions, including:

TRIMRANGE
REGEXTEST
REGEXEXTRACT
REGEXREPLACE
along with additional enhancements

New Enhanced Chart

We've introduced a new enhanced Chart, separate from the current WinForms legacy chart, that's based on the new WPF chart engine and supports several new features as listed below:

Data Table

Charts now support an optional data table displayed beneath the chart. This is ideal for users who need quick access to the exact underlying values—especially when data labels are minimal or disabled.

See the Spread for WinForms Data Table Chart Element Documentation.

Data Label and Legend Text Orientation

Enhanced charts now support customizable text orientation for both data labels and chart legends. Use the TextOrientation property to choose horizontal, vertical, or Far East vertical styles—perfect for improving layout or supporting East Asian languages.

See the Spread for WinForms Data Label Chart Element Documentation.

Data Label Number Format

You can now fully control number formatting for data labels in enhanced charts. Choose whether labels inherit their source cell formatting or apply a custom pattern such as:

- - #,##0,K;0 for thousands with a “K” suffix
  - 0.00% for percentages.

See the Data Label Number Format Documentation to learn more.

Smooth Line Chart

Use the ISeries.Smooth property to apply curved, visually appealing line styles—great for trend visualization without forcing angular interpolation.

Check out our Smooth Line Chart Documentation to lean more.

Chart Styles

Spread WinForms charts now support a wide range of predefined styles, letting you quickly apply cohesive, modern chart designs or tailor them to your application’s theme.

To learn more, see the Chart Styles Documentation.

Show/Hide Legend Entries

With the new ILegend.Delete() method, you can hide individual legend entries to simplify chart interpretation and fine-tune the presentation

See the Chart Legend Documentation to learn more.

Spread for WPF - New Enhancements

Pivot Table Engine

Spread WPF now includes a similar powerful pivot table engine as WinForms—enabling fast, interactive aggregation and analysis of large datasets directly within the WPF spreadsheet interface.