SpreadsheetGear
WorkbookView Class
Members  See Also  Send Feedback
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, RangeExplorerChartExplorerShapeExplorer and more.

Syntax

Visual Basic (Declaration) 
<DesignerAttribute(DesignerBaseTypeName="System.ComponentModel.Design.IDesigner", DesignerTypeName="SG.Windows.SS.WorkbookViewControlDesigner, SpreadsheetGear, Version=5.1.1.198, Culture=neutral, PublicKeyToken=39c186f5904944ec")>
<ToolboxBitmapAttribute()>
<DefaultEventAttribute("RangeSelectionChanged")>
Public Class WorkbookView 
   Inherits Control
C# 
[DesignerAttribute(DesignerBaseTypeName="System.ComponentModel.Design.IDesigner", DesignerTypeName="SG.Windows.SS.WorkbookViewControlDesigner, SpreadsheetGear, Version=5.1.1.198, Culture=neutral, PublicKeyToken=39c186f5904944ec")]
[ToolboxBitmapAttribute()]
[DefaultEventAttribute("RangeSelectionChanged")]
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 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: x86 and x64 versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2). SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

Assembly: SpreadsheetGear (in SpreadsheetGear.dll)

See Also

Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.