MindFusion.Spreadsheet.Wpf.WorkbookView Members

Represents a control that can display Workbook objects.

The following tables list the members exposed by the WorkbookView type.

Public Constructors

	Name	Description
	WorkbookView	Initializes a new instance of the WorkbookView class.

Public Fields

	Name	Description
	AdjustmentHandleBackgroundProperty	Identifies the AdjustmentHandleBackground dependency property.
	AdjustmentHandleBorderBrushProperty	Identifies the AdjustmentHandleBorderBrush dependency property.
	AdjustmentHandleSizeProperty	Identifies the AdjustmentHandleSize dependency property.
	AllowAutoFillProperty	Identifies the AllowAutoFill dependency property.
	AllowMoveCellsProperty	Identifies the AllowMoveCells dependency property.
	AllowMoveHeadersProperty	Identifies the AllowMoveHeaders dependency property.
	AutoFillCopyOnlyProperty	Identifies the AutoFillCopyOnly dependency property.
	AutoFillCursorProperty	Identifies the AutoFillCursor dependency property.
	AutoScrollProperty	Identifies the AutoScroll dependency property.
	CounterDiagonalResizeCursorProperty	Identifies the CounterDiagonalResizeCursor dependency property.
	DiagonalResizeCursorProperty	Identifies the DiagonalResizeCursor dependency property.
	DisallowCursorProperty	Identifies the DisallowCursor dependency property.
	DrawFilledCellBordersProperty	Identifies the DrawFilledCellBorders dependency property.
	FormulaToolTipTemplateProperty	Identifies the FormulaToolTipTemplate dependency property.
	HeaderMoveIndicatorBrushProperty	Identifies the HeaderMoveIndicatorBrush dependency property.
	HeaderResizeIndicatorBrushProperty	Identifies the HeaderResizeIndicatorBrush dependency property.
	HorizontalResizeCursorProperty	Identifies the HorizontalResizeCursor dependency property.
	HorizontalSplitCursorProperty	Identifies the HorizontalSplitCursor dependency property.
	HScrollToolTipFormatProperty	Identifies the HScrollToolTipFormat dependency property.
	HyperlinkCursorProperty	Identifies the HyperlinkCursor dependency property.
	MoveCursorProperty	Identifies the MoveCursor dependency property.
	PointerCursorProperty	Identifies the PointerCursor dependency property.
	ResizeColumnToolTipFormatProperty	Identifies the ResizeColumnToolTipFormat dependency property.
	ResizeHeaderToolTipTemplateProperty	Identifies the ResizeHeaderToolTipTemplate dependency property.
	ResizeRowToolTipFormatProperty	Identifies the ResizeRowToolTipFormat dependency property.
	ScrollToolTipTemplateProperty	Identifies the ScrollToolTipTemplate dependency property.
	ScrollXProperty	Identifies the ScrollX dependency property.
	ScrollYProperty	Identifies the ScrollY dependency property.
	ScrollZoneSizeProperty	Identifies the ScrollZoneSize dependency property.
	ShowCreateNewTabProperty	Identifies the ShowCreateNewTab dependency property.
	ShowFormulaBoxProperty	Identifies the ShowFormulaBox dependency property.
	ShowGridLinesProperty	Identifies the ShowGridLines dependency property.
	ShowHeadersProperty	Identifies the ShowHeaders dependency property.
	ShowHiddenHeaderIndicatorsProperty	Identifies the ShowHiddenHeaderIndicators dependency property.
	ShowNavigationButtonsProperty	Identifies the ShowNavigationButtons dependency property.
	ShowScrollToolTipsProperty	Identifies the ShowScrollToolTips dependency property.
	ToolTipTemplateProperty	Identifies the ToolTipTemplate dependency property.
	ValidationToolTipTemplateProperty	Identifies the ValidationToolTipTemplate dependency property.
	VerticalResizeCursorProperty	Identifies the VerticalResizeCursor dependency property.
	VerticalSplitCursorProperty	Identifies the VerticalSplitCursor dependency property.
	VScrollToolTipFormatProperty	Identifies the VScrollToolTipFormat dependency property.
	WorkbookProperty	Identifies the Workbook dependency property.

