What's New in Spread.NET v11
Spread.NET v11.2 - July 25, 2018
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());
Spread.NET v11.1 - April 25, 2018
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.
Spread.NET v11 - December 6, 2017
Performance Improvements
Spread.NET can handle your biggest, most complex spreadsheets, faster than ever before, and using less memory too – performance improvements up to 80% faster and using a fraction of the memory! Spread.NET 11 can import, export, and calculate your Excel documents faster than ever before.
462 functions now available
We've added more than 130 new calculation functions, bringing the total number to 462, more than any other spreadsheet solution. New support for array formulas (entered using Ctrl+Shift+Enter) enable advanced matrix and array calculations. The new CircularFormula event fires to inform the developer when the user enters a formula which creates a circular reference.
Workbook Protection Support
New workbook protection support allows you to set a password to protect the workbook structure and prevent the user from deleting or reordering sheets.
Cell validators and enhanced data validation
New cell validators and enhanced data validation support provide powerful new options to enforce user data entry requirements, and save and load data validations in Excel documents.
Drag-fill enhancements
New drag-fill enhancements implement Excel-like copy-fill and series-fill in the user interface, with full support for undo-redo.
Printing Enhancements
New printing enhancements include full support for printer settings built into the print preview user interface.
HyperLinkCellType Supports Sort and Filter
By popular request, the new enhanced HyperLinkCellType can now work well with sort and filter features.
New API with Document Properties
Finally, we have added new API to get and set the document properties (Title, Subject, Author, Manager, Company, etc.).
private void ClearDocumentProperties(FpSpread spread)
{
spread.DocumentProperties.Application = "";
spread.DocumentProperties.ApplicationVersion = "";
spread.DocumentProperties.Categories.Clear();
spread.DocumentProperties.Category = "";
spread.DocumentProperties.Company = "";
spread.DocumentProperties.ContentStatus = "";
spread.DocumentProperties.Creator = "";
spread.DocumentProperties.Creators.Clear();
spread.DocumentProperties.Description = "";
spread.DocumentProperties.HyperlinkBase = "";
spread.DocumentProperties.Keywords.Clear();
spread.DocumentProperties.Language = "";
}
ASP.NET Enhancements
Command Bar Buttons for PDF and Excel
The Spread.NET controls for ASP.NET support new command bar buttons for PDF export and Excel document export, with password options.
Move Rows Directly in the UI
ASP.NET controls now support moving rows directly in the user interface using drag-drop from a header cell.
Server Command Events in the Touch Menu
New server command events for Spread ASP.NET are supported for the touch menu interface.
Updates for Spread.NET v11
Spread.NET v11.2 - July 25, 2018
- Digital Signatures on DLLs
- Important Breaking Changes in Spread.NET 11 Components and Controls
- Important Breaking Changes in Spread.NET 11 for Windows Forms 11.45.20181.0 and 11.45.20183.0
Spread.NET v11.1 - April 25, 2018
- Important breaking changes in Spread.NET 11 components and controls
- Important breaking changes in Spread.NET 11 for Windows Forms
- New feature in Spread.NET 11 for Windows Forms
- New feature in Spread.NET 11 for ASP.NET
Spread.NET v11 - December 6, 2017
- Performance Improvements
- 462 Functions now available
- Workbook Protection Support
- Cell validators and enhanced data validation
- Drag-fill enhancements
- Printing enhancements
- HyperLinkCellType Supports Sort and Filter
- New API with Document Properties
- ASP.NET Enhancements
- Command Bar Buttons for PDF and Excel
- Move Rows Directly in the UI
- Server Command Events in the Touch Menu