We are excited to announce the release of Spread.NET v18.1 (Service Pack 1)! This release adds several new enhancements to both the Spread WinForms and Spread WPF controls.
Spread.NET v18.1 Release Features
- Spread Windows Forms Enhancements
- Spread WPF Enhancements
Ready to get started? Download Spread.NET Today!
Spread Windows Forms Enhancements
Customize the Text in Print Preview and Page Setup Dialogs
You can customize and localize the text displayed in the EnhancedPrintPreview and PageSetup dialogs in any language using the FarPoint.Win.Localizer.LocalizeText event.
This example uses the translated Japanese language strings stored in resource files to localize the text in these dialogs:
 |
 |
Style Storage Optimizations
Spread now allows you to style or format a specified cell range individually without affecting the entire column using the StyleRangeStrict property.
Suspend Calculation Optimization
You can now suspend the calculation of formulas while saving and opening spreadsheets, even when the values in dependent cells change using the SuspendCalculation property.
New CellValueCommitError Event
In previous versions, cell editing would stop if there was an error when editing a cell. Now, Spread for Winforms provides a new event, CellValueCommitError, that fires if there is a cell-editing error, allowing you to continue or stop the cell editing.
Circular References Enhancements
The CircularCellChanged event monitors changes of all circular references in the spreadsheets. This event is triggered when creating, editing, and removing the circular references, helping you deal with situations that may affect formula calculations, for example, helping to identify cells that cause circular calculations.
You can now also attain all the circular references of workbook and worksheet using IWorkbook.CircularReferences and IWorksheet.CircularReferences.
.NET 9 Enhancement
Spread’s built-in objects now support binary formatting using DataContractSerializer. This enhancement has resolved the compatibility issue previously encountered with .NET 9, which required adding a reference to the Formatters NuGet package for binary formatting.
Spread WPF Enhancements
Chart Enhancements
Many enhancements have been added to the WPF charts in this v18.1 release. Read on to learn more.
New Surface Chart
A new Surface chart has been introduced, which allows users to plot data on a three-dimensional surface. This is especially useful for analyzing optimal combinations between two data sets. Spread for WPF supports the following types of Surface charts:
| Type | Sample | Description |
| Surface |  |
Represents a surface chart with a 3D effect. |
| SurfaceTopView |  |
Represents a top-view surface chart. |
| SurfaceTopViewWireframe |  |
Represents a top-view surface chart without fill color. |
| SurfaceWireframe |  |
Represents a surface chart with a 3D visual effect and no fill color. |
Predefined Chart Styles
All charts include a default style. However, you can also customize the default appearance of the chart by defining and applying a predefined style that meets your specific requirements. There is a wide range of styles available for different charts, for example:
3D Line and Area Charts
The WPF charts now support 3D formats in the Line and Area charts as follows:
| Line3D Chart Sample | Description |
 |
ChartType.Line3D Represents a 3D line chart. It is used to display a 3D chart demonstration, showing trends over time or categories. It presents data on a third axis, which shows some lines that appear in front of others. |
| Area3D Chart Sample | Description |
 |
ChartType.Area3D Represents a 3D area chart. It is used to represent the chart demonstration in 3D, which is a modification of 2D area chart. It looks volumetric in appearance. |
 |
ChartType.AreaStacked3D Represents a stacked 3D area chart. It is used to represent AreaStacked chart with 3D visual effect, which is a modification of the 2D chart. |
 |
ChartType.AreaStacked1003D Represents 100% stacked 3D area chart. It is used to represent the AreaStacked100 chart with 3D visual effect, which looks volumetric in appearance. |
Pie3D Charts
The Pie Chart 3D data series default line style will now be similar to Excel.
Chart Data Label Supports Shapes
Users can now customize data labels with different shapes, including callout data labels, for better clarity and emphasis.
Chart 3D Wall Thickness
Users can now adjust the thickness of both back and side walls of the 3D charts for better customization.
Sunburst Chart Supports Multi-Level Categories
Sunburst chart now supports multiple levels to provide a more detailed and hierarchical representation of data.
Support 3D Rotation
Spread for WPF now allows you to enhance data visualization with the rotation feature of 3D charts.
Support Text Orientation for DisplayUnits
Improvements have been made to configure the text orientation of display unit labels using the DisplayUnitLabel.Orientation API. It accepts integer values from -90 to 90 degrees to set a specific text angle for the text on the display unit label.
Enable ToolTips Shadows and Rounded Corners in Windows 11
Spread for WPF now allows you to add shadows and rounded corners on ToolTips in Windows 11 to modernize the user experience.
| Disable shadows and rounded corners on ToolTips in Windows 11 | Enable shadows and rounded corners on ToolTips in Windows 11 |
 |
 |
 |
 |
Suspend Calculation Optimization
You can now suspend the calculation of formulas while saving and opening spreadsheets—even when the values in dependent cells change using the SuspendCalculation property.
Conclusion
These are just some new features we have added to Spread.NET in v18.1, including customer fixes. Be sure to download a trial of Spread.NET to try out these new features and check out our documentation today!
Related Blogs
Try Our .NET Spreadsheet Components
Spread.NET Resources