Public Properties

	Name	Description
	ActiveCell	Gets or sets the currently active cell.
	ActiveWorksheet	Gets or sets the currently active worksheet.
	AdjustmentHandleBackground	Gets or sets the background brush of the adjustment handles of selected interactive objects. This is a dependency property.
	AdjustmentHandleBorderBrush	Gets or sets the border brush of the adjustment handles of selected interactive objects. This is a dependency property.
	AdjustmentHandleSize	Gets or sets the size, in pixels, of the adjustment handles of selected interactive objects. This is a dependency property.
	AllowAutoFill	Gets or sets a value indicating whether to display the auto-fill handle at the bottom-right side of the selection. This is a dependency property.
	AllowMoveCells	Gets or sets a value indicating whether the user can interactively move cells around the worksheet, by pressing near the edge of the currently selected cells with the mouse and dragging. This is a dependency property.
	AllowMoveHeaders	Gets or sets a value indicating whether the user can interactively move the worksheet headers, by selecting the entire column or row and dragging. This is a dependency property.
	AutoFillCopyOnly	Gets or sets whether the auto-fill tool should only copy values, instead of extrapolating new values from the selection.
	AutoFillCursor	Gets or sets the mouse cursor shown to the user if the mouse is over the auto fill handle or the user is currently performing an auto fill operation. This is a dependency property.
	AutoScroll	Gets or sets a value indicating whether to automatically scroll the view while the user is dragging a selection or interactive object near or beyond the view border. This is a dependency property.
	CounterDiagonalResizeCursor	Gets or sets the mouse cursor shown to the user if dragging would resize an object both vertically and horizontally. This is a dependency property.
	DiagonalResizeCursor	Gets or sets the mouse cursor shown to the user if dragging would resize an object both vertically and horizontally. This is a dependency property.
	DisallowCursor	Gets or sets the mouse cursor shown to the user when an object cannot be created at a given location. This is a dependency property.
	DrawFilledCellBorders	Gets or sets a value indicating whether to draw the default grid lines for cells with set background. This is a dependency property.
	FormulaToolTipTemplate	Gets or sets the template of the tooltip displayed when the user is editing a formula. This is a dependency property.
	HeaderMoveIndicatorBrush	Gets or sets the brush uses to paint the header move indicators. This is a dependency property.
	HeaderResizeIndicatorBrush	Gets or sets the brush used to paint the header resize indicators. This is a dependency property.
	HorizontalResizeCursor	Gets or sets the mouse cursor shown to the user if dragging would resize an object horizontally. This is a dependency property.
	HorizontalSplitCursor	Gets or sets the mouse cursor shown to the user if dragging would resize rows. This is a dependency property.
	HScrollToolTipFormat	Gets or sets the format of the tooltip displayed when the user scrolls the view by dragging the horizontal scroll bar. This is a dependency property.
	HyperlinkCursor	Gets or sets the mouse cursor shown to the user if the mouse is over a cell containing a hyperlink. This is a dependency property.
	MoveCursor	Gets or sets the mouse cursor shown to the user if the pointed object can be modified. This is a dependency property.
	PointerCursor	Gets or sets the mouse cursor shown to the user when no modification is performed. This is a dependency property.
	ResizeColumnToolTipFormat	Gets or sets the format of the tooltip displayed when the user resizes columns. This is a dependency property.
	ResizeHeaderToolTipTemplate	Gets or sets the template of the tooltip displayed when the user resizes rows and columns. This is a dependency property.
	ResizeRowToolTipFormat	Gets or sets the format of the tooltip displayed when the user resizes rows. This is a dependency property.
	ScrollToolTipTemplate	Gets or sets the template of the tooltip displayed when the user scrolls the view. This is a dependency property.
	ScrollX	Gets or sets the position of the horizontal scrollbar. This is a dependency property.
	ScrollY	Gets or sets the position of the vertical scrollbar. This is a dependency property.
	ScrollZoneSize	Gets or sets the distance from the view border within which to start autoscrolling. This is a dependency property.
	Selection	Gets the selection in the view.
	ShowCreateNewTab	Gets or sets a value indicating whether to display the 'Create New Tab' button. This is a dependency property.
	ShowFormulaBox	Gets or sets a value indicating whether to display the formula text box. This is a dependency property.
	ShowGridLines	Gets or sets a value indicating whether to display the grid lines. This is a dependency property.
	ShowHeaders	Gets or sets a value indicating whether to display the row and column headers. This is a dependency property.
	ShowHiddenHeaderIndicators	Gets or sets a value indicating whether to display indicators for hidden row and column headers. This is a dependency property.
	ShowNavigationButtons	Gets or sets a value indicating whether to display the worksheet navigation buttons in the lower left corner of the view. This is a dependency property.
	ShowScrollToolTips	Gets or sets a value indicating whether to display tooltips when scrolling with the thumb. This is a dependency property.
	ToolTipTemplate	Gets or sets the template of the tooltip displayed when the user points a cell containing an error or a hyperlink with tooltip. This is a dependency property.
	ValidationToolTipTemplate	Gets or sets the template of the tooltip displayed when the user selects a cell containing a validation with a message. This is a dependency property.
	VerticalResizeCursor	Gets or sets the mouse cursor shown to the user if dragging would resize an object vertically. This is a dependency property.
	VerticalSplitCursor	Gets or sets the mouse cursor shown to the user if dragging would resize columns. This is a dependency property.
	VScrollToolTipFormat	Gets or sets the format of the tooltip displayed when the user scrolls the view by dragging the vertical scroll bar. This is a dependency property.
	Workbook	Gets or sets the workbook displayed in this view. This is a dependency property.

