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 PropertyActiveCellIndexGets or sets the index of the selection which contains the active cell.  
    Public PropertyActiveSelectionGets the selection that contains the active cell.  
    Public PropertyDefaultGridlineColorGets 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 PropertyDisplayFormulasGets or sets a value indicating whether this sheet should display formulas.  
    Public PropertyDisplayGridlinesGets or sets a value indicating whether this sheet should display grid lines.  
    Public PropertyDisplayHeadingsGets or sets a value indicating whether the sheet should display row and column headings.  
    Public PropertyDisplayOutlineGets or sets a value indicating whether the sheet has outline symbols visible.  
    Public PropertyDisplayRulerGets or sets a value indicating whether to show the ruler in Page Layout View.  
    Public PropertyDisplayWhitespaceGets or sets a value indicating whether page layout view shall display margins.  
    Public PropertyDisplayZerosGets or sets a value indicating whether the window should show 0 (zero) in cells containing zero value.  
    Public PropertyFreezePanesGets or sets a value indicating whether the split panes are frozen.  
    Public PropertyGridlineColorIndexGets or sets the color value for gridlines. This is an 'index color value' (ICV) rather than rgb value.  
    Public PropertyRightToLeftGets or sets a value indicating whether the sheet is in 'right to left' display mode.  
    Public PropertySelectionCountGets the total number of selections.  
    Public PropertySplitGets or sets a value indicating whether the worksheet is split.  
    Public PropertySplitColumnGets or sets the column number where the window is split into panes (the number of columns to the left of the split line).  
    Public PropertySplitHorizontalGets or sets the location of the horizontal window split, in points.  
    Public PropertySplitRowGets or sets the row number where the window is split into panes (the number of rows to the top of the split line).  
    Public PropertySplitVerticalGets or sets the location of the vertical window split, in points.  
    Public PropertyTabSelectedGets or sets a value indicating whether this sheet is selected.  
    Public PropertyTopLeftCellGets the location of the top left visible cell in the bottom right pane (when in Left-to-Right mode).  
    Public PropertyTypeGets or sets the type of this view.  
    Public PropertyWindowProtectionGets or sets a value indicating whether the panes in the window are locked due to workbook protection.  
    Public PropertyZoomScaleGets or sets the window zoom magnification for current view representing percent values.  
    Public PropertyZoomScaleNormalGets or sets the zoom magnification to use when in normal view, representing percent values.  
    Public PropertyZoomScalePageBreakPreviewGets or sets the zoom magnification to use when in page break preview, representing percent values.  
    Public PropertyZoomScalePageLayoutViewGets or sets the zoom magnification to use when in page layout view, representing percent values.  
    Public PropertyZoomToFitDetermines 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 MethodAddSelection  
    Public MethodClearActiveCell  
    Public MethodClearSelectionsClears all selections.  
    Public MethodCopySelectionToCopy the current selection to target worksheet view.  
    Public Methodstatic (Shared in Visual Basic)CreateCreates new WorksheetView value.  
    Public MethodDeselectDeselects from the specified cell range.  
    Public MethodGetActiveCellGets the active row and column indexes.  
    Public MethodGetSelection  
    Public MethodGetSelectionsGets all selections.  
    Public MethodIsBelongToSelectionGets a boolean value indicating whether the specified cell belong to the current selection(s).  
    Public MethodIsSelectSingleCellGets a boolean value indicating whether there is only one selected cell.  
    Public MethodIsWholeColumn  
    Public MethodIsWholeRow  
    Public MethodModifySelection  
    Public MethodMoveActiveCellMoves the active cell base on the specified direction.  
    Public MethodMoveOneCell  
    Public MethodNotifyUISelection  
    Public MethodProcessWorksheetRemoveColumns  
    Public MethodProcessWorksheetRemoveRows  
    Public MethodRemoveAtRemove the selection at the specified position.  
    Public MethodResetRe-create the view of a worksheet.  
    Public MethodSetActiveCell  
    Top
    See Also

    Reference

    WorksheetView Class
    GrapeCity.Spreadsheet Namespace