SpreadsheetGear 2023
WorkbookView Class Members
Properties  Methods  Events


SpreadsheetGear.Windows.Forms Namespace : WorkbookView Class

The following tables list the members exposed by WorkbookView.

Public Constructors
 NameDescription
Public ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyReturns the active cell of the active worksheet or null if there is no active worksheet.  
Public PropertyGets or sets the active chart sheet.  
Public PropertyReturns the CommandManager associated with the ActiveWorkbookSet of this workbook view.  
Public PropertyGets or sets the active sheet.  
Public PropertyGets or sets the active tab index.  
Public PropertyGets or sets the active workbook.  
Public PropertyGets or sets the workbook set associated with this workbook view.  
Public PropertyReturns the window information for the active workbook or null if there is no active workbook.  
Public PropertyGets or sets the active worksheet.  
Public PropertyReturns the window information for the active worksheet or null if there is no active worksheet.  
Public PropertyGets or sets the property which specifies whether the Chart Explorer can be launched from the workbook view.  
Public Property

Gets or sets the property which specifies whether various workbook editing commands can be executed with the keyboard.

 
Public PropertyGets or sets the property which specifies whether the Range Explorer can be launched from the workbook view.  
Public PropertyGets or sets the property which specifies whether the Shape Explorer can be launched from the workbook view.  
Public PropertyGets or sets the property which specifies whether the Workbook Designer can be launched from the workbook view.  
Public PropertyGets or sets the property which specifies whether the Workbook Explorer can be launched from the workbook view.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the property which specifies whether background calculation is enabled for the workbook set.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.ComponentModel.Component)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the property which specifies which workbook or set of cell ranges to display in the workbook view.  
Public Property

Gets or sets the property which specifies the text to display on each of the "sheet tabs" of the workbook view.

 
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the color beyond the last row or column of the worksheet.  
Public PropertyOverridden.   
Public PropertyGets or sets the formula bar associated with this workbook view.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the property which determines whether selections are painted with a hollow interior. If this property is set to true then only the border of the selected range will be painted.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets the property which specifies whether the control is currently in edit mode.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the selected range.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the selected shape range.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property  
Top
Protected Properties
 NameDescription
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected PropertyOverridden.   
Protected Property (Inherited from System.ComponentModel.Component)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.ComponentModel.Component)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.Windows.Forms.Control)
Top
Public Methods
 NameDescription
Public MethodPuts the active cell or selected textbox in edit mode.  
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public MethodInterrupts background calculation if necessary, acquires an exclusive lock on the workbook set associated with this WorkbookView, and suspends painting and events until EndUpdate is called.  
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodCancels edit mode and discards any changes.  
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodCopy the contents of the current selection to the clipboard.  
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.MarshalByRefObject)
Public MethodCut the contents of the current selection to the clipboard.  
Public MethodOverloaded. Overridden.   
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodEnds edit mode and commits any changes.  
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodRestores painting and events to the state they were in before the last call to BeginUpdate, releases the lock acquired by BeginUpdate, and starts background calculation if appropriate.  
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.MarshalByRefObject)
Public MethodInterrupts background calculation if necessary and acquires an exclusive lock on the workbook set associated with this WorkbookView.  
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.MarshalByRefObject)
Public MethodOverloaded. Invalidates the cached WorkbookView drawing state and calls Control.Invalidate() which invalidates the surface of the WorkbookView and causes the WorkbookView to be redrawn. This causes the entire WorkbookView to be laid out and redrawn.  
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public MethodOverloaded. Returns the fractional zero based row and column indexes representing the cell at the specified location.  
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public MethodPaste the clipboard contents to the current selection.  
Public MethodPaste the clipboard contents to the current selection using the specified options.  
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodOverloaded. Prints the active sheet.  
Public MethodOverloaded. Shows a print preview of the active sheet.  
Public MethodOverloaded. Returns the screen coordinates of the fractional zero based row and columns.  
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodOverridden. Forces the control to invalidate its client area and immediately redraw itself and any child controls. This method does not invalidate cached WorkbookView drawing state - only WorkbookView.Invalidate will do that.  
Public MethodReleases a lock acquired with GetLock and starts background calculation if appropriate.  
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public MethodInterrupts background calculation if necessary and restores locks to the state they were in before UnwindLock was called.  
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.ComponentModel.Component)
Public MethodUnwinds the locks for the workbook set associated with this workbook view.  
Public MethodCauses the WorkbookView to update any invalid drawing state and calls Control.Update() which causes the WorkbookView to redraw any invalidated regions within the WorkbookView.  
Public MethodOverloaded. Acquires a lock with GetLock, calls the specified delegate and then calls WorkbookView.ReleaseLock.  
Top
Protected Methods
 NameDescription
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.ComponentModel.Component)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.ComponentModel.Component)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden.   
Protected MethodOverridden.   
Protected MethodOverloaded.  (Inherited from System.MarshalByRefObject)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the ActiveTabChanged event.  
Protected MethodRaises the ActiveTabChanging event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the Calculate event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the CellBeginEdit event.  
Protected MethodRaises the CellCancelEdit event.  
Protected MethodRaises the CellEndEdit event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden.   
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden.   
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden.   
Protected MethodOverridden.   
Protected MethodOverridden.   
Protected MethodOverridden.   
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden.   
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden.   
Protected MethodOverridden.   
Protected MethodOverridden.   
Protected MethodOverridden.   
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden.   
Protected MethodOverridden.   
Protected MethodOverridden.   
Protected MethodOverridden.   
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden.   
Protected MethodOverridden.   
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the RangeChanged event.  
Protected MethodRaises the RangeSelectionChanged event.  
Protected MethodRaises the RangeSelectionChanging event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the ScrollPositionChanged event.  
Protected MethodRaises the ShapeAction event.  
Protected MethodRaises the ShapeSelectionChanged event.  
Protected MethodRaises the ShapeSelectionChanging event.  
Protected MethodRaises the ShowError event.  
Protected MethodOverridden.   
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden.   
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Top
Public Events
 NameDescription
Public EventOccurs after the active tab changes.  
Public EventOccurs when the user is attempting to change the active tab and provides the ability to cancel the change.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs sometime after calculation of the workbook set associated with the workbook view control has completed.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when edit mode is being initiated.  
Public EventOccurs when edit mode is being canceled and provides the ability to force edit mode to continue by cancelling the event.  
Public EventOccurs when edit mode is ending and provides the ability to force edit mode to continue by cancelling the event.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.ComponentModel.Component)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs sometime after an SpreadsheetGear.IRange property setter or method changes one or more of the cells in the range.  
Public EventOccurs after the range selection changes.  
Public EventOccurs when the user is attempting to change the range selection and provides the ability to cancel the change.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the scroll position changes.  
Public EventOccurs when a shape action happens.  
Public EventOccurs after the shape selection changes.  
Public EventOccurs when the user is attempting to change the shape selection and provides the ability to cancel the change.  
Public EventThis event is sent to the active WorkbookView just before an error message is to be displayed to the user.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Top
See Also

Reference

WorkbookView Class
SpreadsheetGear.Windows.Forms Namespace
FormulaBar Property
DisplayReference Property
WorkbookDesigner Class