The following tables list the members exposed by WorkbookView.
Public Constructors
| Name | Description | |
|---|---|---|
 | WorkbookView Constructor | Overloaded. |
Public Fields
Top
Public Properties
| Name | Description | |
|---|---|---|
 | ActiveCell | Returns the active cell of the active worksheet or null if there is no active worksheet. |
| ActiveCommandManager | Returns the CommandManager associated with the ActiveWorkbookSet of this workbook view. |
| ActiveSheet | Gets or sets the active sheet. |
| ActiveTabIndex | Gets or sets the active tab index. |
| ActiveWorkbook | Gets or sets the active workbook. |
| ActiveWorkbookSet | Gets or sets the workbook set associated with this workbook view. |
| ActiveWorkbookWindowInfo | Returns the window information for the active workbook or null if there is no active workbook. |
| ActiveWorksheet | Gets or sets the active worksheet. |
| ActiveWorksheetWindowInfo | Returns the window information for the active worksheet or null if there is no active worksheet. |
| ActualHeight | (Inherited from System.Windows.FrameworkElement) |
| ActualWidth | (Inherited from System.Windows.FrameworkElement) |
| AllowDrop | (Inherited from System.Windows.UIElement) |
| AllowEditCommands | Gets or sets the property which specifies whether various workbook editing commands can be executed with the keyboard. |
| Background | (Inherited from System.Windows.Controls.Control) |
| BackgroundCalculation | Gets or sets the property which specifies whether background calculation is enabled for the workbook set. |
| BorderBrush | (Inherited from System.Windows.Controls.Control) |
| BorderThickness | (Inherited from System.Windows.Controls.Control) |
| CacheMode | (Inherited from System.Windows.UIElement) |
| CharacterSpacing | (Inherited from System.Windows.Controls.Control) |
| Clip | (Inherited from System.Windows.UIElement) |
| ColumnHeaderStyle | |
| Cursor | (Inherited from System.Windows.FrameworkElement) |
| DataContext | (Inherited from System.Windows.FrameworkElement) |
| DesiredSize | (Inherited from System.Windows.UIElement) |
| Dispatcher | (Inherited from System.Windows.DependencyObject) |
| DisplayReference | Gets or sets the property which specifies which workbook or set of cell ranges to display in the workbook view. |
| DisplayReferenceName | Gets or sets the property which specifies the text to display on each of the "sheet tabs" of the workbook view. |
| Effect | (Inherited from System.Windows.UIElement) |
| FlowDirection | (Inherited from System.Windows.FrameworkElement) |
| FontFamily | (Inherited from System.Windows.Controls.Control) |
| FontSize | (Inherited from System.Windows.Controls.Control) |
| FontStretch | (Inherited from System.Windows.Controls.Control) |
| FontStyle | (Inherited from System.Windows.Controls.Control) |
| FontWeight | (Inherited from System.Windows.Controls.Control) |
| Foreground | (Inherited from System.Windows.Controls.Control) |
| FormulaBar | Gets or sets the formula bar associated with this workbook view. |
| GridlineBrush | |
| Height | (Inherited from System.Windows.FrameworkElement) |
| HollowSelection | Gets 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. |
| HorizontalAlignment | (Inherited from System.Windows.FrameworkElement) |
| HorizontalContentAlignment | (Inherited from System.Windows.Controls.Control) |
| IsEditing | Gets the property which specifies whether the control is currently in edit mode. |
| IsEnabled | (Inherited from System.Windows.Controls.Control) |
| IsHitTestVisible | (Inherited from System.Windows.UIElement) |
| IsTabStop | (Inherited from System.Windows.Controls.Control) |
| Language | (Inherited from System.Windows.FrameworkElement) |
| Margin | (Inherited from System.Windows.FrameworkElement) |
| MaxHeight | (Inherited from System.Windows.FrameworkElement) |
| MaxWidth | (Inherited from System.Windows.FrameworkElement) |
| MinHeight | (Inherited from System.Windows.FrameworkElement) |
| MinWidth | (Inherited from System.Windows.FrameworkElement) |
| Name | (Inherited from System.Windows.FrameworkElement) |
| Opacity | (Inherited from System.Windows.UIElement) |
| OpacityMask | (Inherited from System.Windows.UIElement) |
| Padding | (Inherited from System.Windows.Controls.Control) |
| Parent | (Inherited from System.Windows.FrameworkElement) |
| Projection | (Inherited from System.Windows.UIElement) |
| RangeSelection | Gets or sets the selected range. |
| RangeSelectionBorderBrush | |
| RangeSelectionBrush | |
| RenderSize | (Inherited from System.Windows.UIElement) |
| RenderTransform | (Inherited from System.Windows.UIElement) |
| RenderTransformOrigin | (Inherited from System.Windows.UIElement) |
| Resources | (Inherited from System.Windows.FrameworkElement) |
| RowColumnResizerBrush | |
| RowHeaderStyle | |
| ShapeSelection | Gets or sets the selected shape range. |
| SheetExtraBrush | |
| SheetTabScrollButtonStyle | |
| SheetTabStyle | |
| Style | (Inherited from System.Windows.FrameworkElement) |
| TabIndex | (Inherited from System.Windows.Controls.Control) |
| TabNavigation | (Inherited from System.Windows.Controls.Control) |
| Tag | (Inherited from System.Windows.FrameworkElement) |
| Template | (Inherited from System.Windows.Controls.Control) |
| Triggers | (Inherited from System.Windows.FrameworkElement) |
| UseLayoutRounding | (Inherited from System.Windows.UIElement) |
| VerticalAlignment | (Inherited from System.Windows.FrameworkElement) |
| VerticalContentAlignment | (Inherited from System.Windows.Controls.Control) |
| Visibility | (Inherited from System.Windows.UIElement) |
| Width | (Inherited from System.Windows.FrameworkElement) |
| WindowBrush | |
| WindowTextBrush | |
| WorkbookSetState |
Protected Properties
| Name | Description | |
|---|---|---|
 | DefaultStyleKey | (Inherited from System.Windows.Controls.Control) |
