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 see GetLock and SpreadsheetGear.IWorkbookSet.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.

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

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

Reference