Public Methods

	Name	Description
	BeginEdit	Initiates in-place edit of the specified in-place editable object.
	Copy	Copies the current selection to the clipboard.
	Cut	Cuts the current selection to the clipboard.
	EndEdit	Completes the in-place editing operation, previously started by a call to BeginEdit, and accept or cancel the change.
	EnsureVisible	Scrolls the view so that the specified cell becomes visible.
	Freeze	Sets the FirstFrozenColumn, FirstFrozenRow, FrozenColumnCount, and FrozenRowCount properties of the current worksheet, so that the active cell is the first unfrozen cell.
	OnApplyTemplate	FrameworkElement.OnApplyTemplate override.
	Paste	Pastes the information from the clipboard at the active cell in the current worksheet.
	ResizeColumnsToFit	Resizes the columns in the specified range of the active worksheet to fit their content.
	ResizeColumnToFit	Resizes a view column to fit its contents.
	ResizeRowsToFit	Resizes the rows in the specified range of the active worksheet to fit their content.
	ResizeRowToFit	Resizes a view row to fit its contents.
	ToggleColumnOutline	Expands or collapses all groups at the specified outline level.
	ToggleRowOutline	Expands or collapses all groups at the specified outline level.
	Unfreeze	Unfreezes any frozen rows and columns in the current worksheet.

Protected Methods

	Name	Description
	MeasureOverride	Control.MeasureOverride override.
	OnActiveCellChanged	Raises the ActiveCellChanged event.
	OnActiveWorksheetChanged	Raises the ActiveWorksheetChanged event.
	OnCellClicked	Raises the CellClicked event.
	OnCellSelectionChanged	Raises the CellSelectionChanged event.
	OnColumnClicked	Raises the ColumnClicked event.
	OnColumnGroupCollapsed	Raises the ColumnGroupCollapsed event.
	OnColumnGroupExpanded	Raises the ColumnGroupExpanded event.
	OnColumnOutlineLevelToggled	Raises the ColumnOutlineLevelToggled event.
	OnColumnsMoved	Raises the ColumnsMoved event.
	OnColumnsMoving	Raises the ColumnsMoving event.
	OnColumnsResized	Raises the ColumnsResized event.
	OnColumnsResizing	Raises the ColumnsResizing event.
	OnHyperlinkClicked	Raises the HyperlinkClicked event.
	OnInplaceEditEnded	Raises the InplaceEditEnded event.
	OnInplaceEditEnding	Raises the InplaceEditEnding event.
	OnInplaceEditStarted	Raises the InplaceEditStarted event.
	OnInplaceEditStarting	Raises the InplaceEditStarting event.
	OnKeyDown	UIElement.OnKeyDown override.
	OnLostKeyboardFocus	UIElement.OnLostKeyboardFocus override.
	OnMouseDown	UIElement.OnMouseDown override.
	OnMouseMove	UIElement.OnMouseMove override.
	OnMouseUp	UIElement.OnMouseUp override.
	OnMouseWheel	UIElement.OnMouseWheel override.
	OnObjectClicked	Raises the ObjectClicked event.
	OnObjectDeleted	Raises the ObjectDeleted event.
	OnObjectDeleting	Raises the ObjectDeleting event.
	OnObjectDeselected	Raises the ObjectDeselected event.
	OnObjectModified	Raises the ObjectModified event.
	OnObjectModifyCancelled	Raises the ObjectModifyCancelled event.
	OnObjectModifying	Raises the ObjectModifying event.
	OnObjectSelected	Raises the ObjectSelected event.
	OnObjectSelecting	Raises the ObjectSelecting event.
	OnObjectStartModifying	Raises the ObjectStartModifying event.
	OnRowClicked	Raises the RowClicked event.
	OnRowGroupCollapsed	Raises the RowGroupCollapsed event.
	OnRowGroupExpanded	Raises the RowGroupExpanded event.
	OnRowOutlineLevelToggled	Raises the RowOutlineLevelToggled event.
	OnRowsMoved	Raises the RowsMoved event.
	OnRowsMoving	Raises the RowsMoving event.
	OnRowsResized	Raises the RowsResized event.
	OnRowsResizing	Raises the RowsResizing event.
	OnTextInput	UIElement.OnTextInput override.
	OnWorksheetTabClicked	Raises the WorksheetTabClicked event.

