SpreadsheetGear The Performance Spreadsheet Component Company 
WorkbookView Class
See Also  Members  
SpreadsheetGear.Windows.Forms Namespace : WorkbookView Class
Provides a fully functional spreadsheet control which supports rich functionality including familiar keyboard and mouse selections, in-cell editing, a FormulaBar control, goto, cut, copy, paste, clear, undo, redo, printing, interruptible background calculation, real time workbook updates, multiple workbooks, DisplayReference, WorkbookDesigner, WorkbookExplorer, RangeExplorerShapeExplorer and more.

Syntax

C# 
[DefaultEventAttribute("RangeSelectionChanged")]
[ToolboxBitmapAttribute()]
[DesignerAttribute(DesignerBaseTypeName="System.ComponentModel.Design.IDesigner", DesignerTypeName="SG.Windows.SS.WorkbookViewControlDesigner, SpreadsheetGear, Version=3.1.2.102, Culture=neutral, PublicKeyToken=39c186f5904944ec")]
public class WorkbookView : Control

Remarks

The WorkbookView control adheres to the standard Windows Forms threading model. Accessing any members of a WorkbookView must be done from the thread which created the WorkbookView.

For important information about the threading model of SpreadsheetGear for .NET see GetLock and ReleaseLock.

To modify the workbook(s) associated with a WorkbookView at design time, right click on the WorkbookView and select Workbook Designer. From the Workbook Designer, you can open, edit, format, save and close workbooks. The workbooks which are left open in the Workbook Designer when the designer is closed will be saved with the form containing the WorkbookView, and will be loaded into the workbook set associated with the WorkbookView when the form is created at run time.

The RangeSelection, ActiveCell, ActiveWorksheet, ActiveWorkbook and ActiveWorkbookSet properties are the most commonly used workbook view properties.

Use the DisplayReference and DisplayReferenceName properties to control which workbook or which worksheet ranges are displayed in the workbook view. The DisplayReference property provides the ability to display multiple workbooks in a single workbook view control, as well as the ability to limit what the user of the workbook view control is able to see.

The RangeChanged, RangeSelectionChanged and Calculate events are the most commonly used workbook view events.

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Windows.Forms.Control
            SpreadsheetGear.Windows.Forms.WorkbookView

Requirements

Namespace: SpreadsheetGear.Windows.Forms

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

Assembly: SpreadsheetGear (in SpreadsheetGear.dll)

See Also