SpreadsheetGear 2017
WorkbookView Class Members
Fields  Properties  Methods  Events


SpreadsheetGear.Windows.Controls Namespace : WorkbookView Class

The following tables list the members exposed by WorkbookView.

Public Constructors
 NameDescription
Public ConstructorWorkbookView ConstructorOverloaded.   
Top
Public Fields
 NameDescription
Public Fieldstatic (Shared in Visual Basic)ActiveWorkbookSetProperty  
Public Fieldstatic (Shared in Visual Basic)ColumnHeaderStyleProperty  
Public Fieldstatic (Shared in Visual Basic)GridlineBrushProperty  
Public Fieldstatic (Shared in Visual Basic)RangeSelectionBorderBrushProperty  
Public Fieldstatic (Shared in Visual Basic)RangeSelectionBrushProperty  
Public Fieldstatic (Shared in Visual Basic)RowColumnResizerBrushProperty  
Public Fieldstatic (Shared in Visual Basic)RowHeaderStyleProperty  
Public Fieldstatic (Shared in Visual Basic)SheetExtraBrushProperty  
Public Fieldstatic (Shared in Visual Basic)SheetTabScrollButtonStyleProperty  
Public Fieldstatic (Shared in Visual Basic)SheetTabStyleProperty  
Public Fieldstatic (Shared in Visual Basic)WindowBrushProperty  
Public Fieldstatic (Shared in Visual Basic)WindowTextBrushProperty  
Public Fieldstatic (Shared in Visual Basic)WorkbookSetStateProperty  
Top
Public Properties
 NameDescription
