Spread Windows Forms 14.0
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 FieldSpecifies the index, 2, for the image for the collapse icon in a hiearchical display. This field is constant and read-only.  
    Public FieldSpecifies the index, 3, for the image for the disabled collapse icon in a hiearchical display. This field is constant and read-only.  
    Public FieldSpecifies the index, 19, for the image for the row editing indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 28, for the image for the enhanced active filter indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 29, for the image for the enhanced disabled active filter indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 30, for the image for the enhanced inactive filter indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 31, for the image for the enhanced disabled inactive filter indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 20, for the image for the enhanced ascending filter sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 21, for the image for the enhanced disabled ascending filter sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 24, for the image for the enhanced descending filter sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 25, for the image for the enhanced disabled descending filter sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 22, for the image for the enhanced ascending sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 23, for the image for the enhanced disabled ascending sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 26, for the image for the enhanced descending sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 27, for the image for the enhanced disabled descending sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 0, for the image for the expand icon in a hiearchical display. This field is constant and read-only.  
    Public FieldSpecifies the index, 1, for the image for the disabled expand icon in a hiearchical display. This field is constant and read-only.  
    Public FieldSpecifies the index, 10, for the image for the active filter indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 11, for the image for the disabled active filter indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 16, for the image for the active filterbar indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 18, for the image for the filterbar calendar indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 17, for the image for the inactive filterbar indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 8, for the image for the inactive filter indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 9, for the image for the disabled inactive filter indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 14, for the image for the row selector. This field is constant and read-only.  
    Public FieldSpecifies the index, 15, for the image for the disabled row selector. This field is constant and read-only.  
    Public FieldSpecifies the index, 4, for the image for the ascending sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 5, for the image for the disabled ascending sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 6, for the image for the descending sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 7, for the image for the disabled descending sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 12, for the image for the unsorted sort indicator. This field is constant and read-only.  
    Public FieldSpecifies the index, 13, for the image for the disabled unsorted sort indicator. This field is constant and read-only.  
    Top
    Protected Fields
     NameDescription
    Protected Fieldstatic (Shared in Visual Basic)Internal use only.  
    Protected Fieldstatic (Shared in Visual Basic)Internal use only.  
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets the active sheet in the view.  
    Public PropertyGets or sets whether to allow the cell content to float.  
    Public PropertyGets or sets whether data can overflow into adjacent empty cells in the view.  
    Public PropertyGets or sets whether to allow the user to move columns.  
    Public PropertyGets or sets whether to allow the user to move multiple columns.  
    Public PropertyGets or sets whether to allow the user to drag and drop a range of cells in the view.  
    Public PropertyGets or sets whether to allow the user to drag and fill cells with the contents of a cell or cells in the view.  
    Public PropertyGets or sets whether cell editor reserved mouse locations are allowed.  
    Public PropertyGets or sets whether data can overflow into adjacent empty cells while edit mode is on in a cell in the view.  
    Public PropertyGets or sets whether to allow the user to move rows.  
    Public PropertyGets or sets a value that indicates whether to allow moving the add new row or asterisk row.  
    Public PropertyGets or sets whether to allow the user to move multiple rows.  
    Public PropertyGets or sets whether sheets can be moved by dragging and dropping the sheet tab.  
    Public PropertyGets or sets whether to allow the user to undo edit operations.  
    Public PropertyGets or sets whether to allow the user to enter formulas in a cell in the view.  
    Public PropertyGets or sets whether to allow the user to scale the view using the Ctrl key and the mouse wheel.  
    Public PropertyGets or sets whether to allow shortcut keys for Clipboard actions in the view.  
    Public PropertyGets or sets the behavior of automatic fit when double-clicking the right edge of the column header.  
    Public PropertyGets or sets the behavior of automatic fit when double-clicking the bottom edge of the row header.  
    Public PropertyGets or sets whether to use the CharacterSet property on non-edit mode cells.  
    Public PropertyGets or sets whether adjacent cell borders are collapsed into a single line in the view.  
    Public PropertyGets the size and location of the view.  
    Public PropertyGets or sets whether to display buttons in button and combo box cells in the view.  
    Public PropertyGets or sets the cell note indicator renderer.  
    Public PropertyGets or sets whether the cell note indicator appears in cells in the view.  
    Public PropertyGets or sets the selection model to use when working with a span.  
    Public PropertyGets or sets whether headers and the filter bar are included with data in Clipboard actions in the view.  
    Public PropertyGets or sets whether a single cell copied to the Clipboard fills the range when pasted from the Clipboard to the component.  
    Public PropertyGets or sets the alignment of the column split box relative to the horizontal scroll bar in the view.  
    Public PropertyGets or sets when to display the column split box in the view.  
    Public PropertyGets the custom list for drag fill in series mode.  
    Public PropertyGets or sets a value that indicates whether the drag fill action copies data only.  
    Public PropertyGets the contol editing the active cell, or null if the control is not in edit mode.  
    Public PropertyGets or sets whether the active cell in the view is in edit mode.  
    Public PropertyGets or sets whether edit mode remains on for any cell in the view when that cell becomes active.  
    Public PropertyGets or sets whether the existing text in a cell in the view is selected when the cell enters edit mode.  
    Public PropertyGets or sets a value to show drag fill button and drag fill context menu.  
    Public PropertyGets or sets the renderer for the error icon.  
    Public PropertyGets or sets a renderer for drawing the focus rectangle in the view.  
    Public PropertyGets the horizontal scroll bar.  
    Public PropertyGets or sets the height of horizontal scroll bars in the view.  
    Public PropertyGets or sets when to display the horizontal scroll bars in the view.  
    Public PropertyGets or sets the small increment for the horizontal scrollbar.  
    Public PropertyGets or sets the interface renderer.  
    Public PropertyGets or sets the left most sheet tab in the tab strip in the view.  
    Public PropertyGets 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 Spread component that owns this view.  
    Public PropertyGets the parent (SpreadView object) of the view.  
    Public PropertyGets 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 PropertyGets or sets whether the selected range of cells in the view remains highlighted when the view loses the focus.  
    Public PropertyGets or set the alignment of the row split box relative to the vertical scroll bar in the view.  
    Public PropertyGets or sets when to display the row split box in the view.  
    Public PropertyGets or sets the scroll bar alignment with the last row and column of the spreadsheet in the view.  
    Public PropertyGets 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 PropertyGets or sets how the control scrolls the sheet when the user moves the scroll box.  
    Public PropertyGets or sets whether scroll tips appear when the user moves the scroll box.  
    Public PropertyGets or sets which types of selections the user can make in the view.  
    Public PropertyGets or sets a renderer for drawing selections in the view.  
    Public PropertyGets the sheets in the view.  
    Public PropertyGets or sets whether to allow the user to display a cell error using an icon or sticky note for cells in the view.  
    Public PropertyGets or sets whether the drag band is displayed when moving a row or column.  
    Public PropertyGets or sets whether to allow the user to display a row error using an icon or sticky note for cells in the view.  
    Public PropertyGets or sets the skin for the spread.  
    Public PropertyGets 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 PropertyGets or sets whether animations, such as an animated focus renderer, in the view are suspended.  
    Public PropertyGets or sets whether the special insert tab is present on the tab strip.  
    Public PropertyGets or sets the tabstrip insert-tab image.  
    Public PropertyGets or sets the location of the tab strip in the view.  
    Public PropertyGets or sets the display policy for the tab strip in the view.  
    Public PropertyGets or sets the width of the tab strip in the view expressed as a percentage of the overall horizontal width of the control.  
    Public PropertyGets or sets the appearance of text tips in the view.  
    Public PropertyGets 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 PropertyGets or sets whether to display text tips and the location of the tips in the view.  
    Public PropertyGets or sets the undo manager for the SpreadView.  
    Public PropertyGets the vertical scroll bar.  
    Public PropertyGets or sets when to display the vertical scroll bars in the view.  
    Public PropertyGets or sets the small increment for the vertical scrollbar.  
    Public PropertyGets or sets the width of vertical scroll bars in the view.  
    Public PropertyGets 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 MethodCancels cell editing in the view.  
    Public MethodCancels cell editing in the filter bar.  
    Public MethodOverloaded. Internal use only. Frees system resources consumed by the SpreadView.  
    Public MethodExpands or collapses the specified parent row, which shows or hides the child view in a hierarchical display.  
    Public MethodGets 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 MethodGets the rectangle of the cell.  
    Public MethodGets all child views (SpreadView objects) that have been created.  
    Public MethodGets 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 MethodGets the rectangle of the cell in the column header.  
    Public MethodGets the rectangle of the column header.  
    Public MethodGets the height of the column range group.  
    Public MethodGets the rectangle of the column split bar.  
    Public MethodGets the rectangle of the column split box.  
    Public MethodOverloaded. Gets the number of viewport columns in the active sheet.  
    Public MethodGets the index of the viewport column for the specified coordinate for the active sheet.  
    Public MethodGets the pointer displayed over a specific area in the view.  
    Public MethodGets the rectangle of the column header.  
    Public MethodGets the rectangle of the filter bar.  
    Public MethodReturns the floating cell range for the specified cell.  
    Public MethodReturns all floating cell ranges for the view.  
    Public MethodGets the rectangle of the horizontal scroll bar.  
    Public MethodGets 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 MethodGets the input map for the view for when a child object has focus.  
    Public MethodGets the input map for the view for when a shape has focus.  
    Public MethodGets the maximum cell overflow width in pixels for cells in the view.  
    Public MethodReturns the merged cell range for the specified cell.  
    Public MethodReturns all merged cell ranges for the view.  
    Public MethodSaves the view to the SerializationInfo object.  
    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 MethodGets the rectangle of the cell in the row header.  
    Public MethodGets the rectangle of the row header.  
    Public MethodGets the width of the row range group.  
    Public MethodGets the rectangle of the row split bar.  
    Public MethodGets the rectangle of the row split box.  
    Public MethodOverloaded. Gets the number of viewport rows in the active sheet.  
    Public MethodGets the index of the viewport row for the specified coordinate for the active sheet.  
    Public MethodGets the rectangle of the tab associated with a sheet for the view.  
    Public MethodGets the active sheet view.  
    Public MethodGets the view at the specified sheet and viewport.  
    Public MethodGets the rectangle of the split box on the tab strip.  
    Public MethodGets the rectangle of the tab strip.  
    Public MethodGets the rectangle of the vertical scroll bar.  
    Public MethodOverloaded. Gets the row after the last row of the specified viewport for the active sheet.  
    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 MethodGets 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 MethodGets the rectangle of the viewport.  
    Public MethodOverloaded. Gets the column after the rightmost column of the specified viewport for the active sheet.  
    Public MethodGet 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 MethodOverloaded. Gets the width of the specified viewport column for the active sheet.  
    Public MethodGets the left coordinate of the specified viewport column for the active sheet.  
    Public MethodGets the top coordinate of the specified viewport row for the active sheet.  
    Public MethodAttempts to find a value for one cell that will produce the desired formula result in another cell.  
    Public MethodOverloaded. Internal use only. Hides the dependents.  
    Public MethodOverloaded. Internal use only. Hides the precedents.  
    Public MethodReturns information about the given location.  
    Public MethodInvalidates the SpreadView and causes it to repaint.  
    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 MethodOccurs when exiting ink notation.  
    Public MethodOccurs when saving from ink notation.  
    Public MethodOverloaded. Removes a row or column of viewports.  
    Public MethodResets 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 MethodSets the action map.  
    Public MethodOverloaded. Sets the active viewport.  
    Public MethodSets the active SpreadView to the specified object. If the workbook passed in is null, sets this object to be the active SpreadView.  
    Public MethodSets the pointer displayed over a specific area at a specific time.  
    Public MethodSets the specified graphic for a specified part of the user interface.  
    Public MethodSets 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 MethodSets the input maps of this spreadview to another spread view.  
    Public MethodSets the input map for the view for when a child object has focus.  
    Public MethodSets the input map for the view for when a shape has focus.  
    Public MethodSets 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 MethodMoves the currently selected cell in the specified viewport to the specified position.  
    Public MethodShows the AutoFill indicator.  
    Public MethodMoves the specified cell in the specified viewport to the specified position.  
    Public MethodMoves a column in the specified viewport to the specified position.  
    Public MethodInternal use only. Shows the dependents.  
    Public MethodInternal use only. Shows the precedents.  
    Public MethodMoves a row in the specified viewport to the specified position.  
    Public MethodStarts cell editing in the view.  
    Public MethodStops cell editing in the view.  
    Public MethodStops cell editing in the filter bar.  
    Top
    Protected Methods
     NameDescription
    Protected MethodCancels column resizing.  
    Protected MethodCancels row resizing.  
    Protected MethodContinues selecting cells to the point of the specified coordinates.  
    Protected MethodContinues resizing the column to the specified x-coordinate.  
    Protected MethodContinues selecting columns to the point at the specified coordinates.  
    Protected MethodContinues drag and drop to the point of the specified coordinates.  
    Protected MethodContinues drag and fill to the point of the specified coordinates.  
    Protected MethodContinues moving the formula cell range.  
    Protected MethodContinues the formula cell range resizing.  
    Protected MethodContinues resizing the active TableView.  
    Protected MethodInternal use only. Creates a new view.  
    Protected MethodInvalidates the sheet corner.  
    Protected MethodOverloaded. Invalidates filter bar.  
    Protected MethodInvalidates filter bar header.  
    Protected MethodInvalidates the column footer corner.  
    Protected MethodInternal use only.  
    Protected MethodStarts selecting cells.  
    Protected MethodStarts resizing a column.  
    Protected MethodStarts selecting columns.  
    Protected MethodStarts drag and drop.  
    Protected MethodStarts drag and fill.  
    Protected MethodStarts the timer for painting animation.  
    Protected MethodStarts the scroll timer.  
    Protected MethodStart resizing the active TableView.  
    Protected MethodStarts the tip timer.  
    Protected MethodStops selecting cells.  
    Protected MethodStops resizing the column.  
    Protected MethodStops selecting the column.  
    Protected MethodStops drag and drop.  
    Protected MethodStops drag and fill.  
    Protected MethodStops the formula cell range from moving.  
    Protected MethodStops the formula cell range from resizing.  
    Protected MethodStops the scroll timer.  
    Protected MethodStops resizing table.  
    Protected MethodConverts a FarPoint.Win.Spread.CellHorizontalAlignment setting to the corresponding FarPoint.Win.HorizontalAlignment setting.  
    Protected MethodConverts a FarPoint.Win.Spread.CellVerticalAlignment setting to the corresponding FarPoint.Win.VerticalAlignment setting.  
    Top
    See Also