Name | Description | |
---|---|---|
![]() | SpreadView Constructor | Overloaded. |
The following tables list the members exposed by SpreadView.
Name | Description | |
---|---|---|
![]() | SpreadView Constructor | Overloaded. |
Name | Description | |
---|---|---|
![]() | CollapseImage | Specifies the index, 2, for the image for the collapse icon in a hiearchical display. |
![]() | CollapseImageDisabled | Specifies the index, 3, for the image for the disabled collapse icon in a hiearchical display. |
![]() | EditingRowSelector | Specifies the index, 19, for the image for the row editing indicator. |
![]() | EnhancedFilterActive | Specifies the index, 28, for the image for the enhanced active filter indicator. |
![]() | EnhancedFilterActiveDisabled | Specifies the index, 29, for the image for the enhanced disabled active filter indicator. |
![]() | EnhancedFilterInactive | Specifies the index, 30, for the image for the enhanced inactive filter indicator. |
![]() | EnhancedFilterInactiveDisabled | Specifies the index, 31, for the image for the enhanced disabled inactive filter indicator. |
![]() | EnhancedFilterSortAscending | Specifies the index, 20, for the image for the enhanced ascending filter sort indicator. |
![]() | EnhancedFilterSortAscendingDisabled | Specifies the index, 21, for the image for the enhanced disabled ascending filter sort indicator. |
![]() | EnhancedFilterSortDescending | Specifies the index, 24, for the image for the enhanced descending filter sort indicator. |
![]() | EnhancedFilterSortDescendingDisabled | Specifies the index, 25, for the image for the enhanced disabled descending filter sort indicator. |
![]() | EnhancedSortAscending | Specifies the index, 22, for the image for the enhanced ascending sort indicator. |
![]() | EnhancedSortAscendingDisabled | Specifies the index, 23, for the image for the enhanced disabled ascending sort indicator. |
![]() | EnhancedSortDescending | Specifies the index, 26, for the image for the enhanced descending sort indicator. |
![]() | EnhancedSortDescendingDisabled | Specifies the index, 27, for the image for the enhanced disabled descending sort indicator. |
![]() | ExpandImage | Specifies the index, 0, for the image for the expand icon in a hiearchical display. |
![]() | ExpandImageDisabled | Specifies the index, 1, for the image for the disabled expand icon in a hiearchical display. |
![]() | FilterActive | Specifies the index, 10, for the image for the active filter indicator. |
![]() | FilterActiveDisabled | Specifies the index, 11, for the image for the disabled active filter indicator. |
![]() | FilterBarFilterActive | Specifies the index, 16, for the image for the active filterbar indicator. |
![]() | FilterBarFilterDateTime | Specifies the index, 18, for the image for the filterbar calendar indicator. |
![]() | FilterBarFilterInactive | Specifies the index, 17, for the image for the inactive filterbar indicator. |
![]() | FilterInactive | Specifies the index, 8, for the image for the inactive filter indicator. |
![]() | FilterInactiveDisabled | Specifies the index, 9, for the image for the disabled inactive filter indicator. |
![]() | RowSelectorImage | Specifies the index, 14, for the image for the row selector. |
![]() | RowSelectorImageDisabled | Specifies the index, 15, for the image for the disabled row selector. |
![]() | SortAscendingImage | Specifies the index, 4, for the image for the ascending sort indicator. |
![]() | SortAscendingImageDisabled | Specifies the index, 5, for the image for the disabled ascending sort indicator. |
![]() | SortDescendingImage | Specifies the index, 6, for the image for the descending sort indicator. |
![]() | SortDescendingImageDisabled | Specifies the index, 7, for the image for the disabled descending sort indicator. |
![]() | SortUnsortedImage | Specifies the index, 12, for the image for the unsorted sort indicator. |
![]() | SortUnsortedImageDisabled | Specifies the index, 13, for the image for the disabled unsorted sort indicator. |
Name | Description | |
---|---|---|
![]() | ActiveSheetIndex | Gets or sets the active sheet in the view. |
![]() | AllowCellContentFloat | Gets or sets whether to allow the cell content to float. |
![]() | AllowCellOverflow | Gets or sets whether data can overflow into adjacent empty cells in the view. |
![]() | AllowColumnMove | Gets or sets whether to allow the user to move columns. |
![]() | AllowColumnMoveMultiple | Gets or sets whether to allow the user to move multiple columns. |
![]() | AllowDragDrop | Gets or sets whether to allow the user to drag and drop a range of cells in the view. |
![]() | AllowDragFill | Gets or sets whether to allow the user to drag and fill cells with the contents of a cell or cells in the view. |
![]() | AllowEditorReservedLocations | Gets or sets whether cell editor reserved mouse locations are allowed. |
![]() | AllowEditOverflow | Gets or sets whether data can overflow into adjacent empty cells while edit mode is on in a cell in the view. |
![]() | AllowRowMove | Gets or sets whether to allow the user to move rows. |
![]() | AllowRowMoveDataAllowAddNew | Gets or sets a value that indicates whether to allow moving the add new row or asterisk row. |
![]() | AllowRowMoveMultiple | Gets or sets whether to allow the user to move multiple rows. |
![]() | AllowSheetMove | Gets or sets whether sheets can be moved by dragging and dropping the sheet tab. |
![]() | AllowUndo | Gets or sets whether to allow the user to undo edit operations. |
![]() | AllowUserFormulas | Gets or sets whether to allow the user to enter formulas in a cell in the view. |
![]() | AllowUserZoom | Gets or sets whether to allow the user to scale the view using the Ctrl key and the mouse wheel. |
![]() | AutoClipboard | Gets or sets whether to allow shortcut keys for Clipboard actions in the view. |
![]() | AutoFitColumnOptions | Gets or sets the behavior of automatic fit when double-clicking the right edge of the column header. |
![]() | AutoFitRowOptions | Gets or sets the behavior of automatic fit when double-clicking the bottom edge of the row header. |
![]() | AutoImeMode | Gets or sets whether to use the CharacterSet property on non-edit mode cells. |
![]() | BorderCollapse | Gets or sets whether adjacent cell borders are collapsed into a single line in the view. |
![]() | Bounds | Gets the size and location of the view. |
![]() | ButtonDrawMode | Gets or sets whether to display buttons in button and combo box cells in the view. |
![]() | CellNoteIndicatorRenderer | Gets or sets the cell note indicator renderer. |
![]() | CellNoteIndicatorVisible | Gets or sets whether the cell note indicator appears in cells in the view. |
![]() | CellSpanSelectionPolicy | Gets or sets the selection model to use when working with a span. |
![]() | ClipboardOptions | Gets or sets whether headers and the filter bar are included with data in Clipboard actions in the view. |
![]() | ClipboardPasteToFill | Gets or sets whether a single cell copied to the Clipboard fills the range when pasted from the Clipboard to the component. |
![]() | ColumnSplitBoxAlignment | Gets or sets the alignment of the column split box relative to the horizontal scroll bar in the view. |
![]() | ColumnSplitBoxPolicy | Gets or sets when to display the column split box in the view. |
![]() | CustomFillSeriesList | Gets the custom list for drag fill in series mode. |
![]() | DragFillDataOnly | Gets or sets a value that indicates whether the drag fill action copies data only. |
![]() | EditingControl | Gets the contol editing the active cell, or null if the control is not in edit mode. |
![]() | EditMode | Gets or sets whether the active cell in the view is in edit mode. |
![]() | EditModePermanent | Gets or sets whether edit mode remains on for any cell in the view when that cell becomes active. |
![]() | EditModeReplace | Gets or sets whether the existing text in a cell in the view is selected when the cell enters edit mode. |
![]() | EnableDragFillMenu | Gets or sets a value to show drag fill button and drag fill context menu. |
![]() | ErrorIconRenderer | Gets or sets the renderer for the error icon. |
![]() | FocusRenderer | Gets or sets a renderer for drawing the focus rectangle in the view. |
![]() | HorizontalScrollBar | Gets the horizontal scroll bar. |
![]() | HorizontalScrollBarHeight | Gets or sets the height of horizontal scroll bars in the view. |
![]() | HorizontalScrollBarPolicy | Gets or sets when to display the horizontal scroll bars in the view. |
![]() | HorizontalScrollBarSmallChange | Gets or sets the small increment for the horizontal scrollbar. |
![]() | InterfaceRenderer | Gets or sets the interface renderer. |
![]() | LeftTab | Gets or sets the left most sheet tab in the tab strip in the view. |
![]() | MoveActiveOnFocus | 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. |
![]() | Owner | Gets the FpSpread object that owns this view. |
![]() | Parent | Gets the parent (SpreadView object) of the view. |
![]() | RangeDragFillMode | 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. |
![]() | RetainSelectionBlock | Gets or sets whether the selected range of cells in the view remains highlighted when the view loses the focus. |
![]() | RowSplitBoxAlignment | Gets or set the alignment of the row split box relative to the vertical scroll bar in the view. |
![]() | RowSplitBoxPolicy | Gets or sets when to display the row split box in the view. |
![]() | ScrollBarMaxAlign | Gets or sets the scroll bar alignment with the last row and column of the spreadsheet in the view. |
![]() | ScrollBarShowMax | 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. |
![]() | ScrollBarTrackPolicy | Gets or sets how the control scrolls the sheet when the user moves the scroll box. |
![]() | ScrollTipPolicy | Gets or sets whether scroll tips appear when the user moves the scroll box. |
![]() | SelectionBlockOptions | Gets or sets which types of selections the user can make in the view. |
![]() | SelectionRenderer | Gets or sets a renderer for drawing selections in the view. |
![]() | Sheets | Gets the sheets in the view. |
![]() | ShowCellErrors | Gets or sets whether to allow the user to display a cell error using an icon or sticky note for cells in the view. |
![]() | ShowDragBandOnMoving | Gets or sets whether the drag band is displayed when moving a row or column. |
![]() | ShowRowErrors | Gets or sets whether to allow the user to display a row error using an icon or sticky note for cells in the view. |
![]() | Skin | Gets or sets the skin for the spread. |
![]() | SpreadScaleMode | 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. |
![]() | SuspendAnimations | Gets or sets whether animations, such as an animated focus renderer, in the view are suspended. |
![]() | TabStripInsertTab | Gets or sets whether the special insert tab is present on the tab strip. |
![]() | TabStripInsertTabImage | Gets or sets the tabstrip insert-tab image. |
![]() | TabStripPlacement | Gets or sets the location of the tab strip in the view. |
![]() | TabStripPolicy | Gets or sets the display policy for the tab strip in the view. |
![]() | TabStripRatio | Gets or sets the width of the tab strip in the view expressed as a percentage of the overall horizontal width of the control. |
![]() | TextTipAppearance | Gets or sets the appearance of text tips in the view. |
![]() | TextTipDelay | 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. |
![]() | TextTipPolicy | Gets or sets whether to display text tips and the location of the tips in the view. |
![]() | UndoManager | Gets or sets the undo manager for the SpreadView. |
![]() | VerticalScrollBar | Gets the vertical scroll bar. |
![]() | VerticalScrollBarPolicy | Gets or sets when to display the vertical scroll bars in the view. |
![]() | VerticalScrollBarSmallChange | Gets or sets the small increment for the vertical scrollbar. |
![]() | VerticalScrollBarWidth | Gets or sets the width of vertical scroll bars in the view. |
![]() | VisualStyles | Gets or sets whether to use visual styles when rendering objects in the control. |
Name | Description | |
---|---|---|
![]() | AddViewport | Overloaded. Adds a row or column of viewports. |
![]() | CancelCellEditing | Cancels cell editing in the view. |
![]() | CancelFilterBarEditing | Cancels cell editing in the filter bar. |
![]() | ExpandRow | Expands or collapses the specified parent row, which shows or hides the child view in a hierarchical display. |
![]() | GetActionMap | Gets the action map. |
![]() | GetActiveColumnViewportIndex | Overloaded. Gets the index of the active viewport column. |
![]() | GetActiveRowViewportIndex | Overloaded. Gets the index of the active viewport row. |
![]() | GetActiveWorkbook | Gets the active view (SpreadView object). |
![]() | GetCellFromPixel | Overloaded. Gets the row and column indexes of the cell at the specified pointer location. |
![]() | GetCellRectangle | Gets the rectangle of the cell. |
![]() | GetChildWorkbooks | Gets all child views (SpreadView objects) that have been created. |
![]() | GetColumnFooterCellRectangle | Gets the rectangle of the cell in the column footer. |
![]() | GetColumnHeaderCellFromPixel | Overloaded. Gets the row and column indexes of the column header cell at the specified pointer location. |
![]() | GetColumnHeaderCellRectangle | Gets the rectangle of the cell in the column header. |
![]() | GetColumnHeaderRectangle | Gets the rectangle of the column header. |
![]() | GetColumnRangeGroupHeight | Gets the height of the column range group. |
![]() | GetColumnSplitBarRectangle | Gets the rectangle of the column split bar. |
![]() | GetColumnSplitBoxRectangle | Gets the rectangle of the column split box. |
![]() | GetColumnViewportCount | Overloaded. Gets the number of viewport columns in the active sheet. |
![]() | GetColumnViewportIndexFromX | Gets the index of the viewport column for the specified coordinate for the active sheet. |
![]() | GetCursor | Gets the pointer displayed over a specific area in the view. |
![]() | GetFilterBarHeaderRectangle | Gets the rectangle of the column header. |
![]() | GetFilterBarRectangle | Gets the rectangle of the filter bar. |
![]() | GetFloatCell | Returns the floating cell range for the specified cell. |
![]() | GetFloatCells | Returns all floating cell ranges for the view. |
![]() | GetHorizontalScrollBarRectangle | Gets the rectangle of the horizontal scroll bar. |
![]() | GetImage | Gets the graphic image used in the specified part of the user interface. |
![]() | GetInputMap | Overloaded. Gets the input map defined for the specified focus mode for the view. |
![]() | GetInputMapWhenChildHasFocus | Gets the input map for the view for when a child object has focus. |
![]() | GetInputMapWhenShapeHasFocus | Gets the input map for the view for when a shape has focus. |
![]() | GetMaximumCellOverflowWidth | Gets the maximum cell overflow width in pixels for cells in the view. |
![]() | GetMergeCell | Returns the merged cell range for the specified cell. |
![]() | GetMergeCells | Returns all merged cell ranges for the view. |
![]() | GetRootWorkbook | Gets the top view (SpreadView object). |
![]() | GetRowHeaderCellFromPixel | Overloaded. Gets the row and column indexes of the row header cell at the specified pointer location. |
![]() | GetRowHeaderCellRectangle | Gets the rectangle of the cell in the row header. |
![]() | GetRowHeaderRectangle | Gets the rectangle of the row header. |
![]() | GetRowRangeGroupWidth | Gets the width of the row range group. |
![]() | GetRowSplitBarRectangle | Gets the rectangle of the row split bar. |
![]() | GetRowSplitBoxRectangle | Gets the rectangle of the row split box. |
![]() | GetRowViewportCount | Overloaded. Gets the number of viewport rows in the active sheet. |
![]() | GetRowViewportIndexFromY | Gets the index of the viewport row for the specified coordinate for the active sheet. |
![]() | GetSheetTabRectangle | Gets the rectangle of the tab associated with a sheet for the view. |
![]() | GetSheetView | Gets the active sheet view. |
![]() | GetSpreadView | Gets the view at the specified sheet and viewport. |
![]() | GetTabSplitBoxRectangle | Gets the rectangle of the split box on the tab strip. |
![]() | GetTabStripRectangle | Gets the rectangle of the tab strip. |
![]() | GetVerticalScrollBarRectangle | Gets the rectangle of the vertical scroll bar. |
![]() | GetViewportBottomRow | Overloaded. Gets the index of the bottom row of the specified viewport row. |
![]() | GetViewportHeight | Overloaded. Gets the height of the specified viewport row for the active sheet. |
![]() | GetViewportLeftColumn | Overloaded. Gets the index of the left most column of the specified viewport column. |
![]() | GetViewportLeftOffset | Gets the offset of the view port from a particular column to the left. |
![]() | GetViewportPreferredHeight | Overloaded. Gets the maximum height for the viewport row. |
![]() | GetViewportPreferredWidth | Overloaded. Gets the maximum width for the viewport column. |
![]() | GetViewportRectangle | Gets the rectangle of the viewport. |
![]() | GetViewportRightColumn | Overloaded. Gets the index of the right most column of the specified viewport column. |
![]() | GetViewportTopOffset | Get offset of the view port from a particular row to the top. |
![]() | GetViewportTopRow | Overloaded. Gets the index of the top row of the specified viewport row. |
![]() | GetViewportWidth | Overloaded. Gets the width of the specified viewport column for the active sheet. |
![]() | GetViewportX | Gets the left coordinate of the specified viewport column for the active sheet. |
![]() | GetViewportY | Gets the top coordinate of the specified viewport row for the active sheet. |
![]() | GoalSeek | Attempts to find a value for one cell that will produce the desired formula result in another cell. |
![]() | HitTest | Returns information about the given location. |
![]() | LoadXmlInputMapFile | Overloaded. Loads the XML input map file using the specified input map mode and operation mode. |
![]() | LoadXmlInputMapFileWhenChildHasFocus | Overloaded. Loads the XML input map file when the child has focus. |
![]() | LoadXmlInputMapFileWhenShapeHasFocus | Overloaded. Loads the XML input map file when the shape has focus. |
![]() | RemoveViewport | Overloaded. Removes a row or column of viewports. |
![]() | Reset | Resets the active view to its default settings. |
![]() | SaveXmlInputMapFile | Overloaded. Saves the XML input map file. |
![]() | SaveXmlInputMapFileWhenChildHasFocus | Overloaded. Saves the XML input map file when the child has focus. |
![]() | SaveXmlInputMapFileWhenShapeHasFocus | Overloaded. Saves the XML input map file when the shape has focus. |
![]() | SetActionMap | Sets the action map. |
![]() | SetActiveViewport | Overloaded. Sets the active viewport. |
![]() | SetActiveWorkbook | Sets the active SpreadView to the specified object. If the workbook passed in is null, sets this object to be the active SpreadView. |
![]() | SetCursor | Sets the pointer displayed over a specific area at a specific time. |
![]() | SetImage | Sets the specified graphic for a specified part of the user interface. |
![]() | SetImageDPISupport | Sets the multiscaling versions of specified graphic for a specified part of the user interface. |
![]() | SetInputMap | Overloaded. Sets the input map for the view for the specified focus mode. |
![]() | SetInputMapToOtherSpreadView | Sets the input maps of this spreadview to another spread view. |
![]() | SetInputMapWhenChildHasFocus | Sets the input map for the view for when a child object has focus. |
![]() | SetInputMapWhenShapeHasFocus | Sets the input map for the view for when a shape has focus. |
![]() | SetMaximumCellOverflowWidth | Sets the maximum cell overflow width in pixels for cells in the view. |
![]() | SetViewportLeftColumn | Overloaded. Sets the index of the left most column of the specified viewport column. |
![]() | SetViewportPreferredHeight | Overloaded. Sets the maximum height for the viewport row. |
![]() | SetViewportPreferredWidth | Overloaded. Sets the maximum width for the viewport column. |
![]() | SetViewportTopRow | Overloaded. Sets the index of the top row of the specified viewport row. |
![]() | ShowActiveCell | Moves the currently selected cell in the specified viewport to the specified position. |
![]() | ShowAutoFillIndicator | Shows the AutoFill indicator. |
![]() | ShowCell | Moves the specified cell in the specified viewport to the specified position. |
![]() | ShowColumn | Moves a column in the specified viewport to the specified position. |
![]() | ShowRow | Moves a row in the specified viewport to the specified position. |
![]() | StartCellEditing | Starts cell editing in the view. |
![]() | StopCellEditing | Stops cell editing in the view. |
![]() | StopFilterBarEditing | Stops cell editing in the filter bar. |
Name | Description | |
---|---|---|
![]() | InvalidateFilterBar | Overloaded. Invalidates filter bar. |
![]() | InvalidateFilterBarHeader | Invalidates filter bar header. |
![]() | InvalidateFooterCorner | Invalidates the column footer corner. |
![]() | StartTableResizing | Start resizing the active TableView. |
![]() | StopFormulaCellRangeMoving | Stops the formula cell range from moving. |
![]() | StopFormulaCellRangeResizing | Stops the formula cell range from resizing. |
![]() | StopTableResizing | Stops resizing table. |
SpreadView Class
FarPoint.Win.Spread Namespace
FpSpread Class
SheetView Class
Customizing Viewports
Working with Hierarchical Data Display