Public Methods
| Name | Description | |
|---|---|---|
 | AddHandler | (Inherited from System.Windows.UIElement) |
| ApplyTemplate | (Inherited from System.Windows.Controls.Control) |
| Arrange | (Inherited from System.Windows.UIElement) |
| BeginEdit | Puts the active cell or selected textbox in edit mode. |
| BeginUpdate | Interrupts background calculation if necessary, acquires an exclusive lock on the workbook set associated with this WorkbookView, and suspends painting and events until WorkbookView.EndUpdate is called. |
| CancelEdit | Cancels edit mode and discards any changes. |
| CaptureMouse | (Inherited from System.Windows.UIElement) |
| ClearValue | (Inherited from System.Windows.DependencyObject) |
| Copy | Copy the contents of the current selection to the clipboard. |
| Cut | Cut the contents of the current selection to the clipboard. |
| Dispose | |
| EndEdit | Ends edit mode and commits any changes. |
| EndUpdate | Restores painting and events to the state they were in before the last call to WorkbookView.BeginUpdate, releases the lock acquired by BeginUpdate, and starts background calculation if appropriate. |
| FindName | (Inherited from System.Windows.FrameworkElement) |
| Focus | (Inherited from System.Windows.Controls.Control) |
| GetAnimationBaseValue | (Inherited from System.Windows.DependencyObject) |
| GetBindingExpression | (Inherited from System.Windows.FrameworkElement) |
| GetLock | Interrupts background calculation if necessary and acquires an exclusive lock on the workbook set associated with this WorkbookView. |
| GetValue | (Inherited from System.Windows.DependencyObject) |
| InvalidateArrange | (Inherited from System.Windows.UIElement) |
| InvalidateMeasure | (Inherited from System.Windows.UIElement) |
| LocationToRange | Overloaded. Returns the fractional zero based row and column indexes representing the cell at the specified location. |
| Measure | (Inherited from System.Windows.UIElement) |
| OnApplyTemplate | Overridden. |
| Paste | Paste the clipboard contents to the current selection. |
| PasteSpecial | Paste the clipboard contents to the current selection using the specified options. |
| Overloaded. Prints the active sheet. | |
| PrintPreview | Overloaded. Shows a print preview of the active sheet. |
| RangeToLocation | Overloaded. Returns the screen coordinates of the fractional zero based row and columns. |
| ReadLocalValue | (Inherited from System.Windows.DependencyObject) |
| ReleaseLock | Releases a lock acquired with WorkbookView.GetLock and starts background calculation if appropriate. |
| ReleaseMouseCapture | (Inherited from System.Windows.UIElement) |
| RemoveHandler | (Inherited from System.Windows.UIElement) |
| RewindLock | Interrupts background calculation if necessary and restores locks to the state they were in before WorkbookView.UnwindLock was called. |
| SetBinding | (Inherited from System.Windows.FrameworkElement) |
| SetValue | (Inherited from System.Windows.DependencyObject) |
| TransformToVisual | (Inherited from System.Windows.UIElement) |
| UnwindLock | Unwinds the locks for the workbook set associated with this workbook view. |
| UpdateLayout | (Inherited from System.Windows.UIElement) |
Protected Methods
| Name | Description | |
|---|---|---|
 | ArrangeOverride | Overridden. |
