[]
        
(Showing Draft Content)

GrapeCity.Spreadsheet.IWorksheetView

IWorksheetView Interface

Represents a worksheet view.

Namespace: GrapeCity.Spreadsheet
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public interface IWorksheetView : ISheetView
Public Interface IWorksheetView
    Inherits ISheetView

Properties

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.

Methods

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.