Spread.NET 11 Service Pack 1 is Released

I'm happy to announce the release of Spread.NET 11.45.20181.0 (Service Pack 1)! 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 impact your applications.

Important breaking changes in Spread.NET 11 components and controls

The minimum target framework version has changed from .NET 4.0 to .NET 4.5.2. Microsoft has dropped support for older framework versions and implemented support for "quirking" in the latest supported frameworks. This change affects all assemblies of Spread.NET 11 and all components and controls.

Important breaking changes in Spread.NET 11 for Windows Forms

The default BackColor of DefaultStyleCollection.DataAreaDefault 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 changed to DragFillMode.ControlCopy. This change makes the control default fill cells with series patterns and copy cells when Ctrl is pressed, as in Microsoft Excel.

The default value of FpSpread.DragFillDataOnly changed to false. This change makes 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 overrides the built-in TEXT function:

    fpSpread1.AddCustomFunction(new GrapeCity.Spreadsheet.Win.TextFunction());

New feature in Spread.NET 11 for Windows Forms

Enhanced row filter user interface now supports filtering by Color on "No Fill," like Excel.

New feature in Spread.NET 11 for ASP.NET

To reduce the view state size for cases with many hidden cells, the new property AllowGenerateHiddenData can be set to false. This property is much more powerful than AllowGetAllHiddenValue -- when AllowGenerateHiddenData is set to false, then all hidden values in the sheet are kept server-side, reducing the size of view state and also improving the security of the page for cases where the hidden values on the sheet are sensitive and should be kept server-side. In that case, the client-side APIs GetHiddenValue and GetHiddenCellValue will not work.

For a detailed listing of fixed issues, please see the Release Notes for each platform.

Get Spread.NET 11 Service Pack 1 now