Spread.NET v19 is Released!

We’re excited to announce the release of Spread.NET v19, delivering 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 Enhancements
  • Pivot Table Engine
  • Formula Auto Indent
  • Set Pinned Rows or Columns
  • Sheet Tab Style
  • New Calculation Functions
  • New Enhanced Chart
• Spread WPF Enhancements
  • Pivot Table Engine
  • Data Label and Legend Text Orientation
  • Cell Overflow
  • New Calculation Functions

Download a free 30-day trial of Spread.NET today!

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.

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

Data Label and Legend Text Orientation

Enhanced charts in WPF also support horizontal, vertical, and Far East vertical text orientations for both data labels and chart legends.

See the Spread for WPF Data Label Chart Element Documentation.

Cell Overflow

When cell content exceeds the available width, Spread WPF now allows developers to control overflow behavior using the AllowCellOverflow property. 

To learn more, see the Cell Overflow Documentation.

New Calculation Functions

Spread WPF’s Calc Engine is updated with the same new functions introduced in WinForms:

• TRIMRANGE
• REGEXTEST
• REGEXEXTRACT
• REGEXREPLACE

…and other function enhancements to support more robust formula calculations.

Download a free 30-day trial of Spread.NET today!

These highlights represent much of what’s new in Spread.NET v19, which also includes several customer-requested improvements and quality fixes.

Download a free trial today and explore the full capabilities of Spread.NET : build smarter, faster, and more interactive spreadsheet applications with our most advanced version yet.