SpreadsheetGear 2017
Workbook Views
SpreadsheetGear 2017 > Tutorials > Key Concepts > Workbook Views

The SpreadsheetGear family of products includes WorkbookView controls for Windows Forms, WPF and Silverlight which each provide a highly functional spreadsheet control.

WorkbookView controls support rich functionality including familiar keyboard and mouse selections, in-cell editing, a FormulaBar control, go to, find, replace, auto fill, autofilters, sort, cut, copy, paste, print, clear, undo, redo, charts, pictures, cell comments, conditional formats, grouping and outlining, data validation, goal seeking, text objects, form controls, autoshapes, interruptible background calculation, real-time workbook updates, multiple workbooks, Display Reference, Workbook Designer, Workbook Explorer, Range Explorer, Chart Explorer, Shape Explorer and much more.

Note that the Workbook Designer and all dialog boxes such as the Workbook Explorer, Range Explorer, Chart Explorer, Shape Explorer, goto, find, etc... require SpreadsheetGear2017.Windows.Forms.dll and SpreadsheetGear2017.Drawing.dll. These are automatically included in any project which uses the Windows Forms WorkbookView control.

The WPF WorkbookView control will automatically utilize the Workbook Designer and dialogs if you also include SpreadsheetGear2017.Windows.Forms.dll, SpreadsheetGear2017.Drawing.dll and SpreadsheetGear2017.Windows.Forms.Integration.dll in your project.

The Silverlight WorkbookView control cannot utilize the Workbook Designer and dialog boxes at runtime and is therefore limited to functionality which does not require them. The Silverlight control is also limited to using keyboard shortcuts which are passed to it by the host browser.

See the Windows Forms, WPF and Silverlight tutorials to learn how to use the WorkbookView controls in Visual Studio.