[]
Represents a worksheet view.
public interface IWorksheetView : ISheetView
Public Interface IWorksheetView
Inherits ISheetView
| Name | Description |
|---|---|
| DefaultGridlineColor | Gets or sets a value indicating whether the consuming application should use the default grid lines color (system dependent). Overrides any color specified in colorId. |
| DisplayFormulas | Gets or sets a value indicating whether this sheet should display formulas. |
| DisplayGridlines | Gets or sets a value indicating whether this sheet should display gridlines. |
| DisplayHeadings | Gets or sets a value indicating whether the sheet should display row and column headings. |
| DisplayOutline | Gets or sets a value indicating whether the sheet has outline symbols visible. |
| DisplayZeros | Gets or sets a value indicating whether the window should show 0 (zero) in cells containing zero value. |
| FreezePanes | Gets or sets a value indicating whether the split panes are frozen. |
| GridlineColorIndex | Gets or sets the color value for grid lines. This is an 'index color value' (ICV) rather than RGB value. |
| SelectionCount | Return the count of selections. |
| Split | Gets or sets a value indicating whether the sheetview is split. |
| SplitColumn | Gets or sets the column number where the window is split into panes (the number of columns to the left of the split line). |
| SplitHorizontal | Gets or sets the location of the horizontal window split, in points. |
| SplitRow | Gets or sets the row number where the window is split into panes (the number of rows to the top of the split line). |
| SplitVertical | Gets or sets the location of the vertical window split, in points. |
| ZoomScale | Gets or sets the window zoom magnification for current view representing percent values. |
| Name | Description |
|---|---|
| AddSelection(int, int, int, int) | Adds the specified cell range to the selection. |
| ClearSelections() | Clears all selections. |
| Deselect(int, int, int, int) | Deselects the specified cell range from the current selections. |
| GetActiveCell(out int, out int) | Gets the active row and column indexes. |
| GetSelection(int) | Gets selection at index. |
| ModifySelection(int, int, int, int) | Modify selection |
| SetActiveCell(int, int) | Sets the active cell on this worksheet. |