Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / WorksheetView Class
Properties Methods


In This Topic
    WorksheetView Class Members
    In This Topic

    The following tables list the members exposed by WorksheetView.

    Public Properties
     NameDescription
    Public PropertyGets or sets the index of the selection which contains the active cell.  
    Public PropertyGets the selection that contains the active cell.  
    Public PropertyGets or sets a value indicating whether the consuming application should use the default grid lines color (system dependent). Overrides any color specified in colorId.  
    Public PropertyGets or sets a value indicating whether this sheet should display formulas.  
    Public PropertyGets or sets a value indicating whether this sheet should display grid lines.  
    Public PropertyGets or sets a value indicating whether the sheet should display row and column headings.  
    Public PropertyGets or sets a value indicating whether the sheet has outline symbols visible.  
    Public PropertyGets or sets a value indicating whether to show the ruler in Page Layout View.  
    Public PropertyGets or sets a value indicating whether page layout view shall display margins.  
    Public PropertyGets or sets a value indicating whether the window should show 0 (zero) in cells containing zero value.  
    Public PropertyGets or sets a value indicating whether the split panes are frozen.  
    Public PropertyGets or sets the color value for gridlines. This is an 'index color value' (ICV) rather than rgb value.  
    Public PropertyGets or sets a value indicating whether the sheet is in 'right to left' display mode.  
    Public PropertyGets the total number of selections.  
    Public PropertyGets or sets a value indicating whether the worksheet is split.  
    Public PropertyGets or sets the column number where the window is split into panes (the number of columns to the left of the split line).  
    Public PropertyGets or sets the location of the horizontal window split, in points.  
    Public PropertyGets or sets the row number where the window is split into panes (the number of rows to the top of the split line).  
    Public PropertyGets or sets the location of the vertical window split, in points.  
    Public PropertyGets or sets a value indicating whether this sheet is selected.  
    Public PropertyGets the location of the top left visible cell in the bottom right pane (when in Left-to-Right mode).  
    Public PropertyGets or sets the type of this view.  
    Public PropertyGets or sets a value indicating whether the panes in the window are locked due to workbook protection.  
    Public PropertyGets or sets the window zoom magnification for current view representing percent values.  
    Public PropertyGets or sets the zoom magnification to use when in normal view, representing percent values.  
    Public PropertyGets or sets the zoom magnification to use when in page break preview, representing percent values.  
    Public PropertyGets or sets the zoom magnification to use when in page layout view, representing percent values.  
    Public PropertyDetermines whether the view is zoomed to fit the dimensions of the document window every time the document window is resized.  
    Top
    Public Methods
     NameDescription
    Public Method  
    Public Method  
    Public MethodClears all selections.  
    Public MethodCopy the current selection to target worksheet view.  
    Public Methodstatic (Shared in Visual Basic)Creates new WorksheetView value.  
    Public MethodDeselects from the specified cell range.  
    Public MethodGets the active row and column indexes.  
    Public Method  
    Public MethodGets all selections.  
    Public MethodGets a boolean value indicating whether the specified cell belong to the current selection(s).  
    Public MethodGets a boolean value indicating whether there is only one selected cell.  
    Public Method  
    Public Method  
    Public Method  
    Public MethodMoves the active cell base on the specified direction.  
    Public Method  
    Public Method  
    Public Method  
    Public Method  
    Public MethodRemove the selection at the specified position.  
    Public MethodRe-create the view of a worksheet.  
    Public Method  
    Top
    See Also