We are excited to announce Spread.NET v19.2, the latest release of our powerful .NET spreadsheet components for building Excel-like experiences in C# applications. This release focuses on customer-requested enhancements, usability improvements, and quality fixes across the Windows Forms and WPF spreadsheet controls.
From responsive image scaling and more discoverable custom functions to data-bound PivotTables and expanded scrolling controls, Spread.NET v19.2 gives developers more flexibility to create intuitive, data-driven desktop applications. Read on for the release highlights.
What’s New in Spread.NET v19.2
Ready to Try these .NET Spreadsheet Controls? Download the Latest Release Today!
Spread Windows Forms
Scale Images as Users Zoom Worksheets
Spread for Windows Forms now supports scaling images together with the worksheet zoom level. Images in ImageCellType cells scale according to the sheet's zoom factor when ImageCellType.Style is set to RenderStyle.Normal.
Scale Images with Sheet Zooming Documentation
This enhancement keeps images visually consistent with their cells as users zoom in or out, creating a smoother and more polished spreadsheet experience.
Make Custom Functions Easier to Find in the RibbonBar
Custom functions can now appear within built-in categories in the Insert Function dialog. Developers can override a function's Category to place it in the most relevant category, such as Statistical or Engineering.
For example, the following custom function, TAXVALUE, has been added to the Financial category.
Display a Custom Function in a Built in Category Documentation
By organizing custom functions alongside familiar built-in functions, applications can make specialized calculations easier for users to discover and apply.
Create PivotTables from Data-Bound Worksheets
Spread for Windows Forms now supports creating PivotTables directly from data-bound worksheets. Bound data fields can serve as the PivotTable source without requiring developers to manually add header rows. This streamlined workflow reduces setup work and makes it easier to turn application data into interactive summaries and analysis.
Creating Pivot Tables Documentation
Spread WPF
Take Greater Control of Scrolling Behavior
Spread for WPF v19.2 introduces new APIs for customizing scrolling behavior, along with support for horizontal scrolling using the mouse wheel. These enhancements give developers more control over worksheet navigation while providing users with a more flexible and familiar experience.
Applications can now:
- Scroll by row or column for precise worksheet navigation.
- Scroll by page to move through larger data sets more efficiently.
- Bring a specified area into view programmatically.
- Retrieve the current scroll position for custom navigation and application logic.
- Scroll horizontally with the mouse wheel using keyboard modifiers.
To scroll horizontally:
- Scroll right: Hold Ctrl + Shift and scroll the mouse wheel down.
- Scroll left: Hold Ctrl + Shift and scroll the mouse wheel up.
Scroll Worksheet Panes Documentation
Download Spread.NET v19.2
Spread.NET helps developers deliver Excel-like spreadsheet experiences in .NET applications without requiring Microsoft Excel. Explore the new capabilities in Spread.NET v19.2 and start incorporating these customer-requested enhancements into your Windows Forms and WPF projects.
Download the latest release today and see how Spread.NET v19.2 can help you build richer, more intuitive spreadsheet applications.
Related Blogs
Try Our .NET Spreadsheet Components
Spread.NET Resources
