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.
What’s New in Spread.NET v19.1
Ready to Try these .NET Spreadsheet Controls? Download the Latest Release Today!
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.
View the PivotTable Style Options Documentation: 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.
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.
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.
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.
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:
View the WPF spreadsheet VisualFunction Documentation.
Spread.NET v19.1 delivers a strong set of enhancements designed to improve usability, flexibility, and performance across both platforms. These updates—along with numerous bug fixes and optimizations—help you create more powerful spreadsheet applications with ease.
Related Blogs
Try Our .NET Spreadsheet Components
Spread.NET Resources