Public Events

	Name	Description
	ActiveCellChanged	Raised when the active cell is changed.
	ActiveWorksheetChanged	Raised when the currently active worksheet is changed.
	CellClicked	Raised when a cell is clicked.
	CellSelectionChanged	Raised when the selection is changed interactively, that is, modifying the selection programmatically does not raise this event.
	ColumnClicked	Raised when a column header is clicked.
	ColumnGroupCollapsed	Raised when a column group has been collapsed interactively.
	ColumnGroupExpanded	Raised when a column group has been expanded interactively.
	ColumnOutlineLevelToggled	Raised when a column outline level has been activated interactively.
	ColumnsMoved	Raised when one or more columns are moved interactively.
	ColumnsMoving	Raised when one or more columns are being moved interactively.
	ColumnsResized	Raised when one or more columns are resized interactively.
	ColumnsResizing	Raised when one or more columns are being resized interactively.
	HyperlinkClicked	Raised when a cell containing a hyperlink is clicked.
	InplaceEditEnded	Raised when an inplace-edit operation has finished.
	InplaceEditEnding	Raised when an in-place edit operation is about to finish, before the in-place editor is closed.
	InplaceEditStarted	Raised when an in-place edit operation has started, after the in-place editor is displayed.
	InplaceEditStarting	Raised when an in-place edit operation is about to start, before the in-place editor is displayed.
	ObjectClicked	Raised when an object is clicked.
	ObjectDeleted	Raised when an object is deleted interactively.
	ObjectDeleting	Raised when an object is about to be deleted interactively.
	ObjectDeselected	Raised when an object is deselected, either programmatically or interactively.
	ObjectModified	Raised when the user completes the modification of an object.
	ObjectModifyCancelled	Raised when the user cancels the modification of an object.
	ObjectModifying	Raised when the user starts modifying an interactive object.
	ObjectSelected	Raised when an object is selected, either programmatically or interactively.
	ObjectSelecting	Raised when the user is about to select an object.
	ObjectStartModifying	Raised while the user is moving or resizing an interactive object.
	RowClicked	Raised when a row header is clicked.
	RowGroupCollapsed	Raised when a row group has been collapsed interactively.
	RowGroupExpanded	Raised when a row group has been expanded interactively.
	RowOutlineLevelToggled	Raised when a row outline level has been activated interactively.
	RowsMoved	Raised when one or more rows are moved interactively.
	RowsMoving	Raised when one or more rows are being moved interactively.
	RowsResized	Raised when one or more rows are resized interactively.
	RowsResizing	Raised when one or more rows are being resized interactively.
	WorksheetAdded	Raised when a new worksheet is added to the view interactively, that is, when the user clicks on the 'Create New Tab' button.
	WorksheetTabClicked	Raised when a worksheet tab is clicked with the mouse.

Public Constructors

Public Fields

Public Properties

Public Methods

Protected Methods

Public Events

See Also