Public PropertyActiveCellReturns the active cell of the active worksheet or null if there is no active worksheet.  
Public PropertyActiveCommandManagerReturns the CommandManager associated with the ActiveWorkbookSet of this workbook view.  
Public PropertyActiveSheetGets or sets the active sheet.  
Public PropertyActiveTabIndexGets or sets the active tab index.  
Public PropertyActiveWorkbookGets or sets the active workbook.  
Public PropertyActiveWorkbookSetGets or sets the workbook set associated with this workbook view.  
Public PropertyActiveWorkbookWindowInfoReturns the window information for the active workbook or null if there is no active workbook.  
Public PropertyActiveWorksheetGets or sets the active worksheet.  
Public PropertyActiveWorksheetWindowInfoReturns the window information for the active worksheet or null if there is no active worksheet.  
Public PropertyActualHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyActualWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyAllowDrop (Inherited from System.Windows.UIElement)
Public PropertyAllowEditCommands

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

 
Public PropertyBackground (Inherited from System.Windows.Controls.Control)
Public PropertyBackgroundCalculationGets or sets the property which specifies whether background calculation is enabled for the workbook set.  
Public PropertyBorderBrush (Inherited from System.Windows.Controls.Control)
Public PropertyBorderThickness (Inherited from System.Windows.Controls.Control)
Public PropertyCacheMode (Inherited from System.Windows.UIElement)
Public PropertyCharacterSpacing (Inherited from System.Windows.Controls.Control)
Public PropertyClip (Inherited from System.Windows.UIElement)
Public PropertyColumnHeaderStyle  
Public PropertyCursor (Inherited from System.Windows.FrameworkElement)
Public PropertyDataContext (Inherited from System.Windows.FrameworkElement)
Public PropertyDesiredSize (Inherited from System.Windows.UIElement)
Public PropertyDispatcher (Inherited from System.Windows.DependencyObject)
Public PropertyDisplayReferenceGets or sets the property which specifies which workbook or set of cell ranges to display in the workbook view.  
Public PropertyDisplayReferenceName

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

 
Public PropertyEffect (Inherited from System.Windows.UIElement)
Public PropertyFlowDirection (Inherited from System.Windows.FrameworkElement)
Public PropertyFontFamily (Inherited from System.Windows.Controls.Control)
Public PropertyFontSize (Inherited from System.Windows.Controls.Control)
Public PropertyFontStretch (Inherited from System.Windows.Controls.Control)
Public PropertyFontStyle (Inherited from System.Windows.Controls.Control)
Public PropertyFontWeight (Inherited from System.Windows.Controls.Control)
Public PropertyForeground (Inherited from System.Windows.Controls.Control)
Public PropertyFormulaBarGets or sets the formula bar associated with this workbook view.  
Public PropertyGridlineBrush  
Public PropertyHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyHollowSelectionGets 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 PropertyHorizontalAlignment (Inherited from System.Windows.FrameworkElement)
Public PropertyHorizontalContentAlignment (Inherited from System.Windows.Controls.Control)
Public PropertyIsEditingGets the property which specifies whether the control is currently in edit mode.  
Public PropertyIsEnabled (Inherited from System.Windows.Controls.Control)
Public PropertyIsHitTestVisible (Inherited from System.Windows.UIElement)
Public PropertyIsTabStop (Inherited from System.Windows.Controls.Control)
Public PropertyLanguage (Inherited from System.Windows.FrameworkElement)
Public PropertyMargin (Inherited from System.Windows.FrameworkElement)
Public PropertyMaxHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyMaxWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyMinHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyMinWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyName (Inherited from System.Windows.FrameworkElement)
Public PropertyOpacity (Inherited from System.Windows.UIElement)
Public PropertyOpacityMask (Inherited from System.Windows.UIElement)
Public PropertyPadding (Inherited from System.Windows.Controls.Control)
Public PropertyParent (Inherited from System.Windows.FrameworkElement)
Public PropertyProjection (Inherited from System.Windows.UIElement)
Public PropertyRangeSelectionGets or sets the selected range.  
Public PropertyRangeSelectionBorderBrush  
Public PropertyRangeSelectionBrush  
Public PropertyRenderSize (Inherited from System.Windows.UIElement)
Public PropertyRenderTransform (Inherited from System.Windows.UIElement)
Public PropertyRenderTransformOrigin (Inherited from System.Windows.UIElement)
Public PropertyResources (Inherited from System.Windows.FrameworkElement)
Public PropertyRowColumnResizerBrush  
Public PropertyRowHeaderStyle  
Public PropertyShapeSelectionGets or sets the selected shape range.  
Public PropertySheetExtraBrush  
Public PropertySheetTabScrollButtonStyle  
Public PropertySheetTabStyle  
Public PropertyStyle (Inherited from System.Windows.FrameworkElement)
Public PropertyTabIndex (Inherited from System.Windows.Controls.Control)
Public PropertyTabNavigation (Inherited from System.Windows.Controls.Control)
Public PropertyTag (Inherited from System.Windows.FrameworkElement)
Public PropertyTemplate (Inherited from System.Windows.Controls.Control)
Public PropertyTriggers (Inherited from System.Windows.FrameworkElement)
Public PropertyUseLayoutRounding (Inherited from System.Windows.UIElement)
Public PropertyVerticalAlignment (Inherited from System.Windows.FrameworkElement)
Public PropertyVerticalContentAlignment (Inherited from System.Windows.Controls.Control)
Public PropertyVisibility (Inherited from System.Windows.UIElement)
Public PropertyWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyWindowBrush  
Public PropertyWindowTextBrush  
Public PropertyWorkbookSetState  
Top
Protected Properties
 NameDescription
Protected PropertyDefaultStyleKey (Inherited from System.Windows.Controls.Control)
Top
Public Methods
 NameDescription
