Now shipping: Spread.NET 11, Service Pack 2

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.

Digital Signatures on DLLs

Starting with this release, each assembly of Spread.NET 11 will be signed with the GrapeCity digital signature.

Important Breaking Changes in Spread.NET 11 Components and Controls

• The minimum target framework version is changed from .NET 4.0 to .NET 4.5.2. Microsoft has dropped support for .NET 4.0, 4.5, and 4.5.1 and implemented support for "quirking" in the latest supported frameworks. This change affects all assemblies of Spread.NET 11. Learn more.

Important Breaking Changes in Spread.NET 11 for Windows Forms 11.45.20181.0 and 11.45.20183.0

• 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.