Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SpreadView Class
Fields Properties Methods

In This Topic
    SpreadView Class Members
    In This Topic

    The following tables list the members exposed by SpreadView.

    Public Fields
     NameDescription
    Public Field Specifies the index, 2, for the image for the collapse icon in a hiearchical display.  
    Public Field Specifies the index, 3, for the image for the disabled collapse icon in a hiearchical display.  
    Public Field Specifies the index, 19, for the image for the row editing indicator.  
    Public Field Specifies the index, 28, for the image for the enhanced active filter indicator.  
    Public Field Specifies the index, 29, for the image for the enhanced disabled active filter indicator.  
    Public Field Specifies the index, 30, for the image for the enhanced inactive filter indicator.  
    Public Field Specifies the index, 31, for the image for the enhanced disabled inactive filter indicator.  
    Public Field Specifies the index, 20, for the image for the enhanced ascending filter sort indicator.  
    Public Field Specifies the index, 21, for the image for the enhanced disabled ascending filter sort indicator.  
    Public Field Specifies the index, 24, for the image for the enhanced descending filter sort indicator.  
    Public Field Specifies the index, 25, for the image for the enhanced disabled descending filter sort indicator.  
    Public Field Specifies the index, 22, for the image for the enhanced ascending sort indicator.  
    Public Field Specifies the index, 23, for the image for the enhanced disabled ascending sort indicator.  
    Public Field Specifies the index, 26, for the image for the enhanced descending sort indicator.  
    Public Field Specifies the index, 27, for the image for the enhanced disabled descending sort indicator.  
    Public Field Specifies the index, 0, for the image for the expand icon in a hiearchical display.  
    Public Field Specifies the index, 1, for the image for the disabled expand icon in a hiearchical display.  
    Public Field Specifies the index, 10, for the image for the active filter indicator.  
    Public Field Specifies the index, 11, for the image for the disabled active filter indicator.  
    Public Field Specifies the index, 16, for the image for the active filterbar indicator.  
    Public Field Specifies the index, 18, for the image for the filterbar calendar indicator.  
    Public Field Specifies the index, 17, for the image for the inactive filterbar indicator.  
    Public Field Specifies the index, 8, for the image for the inactive filter indicator.  
    Public Field Specifies the index, 9, for the image for the disabled inactive filter indicator.  
    Public Field Specifies the index, 14, for the image for the row selector.  
    Public Field Specifies the index, 15, for the image for the disabled row selector.  
    Public Field Specifies the index, 4, for the image for the ascending sort indicator.  
    Public Field Specifies the index, 5, for the image for the disabled ascending sort indicator.  
    Public Field Specifies the index, 6, for the image for the descending sort indicator.  
    Public Field Specifies the index, 7, for the image for the disabled descending sort indicator.  
    Public Field Specifies the index, 12, for the image for the unsorted sort indicator.  
    Public Field Specifies the index, 13, for the image for the disabled unsorted sort indicator.  
    Top
    Public Properties
     NameDescription
    Public Property Gets or sets the active sheet in the view.  
    Public Property Gets or sets whether to allow the cell content to float.  
    Public Property Gets or sets whether data can overflow into adjacent empty cells in the view.  
    Public Property Gets or sets whether to allow the user to move columns.  
    Public Property Gets or sets whether to allow the user to move multiple columns.  
    Public Property Gets or sets whether to allow the user to drag and drop a range of cells in the view.  
    Public Property Gets or sets whether to allow the user to drag and fill cells with the contents of a cell or cells in the view.  
    Public Property Gets or sets whether cell editor reserved mouse locations are allowed.  
    Public Property Gets or sets whether data can overflow into adjacent empty cells while edit mode is on in a cell in the view.  
    Public Property Gets or sets whether to allow the user to move rows.  
    Public Property Gets or sets a value that indicates whether to allow moving the add new row or asterisk row.  
    Public Property Gets or sets whether to allow the user to move multiple rows.  
    Public Property Gets or sets whether sheets can be moved by dragging and dropping the sheet tab.  
    Public Property Gets or sets whether to allow the user to undo edit operations.  
    Public Property Gets or sets whether to allow the user to enter formulas in a cell in the view.  
    Public Property Gets or sets whether to allow the user to scale the view using the Ctrl key and the mouse wheel.  
    Public Property Gets or sets whether to allow shortcut keys for Clipboard actions in the view.  
    Public Property Gets or sets the behavior of automatic fit when double-clicking the right edge of the column header.  
    Public Property Gets or sets the behavior of automatic fit when double-clicking the bottom edge of the row header.  
    Public Property Gets or sets whether to use the CharacterSet property on non-edit mode cells.  
    Public Property Gets or sets whether adjacent cell borders are collapsed into a single line in the view.  
    Public Property Gets the size and location of the view.  
    Public Property Gets or sets whether to display buttons in button and combo box cells in the view.  
    Public Property Gets or sets the cell note indicator renderer.  
    Public Property Gets or sets whether the cell note indicator appears in cells in the view.  
    Public Property Gets or sets the selection model to use when working with a span.  
    Public Property Gets or sets whether headers and the filter bar are included with data in Clipboard actions in the view.  
    Public Property Gets or sets whether a single cell copied to the Clipboard fills the range when pasted from the Clipboard to the component.  
    Public Property Gets or sets the alignment of the column split box relative to the horizontal scroll bar in the view.  
    Public Property Gets or sets when to display the column split box in the view.  
    Public Property Gets the custom list for drag fill in series mode.  
    Public Property Gets or sets a value that indicates whether the drag fill action copies data only.  
    Public Property Gets the contol editing the active cell, or null if the control is not in edit mode.  
    Public Property Gets or sets whether the active cell in the view is in edit mode.  
    Public Property Gets or sets whether edit mode remains on for any cell in the view when that cell becomes active.  
    Public Property Gets or sets whether the existing text in a cell in the view is selected when the cell enters edit mode.  
    Public Property Gets or sets a value to show drag fill button and drag fill context menu.  
    Public Property Gets or sets the renderer for the error icon.  
    Public Property Gets or sets a renderer for drawing the focus rectangle in the view.  
    Public Property Gets the horizontal scroll bar.  
    Public Property Gets or sets the height of horizontal scroll bars in the view.  
    Public Property Gets or sets when to display the horizontal scroll bars in the view.  
    Public Property Gets or sets the small increment for the horizontal scrollbar.  
    Public Property Gets or sets the interface renderer.  
    Public Property Gets or sets the left most sheet tab in the tab strip in the view.  
    Public Property Gets or sets whether the location of the active cell in the view moves when the user moves the focus to the view using the mouse.  
    Public PropertyGets the FpSpread object that owns this view.  
    Public PropertyGets the parent (SpreadView object) of the view.  
    Public Property Gets or sets the mode the user can use to drag and fill cells in the component using the contents of a cell or cells.  
    Public Property Gets or sets whether the selected range of cells in the view remains highlighted when the view loses the focus.  
    Public Property Gets or set the alignment of the row split box relative to the vertical scroll bar in the view.  
    Public Property Gets or sets when to display the row split box in the view.  
    Public Property Gets or sets the scroll bar alignment with the last row and column of the spreadsheet in the view.  
    Public Property Gets or sets whether the user can use the scroll box to scroll through all the columns and rows in the view, or just a limited number of them.  
    Public Property Gets or sets how the control scrolls the sheet when the user moves the scroll box.  
    Public Property Gets or sets whether scroll tips appear when the user moves the scroll box.  
    Public Property Gets or sets which types of selections the user can make in the view.  
    Public Property Gets or sets a renderer for drawing selections in the view.  
    Public Property Gets the sheets in the view.  
    Public Property Gets or sets whether to allow the user to display a cell error using an icon or sticky note for cells in the view.  
    Public Property Gets or sets whether the drag band is displayed when moving a row or column.  
    Public Property Gets or sets whether to allow the user to display a row error using an icon or sticky note for cells in the view.  
    Public Property Gets or sets the skin for the spread.  
    Public Property Gets or sets whether Spread controls automatic scaling with a different system dpi; Spread only supports one dimension so the application should use AutoScaleMode.Dpi for correct scaling, or else scale using the application width.  
    Public Property Gets or sets whether animations, such as an animated focus renderer, in the view are suspended.  
    Public Property Gets or sets whether the special insert tab is present on the tab strip.  
    Public Property Gets or sets the tabstrip insert-tab image.  
    Public Property Gets or sets the location of the tab strip in the view.  
    Public Property Gets or sets the display policy for the tab strip in the view.  
    Public Property Gets or sets the width of the tab strip in the view expressed as a percentage of the overall horizontal width of the control.  
    Public Property Gets or sets the appearance of text tips in the view.  
    Public Property Gets or sets the time (in milliseconds) the control waits before displaying the text tip for the cell or header under the pointer in the view.  
    Public Property Gets or sets whether to display text tips and the location of the tips in the view.  
    Public Property Gets or sets the undo manager for the SpreadView.  
    Public Property Gets the vertical scroll bar.  
    Public Property Gets or sets when to display the vertical scroll bars in the view.  
    Public Property Gets or sets the small increment for the vertical scrollbar.  
    Public Property Gets or sets the width of vertical scroll bars in the view.  
    Public Property Gets or sets whether to use visual styles when rendering objects in the control.  
    Top
    Public Methods
     NameDescription
    Public MethodOverloaded.  Adds a row or column of viewports.  
    Public Method Cancels cell editing in the view.  
    Public Method Cancels cell editing in the filter bar.  
    Public Method Expands or collapses the specified parent row, which shows or hides the child view in a hierarchical display.  
    Public Method Gets the action map.  
    Public MethodOverloaded.  Gets the index of the active viewport column.  
    Public MethodOverloaded.  Gets the index of the active viewport row.  
    Public MethodGets the active view (SpreadView object).  
    Public MethodOverloaded.  Gets the row and column indexes of the cell at the specified pointer location.  
    Public Method Gets the rectangle of the cell.  
    Public MethodGets all child views (SpreadView objects) that have been created.  
    Public Method Gets the rectangle of the cell in the column footer.  
    Public MethodOverloaded.  Gets the row and column indexes of the column header cell at the specified pointer location.  
    Public Method Gets the rectangle of the cell in the column header.  
    Public Method Gets the rectangle of the column header.  
    Public Method Gets the height of the column range group.  
    Public Method Gets the rectangle of the column split bar.  
    Public Method Gets the rectangle of the column split box.  
    Public MethodOverloaded.  Gets the number of viewport columns in the active sheet.  
    Public Method Gets the index of the viewport column for the specified coordinate for the active sheet.  
    Public Method Gets the pointer displayed over a specific area in the view.  
    Public Method Gets the rectangle of the column header.  
    Public Method Gets the rectangle of the filter bar.  
    Public Method Returns the floating cell range for the specified cell.  
    Public Method Returns all floating cell ranges for the view.  
    Public Method Gets the rectangle of the horizontal scroll bar.  
    Public Method Gets the graphic image used in the specified part of the user interface.  
    Public MethodOverloaded.  Gets the input map defined for the specified focus mode for the view.  
    Public Method Gets the input map for the view for when a child object has focus.  
    Public Method Gets the input map for the view for when a shape has focus.  
    Public Method Gets the maximum cell overflow width in pixels for cells in the view.  
    Public Method Returns the merged cell range for the specified cell.  
    Public Method Returns all merged cell ranges for the view.  
    Public MethodGets the top view (SpreadView object).  
    Public MethodOverloaded.  Gets the row and column indexes of the row header cell at the specified pointer location.  
    Public Method Gets the rectangle of the cell in the row header.  
    Public Method Gets the rectangle of the row header.  
    Public Method Gets the width of the row range group.  
    Public Method Gets the rectangle of the row split bar.  
    Public Method Gets the rectangle of the row split box.  
    Public MethodOverloaded.  Gets the number of viewport rows in the active sheet.  
    Public Method Gets the index of the viewport row for the specified coordinate for the active sheet.  
    Public Method Gets the rectangle of the tab associated with a sheet for the view.  
    Public Method Gets the active sheet view.  
    Public Method Gets the view at the specified sheet and viewport.  
    Public Method Gets the rectangle of the split box on the tab strip.  
    Public Method Gets the rectangle of the tab strip.  
    Public Method Gets the rectangle of the vertical scroll bar.  
    Public MethodOverloaded.  Gets the index of the bottom row of the specified viewport row.  
    Public MethodOverloaded.  Gets the height of the specified viewport row for the active sheet.  
    Public MethodOverloaded.  Gets the index of the left most column of the specified viewport column.  
    Public Method Gets the offset of the view port from a particular column to the left.  
    Public MethodOverloaded.  Gets the maximum height for the viewport row.  
    Public MethodOverloaded.  Gets the maximum width for the viewport column.  
    Public Method Gets the rectangle of the viewport.  
    Public MethodOverloaded.  Gets the index of the right most column of the specified viewport column.  
    Public Method Get offset of the view port from a particular row to the top.  
    Public MethodOverloaded.  Gets the index of the top row of the specified viewport row.  
    Public Method  
    Public MethodOverloaded.  Gets the width of the specified viewport column for the active sheet.  
    Public Method Gets the left coordinate of the specified viewport column for the active sheet.  
    Public Method Gets the top coordinate of the specified viewport row for the active sheet.  
    Public Method Attempts to find a value for one cell that will produce the desired formula result in another cell.  
    Public Method Returns information about the given location.  
    Public MethodOverloaded.  Loads the XML input map file using the specified operation mode.  
    Public MethodOverloaded.  Loads the XML input map file when the child has focus.  
    Public MethodOverloaded.  Loads the XML input map file when the shape has focus.  
    Public MethodOverloaded.  Removes a row or column of viewports.  
    Public Method Resets the active view to its default settings.  
    Public MethodOverloaded.  Saves the XML input map file.  
    Public MethodOverloaded.  Saves the XML input map file when the child has focus.  
    Public MethodOverloaded.  Saves the XML input map file when the shape has focus.  
    Public Method Sets the action map.  
    Public MethodOverloaded.  Sets the active viewport.  
    Public Method Sets the active SpreadView to the specified object. If the workbook passed in is null, sets this object to be the active SpreadView.  
    Public Method Sets the pointer displayed over a specific area at a specific time.  
    Public Method Sets the specified graphic for a specified part of the user interface.  
    Public Method Sets the multiscaling versions of specified graphic for a specified part of the user interface.  
    Public MethodOverloaded.  Sets the input map for the view for the specified focus mode.  
    Public Method Sets the input maps of this spreadview to another spread view.  
    Public Method Sets the input map for the view for when a child object has focus.  
    Public Method Sets the input map for the view for when a shape has focus.  
    Public Method Sets the maximum cell overflow width in pixels for cells in the view.  
    Public MethodOverloaded.  Sets the index of the left most column of the specified viewport column.  
    Public MethodOverloaded.  Sets the maximum height for the viewport row.  
    Public MethodOverloaded.  Sets the maximum width for the viewport column.  
    Public MethodOverloaded.  Sets the index of the top row of the specified viewport row.  
    Public Method Moves the currently selected cell in the specified viewport to the specified position.  
    Public Method Shows the AutoFill indicator.  
    Public Method Moves the specified cell in the specified viewport to the specified position.  
    Public Method Moves a column in the specified viewport to the specified position.  
    Public Method Moves a row in the specified viewport to the specified position.  
    Public Method Starts cell editing in the view.  
    Public Method Stops cell editing in the view.  
    Public Method Stops cell editing in the filter bar.  
    Top
    See Also