Public MethodAddHandler (Inherited from System.Windows.UIElement)
Public MethodApplyTemplate (Inherited from System.Windows.Controls.Control)
Public MethodArrange (Inherited from System.Windows.UIElement)
Public MethodBeginEditPuts the active cell or selected textbox in edit mode.  
Public MethodBeginUpdateInterrupts 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.  
Public MethodCancelEditCancels edit mode and discards any changes.  
Public MethodCaptureMouse (Inherited from System.Windows.UIElement)
Public MethodClearValue (Inherited from System.Windows.DependencyObject)
Public MethodCopyCopy the contents of the current selection to the clipboard.  
Public MethodCutCut the contents of the current selection to the clipboard.  
Public MethodDispose  
Public MethodEndEditEnds edit mode and commits any changes.  
Public MethodEndUpdateRestores 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.  
Public MethodFindName (Inherited from System.Windows.FrameworkElement)
Public MethodFocus (Inherited from System.Windows.Controls.Control)
Public MethodGetAnimationBaseValue (Inherited from System.Windows.DependencyObject)
Public MethodGetBindingExpression (Inherited from System.Windows.FrameworkElement)
Public MethodGetLockInterrupts background calculation if necessary and acquires an exclusive lock on the workbook set associated with this WorkbookView.  
Public MethodGetValue (Inherited from System.Windows.DependencyObject)
Public MethodInvalidateArrange (Inherited from System.Windows.UIElement)
Public MethodInvalidateMeasure (Inherited from System.Windows.UIElement)
Public MethodLocationToRangeOverloaded. Returns the fractional zero based row and column indexes representing the cell at the specified location.  
Public MethodMeasure (Inherited from System.Windows.UIElement)
Public MethodOnApplyTemplateOverridden.   
Public MethodPastePaste the clipboard contents to the current selection.  
Public MethodPasteSpecialPaste the clipboard contents to the current selection using the specified options.  
Public MethodPrintOverloaded. Prints the active sheet.  
Public MethodPrintPreviewOverloaded. Shows a print preview of the active sheet.  
Public MethodRangeToLocationOverloaded. Returns the screen coordinates of the fractional zero based row and columns.  
Public MethodReadLocalValue (Inherited from System.Windows.DependencyObject)
Public MethodReleaseLockReleases a lock acquired with WorkbookView.GetLock and starts background calculation if appropriate.  
Public MethodReleaseMouseCapture (Inherited from System.Windows.UIElement)
Public MethodRemoveHandler (Inherited from System.Windows.UIElement)
Public MethodRewindLockInterrupts background calculation if necessary and restores locks to the state they were in before WorkbookView.UnwindLock was called.  
Public MethodSetBinding (Inherited from System.Windows.FrameworkElement)
Public MethodSetValue (Inherited from System.Windows.DependencyObject)
Public MethodTransformToVisual (Inherited from System.Windows.UIElement)
Public MethodUnwindLockUnwinds the locks for the workbook set associated with this workbook view.  
Public MethodUpdateLayout (Inherited from System.Windows.UIElement)
Public MethodWithLockOverloaded. Acquires a lock with WorkbookView.GetLock, calls the specified delegate and then calls WorkbookView.ReleaseLock.  
Top
Protected Methods
 NameDescription
Protected MethodArrangeOverrideOverridden.   
Protected MethodGetTemplateChild (Inherited from System.Windows.Controls.Control)
Protected MethodMeasureOverride (Inherited from System.Windows.FrameworkElement)
Protected MethodOnActiveTabChangedRaises the WorkbookView.ActiveTabChanged event.  
Protected MethodOnActiveTabChangingRaises the WorkbookView.ActiveTabChanging event.  
Protected MethodOnCalculateRaises the WorkbookView.Calculate event.  
Protected MethodOnCellBeginEditRaises the WorkbookView.CellBeginEdit event.  
Protected MethodOnCellCancelEditRaises the WorkbookView.CellCancelEdit event.  
Protected MethodOnCellEndEditRaises the WorkbookView.CellEndEdit event.  
Protected MethodOnCreateAutomationPeer (Inherited from System.Windows.UIElement)
Protected MethodOnDragEnter (Inherited from System.Windows.Controls.Control)
Protected MethodOnDragLeave (Inherited from System.Windows.Controls.Control)
Protected MethodOnDragOver (Inherited from System.Windows.Controls.Control)
Protected MethodOnDrop (Inherited from System.Windows.Controls.Control)
Protected MethodOnGotFocusOverridden.   
Protected MethodOnKeyDownOverridden.   
Protected MethodOnKeyUpOverridden.   
Protected MethodOnLostFocusOverridden.   
Protected MethodOnLostMouseCaptureOverridden.   
Protected MethodOnMouseEnterOverridden.   
Protected MethodOnMouseLeaveOverridden.   
Protected MethodOnMouseLeftButtonDownOverridden.   
Protected MethodOnMouseLeftButtonUpOverridden.   
Protected MethodOnMouseMoveOverridden.   
Protected MethodOnMouseRightButtonDown (Inherited from System.Windows.Controls.Control)
Protected MethodOnMouseRightButtonUp (Inherited from System.Windows.Controls.Control)
Protected MethodOnMouseWheelOverridden.   
Protected MethodOnRangeChangedRaises the WorkbookView.RangeChanged event.  
Protected MethodOnRangeSelectionChangedRaises the WorkbookView.RangeSelectionChanged event.  
Protected MethodOnRangeSelectionChangingRaises the WorkbookView.RangeSelectionChanging event.  
Protected MethodOnScrollPositionChangedRaises the WorkbookView.ScrollPositionChanged event.  
Protected MethodOnShapeActionRaises the WorkbookView.ShapeAction event.  
Protected MethodOnShapeSelectionChangedRaises the WorkbookView.ShapeSelectionChanged event.  
Protected MethodOnShapeSelectionChangingRaises the WorkbookView.ShapeSelectionChanging event.  
Protected MethodOnShowErrorRaises the ShowError event.  
Protected MethodOnTextInputOverridden.   
Protected MethodOnTextInputStart (Inherited from System.Windows.Controls.Control)
Protected MethodOnTextInputUpdate (Inherited from System.Windows.Controls.Control)
Top
Public Events
 NameDescription
