SpreadsheetGear Namespace : IWorksheetWindowInfo Interface |
The following tables list the members exposed by IWorksheetWindowInfo.
Name | Description | |
---|---|---|
ActiveCell | Returns an instance of IRange representing the active cell. | |
ActiveCellAreaIndex | Returns the index of the area of the active cell. | |
ActivePane | Returns the active pane. | |
DisplayFormulas | Gets or sets the property which specifies whether formulas are displayed in worksheet cells instead of values. | |
DisplayGridlines | Gets or sets the property which specifies whether gridlines are displayed for the worksheet. | |
DisplayHeadings | Gets or sets the property which specifies whether row and column headings are displayed for the worksheet. | |
DisplayOutline | Gets or sets the property which specifies whether outlines are displayed for the worksheet. | |
DisplayRightToLeft | Returns true if the worksheet is displayed right to left. | |
DisplayZeros | Gets or sets the property which specifies whether zero values are displayed for the worksheet. | |
FreezePanes | Gets or sets the property which specifies whether window panes are frozen for the worksheet. | |
GridlineColor | Gets or sets the color to use for gridlines. | |
GridlineColorIndex | Gets or sets the index of the color to use for gridlines. | |
Panes | Returns the collection of window panes associated with the worksheet. | |
RangeSelection | Gets or sets the range selection associated with this IWorksheetWindowInfo. | |
ScrollColumn | Gets or sets the left column displayed in the window. | |
ScrollRow | Gets or sets the top row displayed in the window. | |
ShapeSelection | Gets or sets the shape selection associated with this IWorksheetWindowInfo. | |
SplitColumns | Gets or sets the number of columns displayed to the left of the split. | |
SplitHorizontal | Gets or sets the position of the horizontal split in points. | |
SplitRows | Gets or sets the number of rows displayed above the split. | |
SplitVertical | Gets or sets the position of the vertical split in points. | |
View | Gets or sets whether the worksheet is viewed normally or in page break preview mode. | |
Worksheet | Gets the worksheet which this window information refers to. | |
Zoom | Gets or sets the scaling factor for displaying in a window. |
Name | Description | |
---|---|---|
ColumnToPoints | Converts from a zero based fractional column position to points (1/72 of an inch). | |
PointsToColumn | Converts from points (1/72 of an inch) to a zero based fractional column position. | |
PointsToRow | Converts from points (1/72 of an inch) to a zero based fractional row position. | |
RowToPoints | Converts from a zero based fractional row position to points (1/72 of an inch). | |
SetSelection | Overloaded. Selects the specified range and activates the specified cell. |