I'm happy to announce the release of Spread.NET 11.45.20183.0 (Service Pack 2)! This release features a number of very important changes to the Windows Forms control, and all users who are upgrading from previous releases to this release need to be aware of these changes and how they'll affect your applications. Some changes which have already been introduced in the Service Pack 1 release (covered in detail here) are included here again because of the importance of the change.
Starting with this release, each assembly of Spread.NET 11 will be signed with the GrapeCity digital signature.
The default BackColor of DefaultStyleCollection.DataAreaDefault is changed from SystemColors.Window to Color.Empty. This change is part of the new feature support for "No Fill" color filtering (see below).
The default value of FpSpread.RangeDragFillMode is changed to DragFillMode.ControlCopy. This change will make the control default to fill cells with series patterns and copy cells when Ctrl is pressed, as in Microsoft Excel.
The default value of FpSpread.DragFillDataOnly is changed to false. This change will make the control default to fill cells with style settings as well as values and formulas.
The TEXT calculation function now uses Excel syntax for formatting values instead of .NET syntax for improved Excel-like behavior. To get the old behavior back, using .NET format syntax for formatting values, you can use this code to add the old TEXT function back as a custom function, which will override the built-in TEXT function:
fpSpread1.AddCustomFunction(new GrapeCity.Spreadsheet.Win.TextFunction());
For a detailed listing of fixed issues, please see the Release Notes for each platform.