Public EventActiveTabChangedOccurs after the active tab changes.  
Public EventActiveTabChangingOccurs when the user is attempting to change the active tab and provides the ability to cancel the change.  
Public EventBindingValidationError (Inherited from System.Windows.FrameworkElement)
Public EventCalculateOccurs sometime after calculation of the workbook set associated with the workbook view control has completed.  
Public EventCellBeginEditOccurs when edit mode is being initiated.  
Public EventCellCancelEditOccurs when edit mode is being canceled and provides the ability to force edit mode to continue by cancelling the event.  
Public EventCellEndEditOccurs when edit mode is ending and provides the ability to force edit mode to continue by cancelling the event.  
Public EventDataContextChanged (Inherited from System.Windows.FrameworkElement)
Public EventDragEnter (Inherited from System.Windows.UIElement)
Public EventDragLeave (Inherited from System.Windows.UIElement)
Public EventDragOver (Inherited from System.Windows.UIElement)
Public EventDrop (Inherited from System.Windows.UIElement)
Public EventGotFocus (Inherited from System.Windows.UIElement)
Public EventIsEnabledChanged (Inherited from System.Windows.Controls.Control)
Public EventKeyDown (Inherited from System.Windows.UIElement)
Public EventKeyUp (Inherited from System.Windows.UIElement)
Public EventLayoutUpdated (Inherited from System.Windows.FrameworkElement)
Public EventLoaded (Inherited from System.Windows.FrameworkElement)
Public EventLostFocus (Inherited from System.Windows.UIElement)
Public EventLostMouseCapture (Inherited from System.Windows.UIElement)
Public EventMediaCommand (Inherited from System.Windows.UIElement)
Public EventMouseEnter (Inherited from System.Windows.UIElement)
Public EventMouseLeave (Inherited from System.Windows.UIElement)
Public EventMouseLeftButtonDown (Inherited from System.Windows.UIElement)
Public EventMouseLeftButtonUp (Inherited from System.Windows.UIElement)
Public EventMouseMove (Inherited from System.Windows.UIElement)
Public EventMouseRightButtonDown (Inherited from System.Windows.UIElement)
Public EventMouseRightButtonUp (Inherited from System.Windows.UIElement)
Public EventMouseWheel (Inherited from System.Windows.UIElement)
Public EventRangeChangedOccurs sometime after an SpreadsheetGear.IRange property setter or method changes one or more of the cells in the range.  
Public EventRangeSelectionChangedOccurs after the range selection changes.  
Public EventRangeSelectionChangingOccurs when the user is attempting to change the range selection and provides the ability to cancel the change.  
Public EventScrollPositionChangedOccurs when the scroll position changes.  
Public EventShapeActionOccurs when a shape action happens.  
Public EventShapeSelectionChangedOccurs after the shape selection changes.  
Public EventShapeSelectionChangingOccurs when the user is attempting to change the shape selection and provides the ability to cancel the change.  
Public EventShowErrorThis event is sent to the active WorkbookView just before an error message is to be displayed to the user.  
Public EventSizeChanged (Inherited from System.Windows.FrameworkElement)
Public EventTextInput (Inherited from System.Windows.UIElement)
Public EventTextInputStart (Inherited from System.Windows.UIElement)
Public EventTextInputUpdate (Inherited from System.Windows.UIElement)
Public EventUnloaded (Inherited from System.Windows.FrameworkElement)
Top
See Also

Reference

WorkbookView Class
SpreadsheetGear.Windows.Controls Namespace
FormulaBar Property
DisplayReference Property

 

 

See our live ASP.NET Excel Reporting, Excel Charting, Dashboards from Charts and Ranges, Excel Calculation and Excel to DataGrid Samples.

Copyright © 2003-2020 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear® is a registered trademark and Spreadsheet Gear is a trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel, Visual Studio and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Send Feedback