| GetTemplateChild | (Inherited from System.Windows.Controls.Control) |
| MeasureOverride | (Inherited from System.Windows.FrameworkElement) |
| OnActiveTabChanged | Raises the WorkbookView.ActiveTabChanged event. |
| OnActiveTabChanging | Raises the WorkbookView.ActiveTabChanging event. |
| OnCalculate | Raises the WorkbookView.Calculate event. |
| OnCellBeginEdit | Raises the WorkbookView.CellBeginEdit event. |
| OnCellCancelEdit | Raises the WorkbookView.CellCancelEdit event. |
| OnCellEndEdit | Raises the WorkbookView.CellEndEdit event. |
| OnCreateAutomationPeer | (Inherited from System.Windows.UIElement) |
| OnDragEnter | (Inherited from System.Windows.Controls.Control) |
| OnDragLeave | (Inherited from System.Windows.Controls.Control) |
| OnDragOver | (Inherited from System.Windows.Controls.Control) |
| OnDrop | (Inherited from System.Windows.Controls.Control) |
| OnGotFocus | Overridden. |
| OnKeyDown | Overridden. |
| OnKeyUp | Overridden. |
| OnLostFocus | Overridden. |
| OnLostMouseCapture | Overridden. |
| OnMouseEnter | Overridden. |
| OnMouseLeave | Overridden. |
| OnMouseLeftButtonDown | Overridden. |
| OnMouseLeftButtonUp | Overridden. |
| OnMouseMove | Overridden. |
| OnMouseRightButtonDown | (Inherited from System.Windows.Controls.Control) |
| OnMouseRightButtonUp | (Inherited from System.Windows.Controls.Control) |
| OnMouseWheel | Overridden. |
| OnRangeChanged | Raises the WorkbookView.RangeChanged event. |
| OnRangeSelectionChanged | Raises the WorkbookView.RangeSelectionChanged event. |
| OnRangeSelectionChanging | Raises the WorkbookView.RangeSelectionChanging event. |
| OnScrollPositionChanged | Raises the WorkbookView.ScrollPositionChanged event. |
| OnShapeAction | Raises the WorkbookView.ShapeAction event. |
| OnShapeSelectionChanged | Raises the WorkbookView.ShapeSelectionChanged event. |
| OnShapeSelectionChanging | Raises the WorkbookView.ShapeSelectionChanging event. |
| OnShowError | Raises the ShowError event. |
| OnTextInput | Overridden. |
| OnTextInputStart | (Inherited from System.Windows.Controls.Control) |
| OnTextInputUpdate | (Inherited from System.Windows.Controls.Control) |
Public Events
| Name | Description | |
|---|---|---|
 | ActiveTabChanged | Occurs after the active tab changes. |
| ActiveTabChanging | Occurs when the user is attempting to change the active tab and provides the ability to cancel the change. |
| BindingValidationError | (Inherited from System.Windows.FrameworkElement) |
| Calculate | Occurs sometime after calculation of the workbook set associated with the workbook view control has completed. |
| CellBeginEdit | Occurs when edit mode is being initiated. |
| CellCancelEdit | Occurs when edit mode is being canceled and provides the ability to force edit mode to continue by cancelling the event. |
| CellEndEdit | Occurs when edit mode is ending and provides the ability to force edit mode to continue by cancelling the event. |
| DataContextChanged | (Inherited from System.Windows.FrameworkElement) |
| DragEnter | (Inherited from System.Windows.UIElement) |
| DragLeave | (Inherited from System.Windows.UIElement) |
| DragOver | (Inherited from System.Windows.UIElement) |
| Drop | (Inherited from System.Windows.UIElement) |
| GotFocus | (Inherited from System.Windows.UIElement) |
| IsEnabledChanged | (Inherited from System.Windows.Controls.Control) |
| KeyDown | (Inherited from System.Windows.UIElement) |
| KeyUp | (Inherited from System.Windows.UIElement) |
| LayoutUpdated | (Inherited from System.Windows.FrameworkElement) |
| Loaded | (Inherited from System.Windows.FrameworkElement) |
| LostFocus | (Inherited from System.Windows.UIElement) |
| LostMouseCapture | (Inherited from System.Windows.UIElement) |
| MediaCommand | (Inherited from System.Windows.UIElement) |
| MouseEnter | (Inherited from System.Windows.UIElement) |
| MouseLeave | (Inherited from System.Windows.UIElement) |
| MouseLeftButtonDown | (Inherited from System.Windows.UIElement) |
| MouseLeftButtonUp | (Inherited from System.Windows.UIElement) |
| MouseMove | (Inherited from System.Windows.UIElement) |
| MouseRightButtonDown | (Inherited from System.Windows.UIElement) |
| MouseRightButtonUp | (Inherited from System.Windows.UIElement) |
| MouseWheel | (Inherited from System.Windows.UIElement) |
| RangeChanged | Occurs sometime after an SpreadsheetGear.IRange property setter or method changes one or more of the cells in the range. |
| RangeSelectionChanged | Occurs after the range selection changes. |
| RangeSelectionChanging | Occurs when the user is attempting to change the range selection and provides the ability to cancel the change. |
| ScrollPositionChanged | Occurs when the scroll position changes. |
| ShapeAction | Occurs when a shape action happens. |
| ShapeSelectionChanged | Occurs after the shape selection changes. |
| ShapeSelectionChanging | Occurs when the user is attempting to change the shape selection and provides the ability to cancel the change. |
| ShowError | This event is sent to the active WorkbookView just before an error message is to be displayed to the user. |
| SizeChanged | (Inherited from System.Windows.FrameworkElement) |
| TextInput | (Inherited from System.Windows.UIElement) |
| TextInputStart | (Inherited from System.Windows.UIElement) |
| TextInputUpdate | (Inherited from System.Windows.UIElement) |
| Unloaded | (Inherited from System.Windows.FrameworkElement) |
See Also