Released: Apr 30, 2025

18.1 での更新項目

機能

Spread Windows Forms:

• Added customize options to the text in print preview and page setup dialogs:
  • You can now customize and localize the text displayed in the EnhancedPrintPreview and PageSetup dialogs in any language using the FarPoint.Win.Localizer.LocalizeText event.
• Added style storage optimizations:
  • Now allows you to style or format a specified cell range individually without affecting the entire column using the StyleRangeStrict property.
• Added 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.
• Added a new CellValueCommitError event:
  • In previous versions, cell editing would stop if there was an error when editing a cell. Now, Spread.NET 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.
• Added 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.
• Added .NET 9 enhancements:
  • 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:

• Chart:
  • Added a new surface chart:
    • Now allows users to plot data on a three-dimensional surface, which is especially useful for analyzing optimal combinations between two data sets.
  • Added 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.
  • Added 3D line and area charts.
  • Added Pie3D charts:
    • The Pie Chart 3D data series default line style will now be similar to Excel.
  • Added chart data label supports shapes:
    • Users can now customize data labels with different shapes, including callout data labels, for better clarity and emphasis.
  • Added hart 3D wall thickness:
    • Users can now adjust the thickness of both back and side walls of the 3D charts for better customization.
  • Sunburst chart now supports multi-level categories to provide a more detailed and hierarchical representation of data.
  • Added support for 3-D rotation.
  • Added text orientation support for DisplayUnits:
    • Improvements have been made to configure the text orientation of display unit labels using the DisplayUnitLabel.Orientation API. 
    • Now accepts integer values from -90 to 90 degrees to set a specific text angle for the text on the display unit label.
• Now enables tool-tip shadows and rounded corners in Windows 11.
• Adds suspended 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.