Represents a control that can display individual Worksheet objects.
The following tables list the members exposed by the WorksheetView type.
Name | Description | |
---|---|---|
![]() |
Initializes a new instance of the WorksheetView class. |
Name | Description | |
---|---|---|
![]() |
Gets or sets the currently active cell. |
|
![]() |
Gets or sets a value indicating whether to display the auto-fill handle at the bottom-right side of the selection. |
|
![]() |
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. |
|
![]() |
Gets or sets a value indicating whether the user can interactively move the worksheet headers, by selecting the entire column or row and dragging. |
|
![]() |
Gets or sets a value indicating whether users can resize rows and columns by dragging cell borders. |
|
![]() |
Gets or sets whether the auto-fill tool should only copy values, instead of extrapolating new values from the selection. |
|
![]() |
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. |
|
![]() |
Gets or sets the background color of the view. |
|
![]() |
Gets or sets the height of the column header, or null (Nothing in Visual Basic), to automatically size the column headers. |
|
![]() |
Gets or sets the mouse cursor shown to the user if dragging would resize an object both vertically and horizontally. |
|
![]() |
Gets or sets the mouse cursor shown to the user if dragging would resize an object both vertically and horizontally. |
|
![]() |
Gets or sets the mouse cursor shown to the user when an object cannot be created at a given location. |
|
![]() |
Gets or sets a value indicating whether to draw the default grid lines for cells with set background. |
|
![]() |
Gets or sets the mouse cursor shown to the user if dragging would resize an object horizontally. |
|
![]() |
Gets or sets the mouse cursor shown to the user if dragging would resize rows. |
|
![]() |
Gets or sets the format of the tooltip that is displayed when the view is scrolled horizontally. |
|
![]() |
Gets or sets the mouse cursor shown to the user if the mouse is over a cell containing a hyperlink. |
|
![]() |
Gets a value indicating whether there is currently an in-place editing operation in progress within the view. |
|
![]() |
Gets or sets the license key of the control. |
|
![]() |
Gets or sets the mouse cursor shown to the user if the pointed object can be modified. |
|
![]() |
Gets or sets the mouse cursor shown to the user when no modification is performed. |
|
![]() |
Gets or sets the format of the tooltip that is displayed when a column is resized interactively. |
|
![]() |
Gets or sets the format of the tooltip that is displayed when a row is resized interactively. |
|
![]() |
Gets or sets the width of the row header, or null (Nothing in Visual Basic), to automatically size the row headers. |
|
![]() |
Gets or sets the value of the horizontal scrollbar. |
|
![]() |
Gets or sets the value of the vertical scrollbar. |
|
![]() |
Gets an object that can be used to manipulate the selection in the view. |
|
![]() |
Gets or sets a value indicating whether to display the active cell. |
|
![]() |
Gets or sets a value indicating whether to display the range affected by the autofilter. |
|
![]() |
Gets or sets a value indicating whether to display the grid lines. |
|
![]() |
Gets or sets a value indicating whether to display the row and column headers. |
|
![]() |
Gets or sets a value indicating whether to display indicators for hidden row and column headers. |
|
![]() |
Gets or sets a value indicating whether to display the horizontal scroll bar. |
|
![]() |
Gets or sets a value indicating whether to display tooltips when the user resizes row or column headers. |
|
![]() |
Gets or sets a value indicating whether to display tooltips when scrolling with the thumb. |
|
![]() |
Gets or sets a value indicating whether to display the cell selection. |
|
![]() |
Gets or sets a value indicating whether to display the vertical scroll bar. |
|
![]() |
Gets or sets the mouse cursor shown to the user if dragging would resize an object vertically. |
|
![]() |
Gets or sets the mouse cursor shown to the user if dragging would resize columns. |
|
![]() |
Gets or sets the format of the tooltip that is displayed when the view is scrolled vertically. |
|
![]() |
Gets or sets the Worksheet displayed in the view. |
Name | Description | |
---|---|---|
![]() |
Scrolls the view to make the specified cell visible. |
|
![]() |
Copies the data from the currently selected cells to the clipboard. |
|
![]() |
Cuts the data from the currently selected cells to the clipboard. |
|
![]() |
Overloaded. Gets the cell at the specified coordinates. |
|
![]() |
Pastes the data from the clipboard inside the currently selected cells. |
|
![]() |
Resizes view columns to fit their contents. |
|
![]() |
Resizes a view column to fit its contents. |
|
![]() |
Resizes view rows to fit their contents. |
|
![]() |
Resizes a view row to fit its contents. |
|
![]() |
Converts the specified measure, relative to the left side of the specified cell, to a measure, relative to the left side of the entire worksheet. |
|
![]() |
Converts the specified measure, relative to the top side of the specified cell, to a measure, relative to the top side of the entire worksheet. |
|
![]() |
Converts the specified measure, relative to the left side of the worksheet, to a measure, relative to the left side of the specified cell. |
|
![]() |
Converts the specified measure, relative to the top side of the worksheet, to a measure, relative to the top side of the specified cell. |
Name | Description | |
---|---|---|
![]() |
Clean up any resources being used. |
|
![]() |
Raises the CellClicked event. |
|
![]() |
Raises the ColumnClicked event. |
|
![]() |
Raises the ColumnGroupCollapsed event. |
|
![]() |
Raises the ColumnGroupExpanded event. |
|
![]() |
Raises the ColumnOutlineLevelToggled event. |
|
![]() |
Raises the ColumnsMoved event. |
|
![]() |
Raises the ColumnsMoving event. |
|
![]() |
Raises the ColumnsResized event. |
|
![]() |
Raises the ColumnsResizing event. |
|
![]() |
Raises the DrawColumn event. |
|
![]() |
Raises the DrawRow event. |
|
![]() |
Raises the HyperlinkClicked event. |
|
![]() |
Raises the InplaceEditEnded event. |
|
![]() |
Raises the InplaceEditEnding event. |
|
![]() |
Raises the InplaceEditStarted event. |
|
![]() |
Raises the InplaceEditStarting event. |
|
![]() |
Raises the ObjectClicked event. |
|
![]() |
Raises the ObjectDeleted event. |
|
![]() |
Raises the ObjectDeleting event. |
|
![]() |
Raises the ObjectDeselected event. |
|
![]() |
Raises the ObjectModified event. |
|
![]() |
Raises the ObjectModifyCancelled event. |
|
![]() |
Raises the ObjectModifying event. |
|
![]() |
Raises the ObjectSelected event. |
|
![]() |
Raises the ObjectSelecting event. |
|
![]() |
Raises the ObjectStartModifying event. |
|
![]() |
Raises the PropertyChanged event. |
|
![]() |
UserControl.OnResize override. |
|
![]() |
Raises the RowClicked event. |
|
![]() |
Raises the RowGroupCollapsed event. |
|
![]() |
Raises the RowGroupExpanded event. |
|
![]() |
Raises the RowOutlineLevelToggled event. |
|
![]() |
Raises the RowsMoved event. |
|
![]() |
Raises the RowsMoving event. |
|
![]() |
Raises the RowsResized event. |
|
![]() |
Raises the RowsResizing event. |
Name | Description | |
---|---|---|
![]() |
Raised when a cell is clicked. |
|
![]() |
Raised when a column header is clicked. |
|
![]() |
Raised when a column group has been collapsed interactively. |
|
![]() |
Raised when a column group has been expanded interactively. |
|
![]() |
Raised when a column outline level has been activated interactively. |
|
![]() |
Raised when one or more columns are moved interactively. |
|
![]() |
Raised when one or more columns are being moved interactively. |
|
![]() |
Raised when one or more columns are resized interactively. |
|
![]() |
Raised when one or more columns are being resized interactively. |
|
![]() |
Raised to allow custom drawing of view columns. |
|
![]() |
Raised to allow custom drawing of view rows. |
|
![]() |
Raised when a cell containing a hyperlink is clicked. |
|
![]() |
Raised when an inplace-edit operation has finished. |
|
![]() |
Raised when an in-place edit operation is about to finish, before the in-place editor is closed. |
|
![]() |
Raised when an in-place edit operation has started, after the in-place editor is displayed. |
|
![]() |
Raised when an in-place edit operation is about to start, before the in-place editor is displayed. |
|
![]() |
Raised when a object is clicked. |
|
![]() |
Raised when an object is deleted interactively. |
|
![]() |
Raised when an object is about to be deleted interactively. |
|
![]() |
Raised when an object is deselected, either programmatically or interactively. |
|
![]() |
Raised when the user completes the modification of an object. |
|
![]() |
Raised when the user cancels the modification of an object. |
|
![]() |
Raised when the user starts modifying an interactive object. |
|
![]() |
Raised when an object is selected, either programmatically or interactively. |
|
![]() |
Raised when the user is about to select an object. |
|
![]() |
Raised while the user is moving or resizing an interactive object. |
|
![]() |
Raised when a property value changes. |
|
![]() |
Raised when a row header is clicked. |
|
![]() |
Raised when a row group has been collapsed interactively. |
|
![]() |
Raised when a row group has been expanded interactively. |
|
![]() |
Raised when a row outline level has been activated interactively. |
|
![]() |
Raised when one or more rows are moved interactively. |
|
![]() |
Raised when one or more rows are being moved interactively. |
|
![]() |
Raised when one or more rows are resized interactively. |
|
![]() |
Raised when one or more rows are being resized interactively. |