Represents a control that displays Workbook objects.
The following tables list the members exposed by the WorkbookView type.
Name | Description | |
---|---|---|
![]() |
Initializes a new instance of the WorkbookView class. |
Name | Description | |
---|---|---|
![]() |
|
|
![]() |
Initiates in-place edit of the specified in-place editable object. |
|
![]() |
Overloaded. |
|
![]() |
Cancels any drag or select interactions currently performed by user. |
|
![]() |
Overloaded. |
|
![]() |
Overloaded. |
|
![]() |
Completes the in-place editing operation, previously started by a call to beginEdit, and accepts or cancel the change. |
|
![]() |
Overloaded. |
|
![]() |
Gets the Pen used to draw borders of current active cell. |
|
![]() |
Gets the currently active cell. |
|
![]() |
Gets the currently active worksheet. |
|
![]() |
Gets a value indicating whether to display the auto-fill handle at the bottom-right side of the selection. |
|
![]() |
Gets 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 a value indicating whether the user can interactively move the worksheet headers, by selecting the entire column or row and dragging. |
|
![]() |
Gets a value indicating whether the user can interactively resize the worksheet headers. |
|
![]() |
Gets a value indicating whether tabs can be in-place edited. |
|
![]() |
Gets a value indicating whether tabs can be rearranged interactively. |
|
![]() |
Gets what action should be performed by left/right arrow buttons in tab strip. |
|
![]() |
Gets 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 whether auto-fill should skip cells spanned by a merged cell. |
|
![]() |
Gets the background color of the view. |
|
![]() |
Overloaded. Gets the cell at a specified coordinates. |
|
![]() |
Gets the height of the column header. |
|
![]() |
Gets the mouse cursor shown to the user if dragging would resize an object both vertically and horizontally. |
|
![]() |
Gets the mouse cursor shown to the user if dragging would resize an object both vertically and horizontally. |
|
![]() |
Gets the mouse cursor shown to the user when an object cannot be created at a given location. |
|
![]() |
Gets a value indicating whether to draw the default grid lines for cells with set background. |
|
![]() |
Gets the leftmost visible frozen column. |
|
![]() |
Gets the topmost visible frozen row. |
|
![]() |
|
|
![]() |
Gets the number of frozen columns in the view. |
|
![]() |
Gets the number of frozen rows in the view. |
|
![]() |
Gets the mouse cursor shown to the user if dragging would resize an object horizontally. |
|
![]() |
Gets the mouse cursor shown to the user if dragging would resize rows. |
|
![]() |
Gets the format of the tooltip that is displayed when the view is scrolled horizontally. |
|
![]() |
Gets the mouse cursor shown to the user if the mouse is over a cell containing a hyperlink. |
|
![]() |
Gets the license key of the control. |
|
![]() |
Gets the maximum size of tabs representing worksheets in the tab strip. Default value is 100. |
|
![]() |
Gets the mouse cursor shown to the user if the pointed object can be modified. |
|
![]() |
Gets how to handle pasting data into merged cells. |
|
![]() |
Gets the mouse cursor shown to the user when no modification is performed. |
|
![]() |
Gets the format of the tooltip that is displayed when a column is resized interactively. |
|
![]() |
Gets the format of the tooltip that is displayed when a row is resized interactively. |
|
![]() |
Gets the width of the row header. |
|
![]() |
Gets the value of the horizontal scrollbar. |
|
![]() |
Gets the value of the vertical scrollbar. |
|
![]() |
Gets an object that can be used to manipulate the selection in the view. |
|
![]() |
Gets the selection type |
|
![]() |
Gets a value indicating whether to display the active cell. |
|
![]() |
Gets a value indicating whether to display the range affected by the autofilter. |
|
![]() |
Gets a value indicating whether to display the 'Create New Tab' button. |
|
![]() |
Gets a value indicating whether to display the formula bar. |
|
![]() |
Gets a value indicating whether to display the grid lines. |
|
![]() |
Gets a value indicating whether to display the row and column headers. |
|
![]() |
Gets a value indicating whether to display indicators for hidden row and column headers. |
|
![]() |
Gets a value indicating whether to display the horizontal scroll bar. |
|
![]() |
Gets a value indicating whether to display tooltips when the user resizes row or column headers. |
|
![]() |
Gets a value indicating whether to display tooltips when scrolling with the thumb. |
|
![]() |
Gets a value indicating whether to display the cell selection. |
|
![]() |
Gets a value indicating whether to display a close button for each tab. |
|
![]() |
Gets a value indicating whether the tab navigation buttons. |
|
![]() |
Gets a value indicating whether the tabs are visible. |
|
![]() |
Gets a value indicating whether to display the vertical scroll bar. |
|
![]() |
Gets the tabs alignment. |
|
![]() |
Gets a value indicating whether to validate pasted data |
|
![]() |
Gets the mouse cursor shown to the user if dragging would resize an object vertically. |
|
![]() |
Gets the mouse cursor shown to the user if dragging would resize columns. |
|
![]() |
Gets the format of the tooltip that is displayed when the view is scrolled vertically. |
|
![]() |
Gets the Workbook displayed in the view. |
|
![]() |
Gets a value indicating whether there is currently an in-place editing operation in progress within the view. |
|
![]() |
Gets if keyboard focus is currently on a cell. |
|
![]() |
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. |
|
![]() |
Overloaded. |
|
![]() |
Resizes a view row to fit its contents. |
|
![]() |
Sets the Pen used to draw borders of current active cell. |
|
![]() |
Sets the currently active cell. |
|
![]() |
Sets the currently active worksheet. |
|
![]() |
Sets a value indicating whether to display the auto-fill handle at the bottom-right side of the selection. |
|
![]() |
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. |
|
![]() |
Sets a value indicating whether the user can interactively move the worksheet headers, by selecting the entire column or row and dragging. |
|
![]() |
Sets a value indicating whether the user can interactively resize the worksheet headers. |
|
![]() |
Sets a value indicating whether tabs can be in-place edited. |
|
![]() |
Sets a value indicating whether tabs can be rearranged interactively. |
|
![]() |
Sets what action should be performed by left/right arrow buttons in tab strip. |
|
![]() |
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. |
|
![]() |
Sets whether auto-fill should skip cells spanned by a merged cell. |
|
![]() |
Sets the background color of the view. |
|
![]() |
Sets the height of the column header, or null, to automatically size the column headers. |
|
![]() |
Sets the mouse cursor shown to the user if dragging would resize an object both vertically and horizontally. |
|
![]() |
Sets the mouse cursor shown to the user if dragging would resize an object both vertically and horizontally. |
|
![]() |
Sets the mouse cursor shown to the user when an object cannot be created at a given location. |
|
![]() |
Sets a value indicating whether to draw the default grid lines for cells with set background. |
|
![]() |
Sets the leftmost visible frozen column. |
|
![]() |
Sets the topmost visible frozen row. |
|
![]() |
Sets if keyboard focus is currently on a cell. |
|
![]() |
|
|
![]() |
Sets the number of frozen columns in the view. |
|
![]() |
Sets the number of frozen rows in the view. |
|
![]() |
Sets the mouse cursor shown to the user if dragging would resize an object horizontally. |
|
![]() |
Sets the mouse cursor shown to the user if dragging would resize rows. |
|
![]() |
Sets the format of the tooltip that is displayed when the view is scrolled horizontally. |
|
![]() |
Sets the mouse cursor shown to the user if the mouse is over a cell containing a hyperlink. |
|
![]() |
Sets the license key of the control. |
|
![]() |
Sets the maximum size of tabs representing worksheets in the tab strip. |
|
![]() |
Gets the mouse cursor shown to the user if the pointed object can be modified. |
|
![]() |
Sets how to handle pasting data into merged cells. |
|
![]() |
Sets the mouse cursor shown to the user when no modification is performed. |
|
![]() |
Sets the format of the tooltip that is displayed when a column is resized interactively. |
|
![]() |
Sets the format of the tooltip that is displayed when a row is resized interactively. |
|
![]() |
Sets the width of the row header, or null, to automatically size the row headers. |
|
![]() |
Sets the value of the horizontal scrollbar. |
|
![]() |
Sets the value of the vertical scrollbar. |
|
![]() |
Sets the selection type |
|
![]() |
Sets a value indicating whether to display the active cell. |
|
![]() |
Sets a value indicating whether to display the range affected by the autofilter. |
|
![]() |
Gets a value indicating whether to display the 'Create New Tab' button. |
|
![]() |
Sets a value indicating whether to display the formula bar. |
|
![]() |
Sets a value indicating whether to display the grid lines. |
|
![]() |
Sets a value indicating whether to display the row and column headers. |
|
![]() |
Sets a value indicating whether to display indicators for hidden row and column headers. |
|
![]() |
Sets a value indicating whether to display the horizontal scroll bar. |
|
![]() |
Sets a value indicating whether to display tooltips when the user resizes row or column headers. |
|
![]() |
Sets a value indicating whether to display tooltips when scrolling with the thumb. |
|
![]() |
Sets a value indicating whether to display the cell selection. |
|
![]() |
Sets a value indicating whether to display a close button for each tab. |
|
![]() |
Sets a value indicating whether the tab navigation buttons. |
|
![]() |
Sets a value indicating whether the tabs are visible. |
|
![]() |
Sets a value indicating whether to display the vertical scroll bar. |
|
![]() |
Sets the tabs alignment. |
|
![]() |
Sets a value indicating whether to validate pasted data |
|
![]() |
Sets the mouse cursor shown to the user if dragging would resize an object vertically. |
|
![]() |
Sets the mouse cursor shown to the user if dragging would resize columns. |
|
![]() |
Sets the format of the tooltip that is displayed when the view is scrolled vertically. |
|
![]() |
Sets the Workbook displayed in the view. |
|
![]() |
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. |
|
![]() |
Unfreezes any frozen columns or rows. |
Name | Description | |
---|---|---|
![]() |
Raises the activatingCell event. |
|
![]() |
Raises the ActiveCellChanged event. |
|
![]() |
Raises the activeWorksheetChanged event. |
|
![]() |
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 columnsResized event. |
|
![]() |
Raises the drawCell event. |
|
![]() |
Raises the drawColumn event. |
|
![]() |
Raises the drawRow event. |
|
![]() |
Raises the WorkbookViewListener.dropDownValueSelected 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. |
|
![]() |
Raises the WorkbookViewListener.queryDropDownList event. |
|
![]() |
Raises the rowClicked event. |
|
![]() |
Raises the rowGroupCollapsed event. |
|
![]() |
Raises the RowGroupExpanded event. |
|
![]() |
Raises the rowOutlineLevelToggled event. |
|
![]() |
Raises the rowsMoved event. |
|
![]() |
Raises the rowsResized event. |
|
![]() |
Raises the selectionChanged event. |
|
![]() |
Raises the worksheetAdded event. |
|
![]() |
Raises the worksheetRemoved event. |
|
![]() |
Raises the worksheetRemoving event. |
|
![]() |
Raises the worksheetRenamed event. |
|
![]() |
Raises the worksheetRenameFailed event. |
|
![]() |
Raises the worksheetTabClicked event. |