[]
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) | |
SetActiveCell(int, int) | Sets the active cell on this worksheet. |