The following tables list the members exposed by FpSpread.
Name | Description | |
---|---|---|
FpSpread Constructor | Creates a new Spreadsheet component. |
Name | Description | |
---|---|---|
About | Gets the version information about the component. | |
AccessibilityObject | Gets the System.Windows.Forms.AccessibleObject assigned to the control. (Inherited from System.Windows.Forms.Control) | |
AccessibleDefaultActionDescription | Gets or sets the default action description of the control for use by accessibility client applications. (Inherited from System.Windows.Forms.Control) | |
AccessibleDescription | Gets or sets the description of the control used by accessibility client applications. (Inherited from System.Windows.Forms.Control) | |
AccessibleName | Gets or sets the name of the control used by accessibility client applications. (Inherited from System.Windows.Forms.Control) | |
AccessibleRole | Gets or sets the accessible role of the control (Inherited from System.Windows.Forms.Control) | |
ActiveChartIndicator | Gets the active chart indicator. | |
ActiveChildControl | Gets or sets the active embedded child control object of the sheet. | |
ActiveSheet | Gets or sets the active sheet in the component. | |
ActiveSheetIndex | Gets or sets the index of the active sheet in the component. | |
AllowCellOverflow | Gets or sets whether data can overflow into adjacent empty cells in the component. | |
AllowChildControlDesign | Gets or sets whether child controls allow user actions for design. | |
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 component. | |
AllowDragFill | Gets or sets whether to allow the user to drag and fill cells in the component with the contents of a cell or cells. | |
AllowDrop | Gets or sets a value indicating whether the control can accept data that the user drags onto it. (Inherited from System.Windows.Forms.Control) | |
AllowEditorReservedLocations | ||
AllowEditOverflow | Gets or sets whether data can overflow into adjacent empty cells in the component while that cell is in edit mode. | |
AllowRowMove | Gets or sets whether to allow the user to move rows. | |
AllowRowMoveDataAllowAddNew | Gets or sets a value that indicates whether to allow the user to move 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 drag-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 component. | |
AllowUserZoom | Gets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel. | |
Anchor | Gets or sets the edges of the container to which a control is bound and determines how a control is resized with its parent. (Inherited from System.Windows.Forms.Control) | |
AutoClipboard | Gets or sets whether the component handles the shortcut keys for Clipboard actions. | |
AutoLaunchSpreadDesigner | Gets or sets whether Spread Designer automatically launches when a Spread component is placed on a form. | |
AutoScrollOffset | Gets or sets where this control is scrolled to in System.Windows.Forms.ScrollableControl.ScrollControlIntoView(System.Windows.Forms.Control). (Inherited from System.Windows.Forms.Control) | |
BackColor | Gets or sets the background color for the control. (Inherited from System.Windows.Forms.Control) | |
BackgroundImage | Overridden. Gets or sets the image to paint in the background of the component. | |
BackgroundImageLayout | Gets or sets the background image layout as defined in the System.Windows.Forms.ImageLayout enumeration. (Inherited from System.Windows.Forms.Control) | |
BindingContext | Gets or sets the System.Windows.Forms.BindingContext for the control. (Inherited from System.Windows.Forms.Control) | |
BorderCollapse | Gets or sets whether adjacent cell borders are collapsed into a single line for cells in the component. | |
BorderStyle | Gets or sets the style of the border around the component. | |
Bottom | Gets the distance, in pixels, between the bottom edge of the control and the top edge of its container's client area. (Inherited from System.Windows.Forms.Control) | |
Bounds | Gets or sets the size and location of the control including its nonclient elements, in pixels, relative to the parent control. (Inherited from System.Windows.Forms.Control) | |
ButtonDrawMode | Gets or sets whether to display buttons in button and combo box cells in the component. | |
CanFocus | Gets a value indicating whether the control can receive focus. (Inherited from System.Windows.Forms.Control) | |
CanSelect | Gets a value indicating whether the control can be selected. (Inherited from System.Windows.Forms.Control) | |
Capture | Gets or sets a value indicating whether the control has captured the mouse. (Inherited from System.Windows.Forms.Control) | |
CausesValidation | Gets or sets a value indicating whether the control causes validation to be performed on any controls that require validation when it receives focus. (Inherited from System.Windows.Forms.Control) | |
CellNoteIndicatorRenderer | Gets or sets the cell note indicator renderer for drawing the cell note indicator in the component. | |
CellNoteIndicatorVisible | Gets or sets whether the cell note indicator appears in cells in the component. | |
ClientRectangle | Gets the rectangle that represents the client area of the control. (Inherited from System.Windows.Forms.Control) | |
ClientSize | Gets or sets the height and width of the client area of the control. (Inherited from System.Windows.Forms.Control) | |
ClipboardOptions | Gets or sets whether headers are included when data is copied to or pasted from the Clipboard in the component. | |
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 for this component. | |
ColumnSplitBoxPolicy | Gets or sets the display policy for the column split box for this component. | |
CompanyName | Gets the name of the company or creator of the application containing the control. (Inherited from System.Windows.Forms.Control) | |
Container | (Inherited from System.ComponentModel.Component) | |
ContainsFocus | Gets a value indicating whether the control, or one of its child controls, currently has the input focus. (Inherited from System.Windows.Forms.Control) | |
ContextMenu | Gets or sets the shortcut menu associated with the control. (Inherited from System.Windows.Forms.Control) | |
ContextMenuStrip | Gets or sets the System.Windows.Forms.ContextMenuStrip associated with this control. (Inherited from System.Windows.Forms.Control) | |
Controls | Gets the collection of controls contained within the control. (Inherited from System.Windows.Forms.Control) | |
Created | Gets a value indicating whether the control has been created. (Inherited from System.Windows.Forms.Control) | |
Cursor | Overridden. Gets or sets the pointer to display in this component. | |
DataBindings | Gets the data bindings for the control. (Inherited from System.Windows.Forms.Control) | |
DataMember | Gets or sets the name of the data member that populates the active sheet in this component. | |
DataSource | Gets or sets the name of the data source that populates the active sheet in this component. | |
DisplayRectangle | Gets the rectangle that represents the display area of the control. (Inherited from System.Windows.Forms.Control) | |
Disposing | Gets a value indicating whether the base System.Windows.Forms.Control class is in the process of disposing. (Inherited from System.Windows.Forms.Control) | |
Dock | Gets or sets which control borders are docked to its parent control and determines how a control is resized with its parent. (Inherited from System.Windows.Forms.Control) | |
EditingControl | Gets the Control object editing the active cell, or null if the component is not in edit mode. | |
EditMode | Gets or sets whether the active cell in the component is in edit mode. | |
EditModePermanent | Gets or sets whether edit mode remains on for any cell in the component when that cell becomes active. | |
EditModeReplace | Gets or sets whether the existing contents of a cell in the component are selected when that cell enters edit mode. | |
EnableCrossSheetReference | Enables cross-sheet referencing for this component. | |
Enabled | Gets or sets a value indicating whether the control can respond to user interaction. (Inherited from System.Windows.Forms.Control) | |
Focused | Gets a value indicating whether the control has input focus. (Inherited from System.Windows.Forms.Control) | |
FocusRenderer | Gets or sets the focus indicator renderer for drawing the focus rectangle in the component. | |
Font | Overridden. Gets or sets the default Font for sheets in the component. | |
Handle | Gets the window handle that the control is bound to. (Inherited from System.Windows.Forms.Control) | |
HasChildren | Gets a value indicating whether the control contains one or more child controls. (Inherited from System.Windows.Forms.Control) | |
Height | Gets or sets the height of the control. (Inherited from System.Windows.Forms.Control) | |
HorizontalScrollBar | Gets horizontal scroll bar. | |
HorizontalScrollBarHeight | Gets or sets the height of horizontal scroll bars in this component. | |
HorizontalScrollBarPolicy | Gets or sets when to display the horizontal scroll bars in this component. | |
HorizontalScrollBarSmallChange | Gets or sets the small increment for the horizontal scrollbar. | |
ImeMode | Gets or sets the Input Method Editor (IME) mode of the control. (Inherited from System.Windows.Forms.Control) | |
InterfaceRenderer | Gets or sets the tab strip renderer for drawing tab strip elements. | |
InvokeRequired | Gets a value indicating whether the caller must call an invoke method when making method calls to the control because the caller is on a different thread than the one the control was created on. (Inherited from System.Windows.Forms.Control) | |
IsAccessible | Gets or sets a value indicating whether the control is visible to accessibility applications. (Inherited from System.Windows.Forms.Control) | |
IsDisposed | Gets a value indicating whether the control has been disposed of. (Inherited from System.Windows.Forms.Control) | |
IsHandleCreated | Gets a value indicating whether the control has a handle associated with it. (Inherited from System.Windows.Forms.Control) | |
IsLayoutSuspended | Returns whether the layout is suspended in this component. | |
IsMirrored | Gets a value indicating whether the control is mirrored. (Inherited from System.Windows.Forms.Control) | |
LayoutEngine | Gets a cached instance of the control's layout engine. (Inherited from System.Windows.Forms.Control) | |
Left | Gets or sets the distance, in pixels, between the left edge of the control and the left edge of its container's client area. (Inherited from System.Windows.Forms.Control) | |
LeftTab | Gets or sets the leftmost sheet tab of the component. | |
Location | Gets or sets the coordinates of the upper-left corner of the control relative to the upper-left corner of its container. (Inherited from System.Windows.Forms.Control) | |
Margin | Gets or sets the space between controls. (Inherited from System.Windows.Forms.Control) | |
MaximumSize | Gets or sets the size that is the upper limit that System.Windows.Forms.Control.GetPreferredSize(System.Drawing.Size) can specify. (Inherited from System.Windows.Forms.Control) | |
MinimumSize | Gets or sets the size that is the lower limit that System.Windows.Forms.Control.GetPreferredSize(System.Drawing.Size) can specify. (Inherited from System.Windows.Forms.Control) | |
MoveActiveOnFocus | Gets or sets whether the location of the active cell moves when the user moves the focus to the view using the mouse. | |
Name | Gets or sets the name of the Spread component. | |
NamedStyles | Gets or sets a pre-defined style (NamedStyleCollection object). | |
Padding | Gets or sets padding within the control. (Inherited from System.Windows.Forms.Control) | |
Parent | Gets or sets the parent container of the control. (Inherited from System.Windows.Forms.Control) | |
PreferredSize | Gets the size of a rectangular area into which the control can fit. (Inherited from System.Windows.Forms.Control) | |
ProductName | Gets the product name of the assembly containing the control. (Inherited from System.Windows.Forms.Control) | |
ProductVersion | Gets the version of the assembly containing the control. (Inherited from System.Windows.Forms.Control) | |
RecreatingHandle | Gets a value indicating whether the control is currently re-creating its handle. (Inherited from System.Windows.Forms.Control) | |
Region | Gets or sets the window region associated with the control. (Inherited from System.Windows.Forms.Control) | |
RetainSelectionBlock | Gets or sets whether the selected range of cells remains highlighted when the component loses the focus. | |
Right | Gets the distance, in pixels, between the right edge of the control and the left edge of its container's client area. (Inherited from System.Windows.Forms.Control) | |
RightToLeft | Gets or sets a value indicating whether control's elements are aligned to support locales using right-to-left fonts. (Inherited from System.Windows.Forms.Control) | |
RowSplitBoxAlignment | Gets or sets the alignment of the row split box relative to the vertical scroll bar for this component. | |
RowSplitBoxPolicy | Gets or sets the display policy of the row split box in this component. | |
ScrollBarMaxAlign | Gets or sets whether the scroll bar aligns with the last row and column of the active sheet in the component. | |
ScrollBarShowMax | Gets or sets whether the displayed scroll bars are based on the entire number of columns and rows in the sheet. | |
ScrollBarTrackPolicy | Gets or sets whether the sheet in the component scrolls when the user moves the scroll box. | |
ScrollTipPolicy | Gets or sets whether scroll tips appear when the user moves the scroll box in the component. | |
SearchDialog | Gets the dialog associated with searching for text in a cell of a sheet in this component. | |
SelectionBlockOptions | Gets or sets which type of selections in the component the user can make. | |
SelectionRenderer | Gets or sets the selection renderer for drawing selections in the component. | |
Sheets | Gets the sheets (SheetView objects) in the component. | |
Site | Gets or sets the site of the control. (Inherited from System.Windows.Forms.Control) | |
Size | Gets or sets the height and width of the control. (Inherited from System.Windows.Forms.Control) | |
Skin | Gets or sets the skin for the spread. | |
SuspendAnimations | Gets or sets whether to suspend animations such as an animated focus renderer. | |
TabIndex | Gets or sets the tab order of the control within its container. (Inherited from System.Windows.Forms.Control) | |
TabStop | Gets or sets a value indicating whether the user can give the focus to this control using the TAB key. (Inherited from System.Windows.Forms.Control) | |
TabStrip | Gets the object representing the tab strip for this component. | |
TabStripInsertTab | Gets or sets whether a special tab is displayed to allow inserting new sheets. | |
TabStripInsertTabImage | Gets or sets the tabstrip insert-tab image. | |
TabStripPlacement | Gets or sets the location of the tab strip. | |
TabStripPolicy | Gets or sets the display policy for the sheet tab strip for this component. | |
TabStripRatio | Gets or sets the width of the tab strip for this component expressed as a percentage of the overall horizontal scroll bar width. | |
Tag | Gets or sets extra data for the application for this component. | |
TextTipAppearance | Gets or sets the appearance of text tips in the view. | |
TextTipDelay | Gets or sets the time (in milliseconds) the component waits before displaying the text tip for the cell or header under the pointer. | |
TextTipPolicy | Gets or sets whether to display text tips and cell notes and the location of the tips and notes in this component. | |
TitleInfo | Gets or sets the collection of title information objects for the Spread | |
Top | Gets or sets the distance, in pixels, between the top edge of the control and the top edge of its container's client area. (Inherited from System.Windows.Forms.Control) | |
TopLevelControl | Gets the parent control that is not parented by another Windows Forms control. Typically, this is the outermost System.Windows.Forms.Form that the control is contained in. (Inherited from System.Windows.Forms.Control) | |
UndoManager | Gets or sets the undo manager for this Spread component. | |
UseWaitCursor | Gets or sets a value indicating whether to use the wait cursor for the current control and all child controls. (Inherited from System.Windows.Forms.Control) | |
VerticalScrollBar | Gets vertical scroll bar. | |
VerticalScrollBarPolicy | Gets or sets when to display the vertical scroll bars in this component. | |
VerticalScrollBarSmallChange | Gets or sets the small increment for the horizontal scrollbar. | |
VerticalScrollBarWidth | Gets or sets the width of vertical scroll bars in this component. | |
Visible | Gets or sets a value indicating whether the control and all its child controls are displayed. (Inherited from System.Windows.Forms.Control) | |
VisualStyles | Gets or sets whether to use visual styles when rendering objects in the component. | |
Width | Gets or sets the width of the control. (Inherited from System.Windows.Forms.Control) | |
ZoomFactor | Gets or sets the scaling factor of the display of the active sheet in this component. |
Name | Description | |
---|---|---|
CanEnableIme | Gets a value indicating whether the System.Windows.Forms.Control.ImeMode property can be set to an active value, to enable IME support. (Inherited from System.Windows.Forms.Control) | |
CanRaiseEvents | Determines if events can be raised on the control. (Inherited from System.Windows.Forms.Control) | |
DefaultCursor | Gets or sets the default cursor for the control. (Inherited from System.Windows.Forms.Control) | |
DefaultImeMode | Gets the default Input Method Editor (IME) mode supported by the control. (Inherited from System.Windows.Forms.Control) | |
DefaultMargin | Gets the space, in pixels, that is specified by default between controls. (Inherited from System.Windows.Forms.Control) | |
DefaultMaximumSize | Gets the length and height, in pixels, that is specified as the default maximum size of a control. (Inherited from System.Windows.Forms.Control) | |
DefaultMinimumSize | Gets the length and height, in pixels, that is specified as the default minimum size of a control. (Inherited from System.Windows.Forms.Control) | |
DefaultPadding | Gets the internal spacing, in pixels, of the contents of a control. (Inherited from System.Windows.Forms.Control) | |
DefaultSize | Overridden. Gets the default size of the component. | |
DoubleBuffered | Gets or sets a value indicating whether this control should redraw its surface using a secondary buffer to reduce or prevent flicker. (Inherited from System.Windows.Forms.Control) | |
Events | (Inherited from System.ComponentModel.Component) | |
FontHeight | Gets or sets the height of the font of the control. (Inherited from System.Windows.Forms.Control) | |
ImeModeBase | Gets or sets the IME mode of a control. (Inherited from System.Windows.Forms.Control) | |
ResizeRedraw | Gets or sets a value indicating whether the control redraws itself when resized. (Inherited from System.Windows.Forms.Control) |
Name | Description | |
---|---|---|
AddControl | Overloaded. Adds a child control to a specified sheet at the location of the specified row and column. | |
AddViewport | Overloaded. Adds a row or column of viewports. | |
BeginInvoke | Overloaded. Executes the specified delegate asynchronously on the thread that the control's underlying handle was created on. (Inherited from System.Windows.Forms.Control) | |
BringToFront | Brings the control to the front of the z-order. (Inherited from System.Windows.Forms.Control) | |
CancelAnnotationMode | Cancels annotation mode. | |
CancelCellEditing | Cancels cell editing. | |
Contains | Retrieves a value indicating whether the specified control is a child of the control. (Inherited from System.Windows.Forms.Control) | |
CreateControl | Forces the creation of the visible control, including the creation of the handle and any visible child controls. (Inherited from System.Windows.Forms.Control) | |
CreateGraphics | Creates the System.Drawing.Graphics for the control. (Inherited from System.Windows.Forms.Control) | |
DrawToBitmap | Supports rendering to the specified bitmap. (Inherited from System.Windows.Forms.Control) | |
EndInvoke | Retrieves the return value of the asynchronous operation represented by the System.IAsyncResult passed. (Inherited from System.Windows.Forms.Control) | |
FindForm | Retrieves the form that the control is on. (Inherited from System.Windows.Forms.Control) | |
Focus | Sets input focus to the control. (Inherited from System.Windows.Forms.Control) | |
GetActionMap | Gets the action map, that maps action identifiers (for keystrokes) to particular actions. | |
GetActiveColumnViewportIndex | Overloaded. Gets the index of the active viewport column for the active sheet. | |
GetActiveRowViewportIndex | Overloaded. Gets the index of the active viewport row for the active sheet. | |
GetCellFromPixel | Gets the row and column indexes of the cell at the specified pointer location. | |
GetCellRectangle | Gets the rectangle of the cell. | |
GetChildAtPoint | Overloaded. Retrieves the child control that is located at the specified coordinates, specifying whether to ignore child controls of a certain type. (Inherited from System.Windows.Forms.Control) | |
GetColumnHeaderRectangle | Gets the rectangle of the column header. | |
GetColumnPageBreaks | Overloaded. Gets the column page breaks for the specified sheet under the current printing conditions. | |
GetColumnRangeGroupHeight | Gets the height of the Column RangeGroup. | |
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. | |
GetContainerControl | Returns the next System.Windows.Forms.ContainerControl up the control's chain of parent controls. (Inherited from System.Windows.Forms.Control) | |
GetCursor | Gets the pointer displayed over different areas of the component. | |
GetExcelSheetNames | Overloaded. Gets an array of sheet names from the specified Excel stream. | |
GetHorizontalScrollBarRectangle | Gets the rectangle of the horizontal scroll bar. | |
GetInputMap | Overloaded. Gets the input map defined for the specified focus mode. | |
GetInputMapWhenChildHasFocus | Gets the input map when a child control has keyboard focus. | |
GetInputMapWhenShapeHasFocus | Gets the input map when a shape has keyboard focus. | |
GetMaximumCellOverflowWidth | Gets the maximum cell overflow width in pixels. | |
GetOwnerPrintColumnPageBreaks | Gets the column page breaks for the specified sheet under the current printing conditions. | |
GetOwnerPrintPageCount | Gets the number of pages required to print a given sheet into the supplied rectangle. | |
GetOwnerPrintRowPageBreaks | Gets the row page breaks for the specified sheet under the current printing conditions. | |
GetPreferredSize | Retrieves the size of a rectangular area into which a control can be fitted. (Inherited from System.Windows.Forms.Control) | |
GetPrintPageCount | Gets the number of pages required to print the specified sheet. | |
GetPrintPreview | Gets the print preview dialog. | |
GetRootWorkbook | Gets the main workbook associated with the Spread component. | |
GetRowHeaderRectangle | Gets the rectangle of the row header. | |
GetRowPageBreaks | Overloaded. Gets the row page breaks for the specified sheet under the current printing conditions. | |
GetRowRangeGroupWidth | Gets the width of the Row RangeGroup. | |
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. | |
GetRowViewportIndexFromY | Gets the index of the viewport row for the specified coordinate for the active sheet. | |
GetSheetFromTag | Gets a sheet with a specific tag. | |
GetSheetTabRectangle | Gets the rectangle of the tab associated with a sheet. | |
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 bottom row of cells of the specified viewport row for the active sheet. | |
GetViewportLeftColumn | Overloaded. Gets the leftmost column of cells of the specified viewport column for the active sheet. | |
GetViewportPreferredHeight | Overloaded. Gets the maximum height of the viewport row for the active sheet. | |
GetViewportPreferredWidth | Overloaded. Gets the maximum width of the specified viewport column. | |
GetViewportRectangle | Gets the rectangle of the viewport. | |
GetViewportRightColumn | Overloaded. Gets the rightmost column of cells of the specified viewport column for the active sheet. | |
GetViewportTopRow | Overloaded. Gets the top row of cells of the specified viewport row for the specified sheet. | |
GoalSeek | Attempts to find the value for one cell that produces the desired formula result in another cell. | |
Hide | Conceals the control from the user. (Inherited from System.Windows.Forms.Control) | |
HitTest | Performs a hit test. | |
Invalidate | Overloaded. Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. (Inherited from System.Windows.Forms.Control) | |
Invoke | Overloaded. Executes the specified delegate on the thread that owns the control's underlying window handle. (Inherited from System.Windows.Forms.Control) | |
IsCellInView | Returns whether the cell at the specified location is visible in the specified view. | |
IsExcelFile | Overloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered an Excel file. | |
IsExcelStream | Overloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered a stream containing an Excel workbook. | |
IsSpreadSSFile | Opens the specified file and determines whether it meets the minimal requirements to be considered a Spread SS file. | |
IsSpreadXmlFile | Opens the specified file and determines whether it meets the minimal requirements to be considered a Spread XML file. | |
LoadFormulas | Loads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized. | |
OnClipboardChanging | Raises the ClipboardChanging event. | |
Open | Overloaded. Opens a saved XML file. | |
OpenExcel | Overloaded. Opens an Excel Compound Document File and loads it into Spread. | |
OpenSpreadFile | Opens a saved Spread file. | |
OwnerPrintDraw | Prints the specified page of the specified sheet to a specified graphics interface with the specified size. | |
PerformLayout | Overloaded. Forces the Spread component to apply layout logic to its child controls. | |
PointToClient | Computes the location of the specified screen point into client coordinates. (Inherited from System.Windows.Forms.Control) | |
PointToScreen | Computes the location of the specified client point into screen coordinates. (Inherited from System.Windows.Forms.Control) | |
PreProcessControlMessage | Preprocesses keyboard or input messages within the message loop before they are dispatched. (Inherited from System.Windows.Forms.Control) | |
PrintSheet | Overloaded. Handles the printing of the specified sheet in a separate thread. | |
RectangleToClient | Computes the size and location of the specified screen rectangle in client coordinates. (Inherited from System.Windows.Forms.Control) | |
RectangleToScreen | Computes the size and location of the specified client rectangle in screen coordinates. (Inherited from System.Windows.Forms.Control) | |
Refresh | Forces the control to invalidate its client area and immediately redraw itself and any child controls. (Inherited from System.Windows.Forms.Control) | |
RemoveControl | Removes a child control from the specified sheet. | |
RemoveViewport | Overloaded. Removes a row or column of viewports. | |
Reset | Resets the component to its original state. | |
ResetCellNoteIndicatorRenderer | Resets the focus renderer to its original state. | |
ResetFocusRenderer | Resets the focus renderer to its original state. | |
ResetText | Resets the System.Windows.Forms.Control.Text property to its default value. (Inherited from System.Windows.Forms.Control) | |
ResumeLayout | Overloaded. Resumes normal layout logic. | |
Save | Overloaded. Saves the contents of the Spread component to the specified file. | |
SaveExcel | Overloaded. Saves the contents of the Spread component to the specified stream. | |
Scale | (Inherited from System.Windows.Forms.Control) | |
Search | Overloaded. Searches the text in the specified range of cells in the specified sheet for the specified string with the specified criteria. | |
SearchHeaders | Overloaded. Searches the text in the header cells in the specified sheet for the specified string. | |
SearchWithDialog | Overloaded. Searches the text in the cells of the active sheet for the search string with the default criteria using a provided search dialog. | |
SearchWithDialogAdvanced | Overloaded. Searches the text in the cells of the sheets for the search string with the default criteria using a provided advanced search dialog. | |
SelectNextControl | Activates the next control. (Inherited from System.Windows.Forms.Control) | |
SendToBack | Sends the control to the back of the z-order. (Inherited from System.Windows.Forms.Control) | |
SetActionMap | Sets the action map, that maps action identifiers (for keystrokes) to particular actions. | |
SetActiveViewport | Overloaded. Sets the active viewport for the active sheet. | |
SetBounds | Overloaded. Sets the bounds of the control to the specified location and size. (Inherited from System.Windows.Forms.Control) | |
SetCursor | Sets the pointer displayed over different areas of the component. | |
SetInputMap | Overloaded. Sets the input map for the specified focus mode. | |
SetInputMapWhenChildHasFocus | Sets the input map when a child control has keyboard focus. | |
SetInputMapWhenShapeHasFocus | Sets the input map when a shape has keyboard focus. | |
SetInsertSheetImage | Sets the custom image displayed on the insert sheet tab. | |
SetMaximumCellOverflowWidth | Sets the maximum cell overflow width in pixels. | |
SetPrintInfo | Sets the PrintInfo object for the specfied sheet. | |
SetPrintPreview | Sets the print preview dialog. | |
SetViewportLeftColumn | Overloaded. Sets the leftmost column of cells of the specified viewport column for the active sheet. | |
SetViewportPreferredHeight | Overloaded. Sets the maximum height of the specified viewport row for the active sheet. | |
SetViewportPreferredWidth | Overloaded. Sets the maximum width of the specified viewport column for the active sheet. | |
SetViewportTopRow | Overloaded. Sets the top row of cells of the specified viewport row for the active sheet. | |
Show | Displays the control to the user. (Inherited from System.Windows.Forms.Control) | |
ShowActiveCell | Moves the active cell to the specified position in the component. | |
ShowCell | Moves the specified cell in the specified viewport to the specified position in the component. | |
ShowCollectionEditor | Shows the collection editor. | |
ShowColumn | Moves a column of cells in the specified viewport to the specified position in the component. | |
ShowDependents | Shows the dependent cells for a formula cell. | |
ShowPageSetup | Overloaded. Shows the page setup dialog with the specified buttons for the specified sheet. | |
ShowPrecedents | Shows the cells that are referred to by formulas in other cells. | |
ShowRow | Moves a row in the specified viewport to the specified position in the component. | |
StartAnnotationMode | Overloaded. Starts annotation mode. | |
StartCellEditing | Starts cell editing. | |
StartInkNotation | Overloaded. Starts ink notation in the active viewport if the Microsoft.Ink assembly is found in the GAC. | |
StopAnnotationMode | Stops annotation mode. | |
StopCellEditing | Stops cell editing. | |
SuspendLayout | Temporarily suspends the layout logic for this component. | |
ToString | (Inherited from System.ComponentModel.Component) | |
Update | Causes the control to redraw the invalidated regions within its client area. (Inherited from System.Windows.Forms.Control) |
Top
Name | Description | |
---|---|---|
ActiveSheetChanged | Occurs when the user has changed the active sheet. | |
ActiveSheetChanging | Occurs when the user changes the active sheet. | |
ActiveSpreadViewChanged | Occurs when the user has changed the active SpreadView. | |
ActiveSpreadViewChanging | Occurs when the user changes the active SpreadView. | |
Advance | Occurs when the user tries to advance from first or last row in Spread. | |
AnnotationModeEnding | Occurs when the user ends annotation mode. | |
AnnotationModeStarting | Occurs when the user begins annotation mode. | |
AutoFilteredColumn | Occurs when a column has just been automatically filtered. | |
AutoFilteringColumn | Occurs when a column is about to be automatically filtered. | |
AutoSortedColumn | Occurs when a column has just been automatically sorted. | |
AutoSortingColumn | Occurs when a column is about to be automatically sorted. | |
BackColorChanged | Occurs when the value of the System.Windows.Forms.Control.BackColor property changes. (Inherited from System.Windows.Forms.Control) | |
BackgroundImageChanged | Occurs when the value of the System.Windows.Forms.Control.BackgroundImage property changes. (Inherited from System.Windows.Forms.Control) | |
BackgroundImageLayoutChanged | Occurs when the System.Windows.Forms.Control.BackgroundImageLayout property changes. (Inherited from System.Windows.Forms.Control) | |
BindingContextChanged | Occurs when the value of the System.Windows.Forms.BindingContext property changes. (Inherited from System.Windows.Forms.Control) | |
ButtonClicked | Occurs when the user clicks a button, check box, or hyperlink in a cell. | |
CausesValidationChanged | Occurs when the value of the System.Windows.Forms.Control.CausesValidation property changes. (Inherited from System.Windows.Forms.Control) | |
CellClick | Occurs when the user presses down the left mouse button in a cell. | |
CellDoubleClick | Occurs when the user presses down the left mouse button twice (double clicks) in a cell. | |
Change | Occurs after the user modifies data in a cell. | |
ChangeUICues | Occurs when the focus or keyboard user interface (UI) cues change. (Inherited from System.Windows.Forms.Control) | |
ChartIndicatorActivated | Occurs when the chart indicator is activated. | |
ChartIndicatorDeactivated | Occurs when the chart indicator is deactivated. | |
ChildControlActivated | Occurs when a child control is activated. | |
ChildControlDeactivated | Occurs when a child control is deactivated. | |
ChildViewCreated | Occurs when a child view of the Spread component is created. | |
ChildWorkbookCreated | Occurs when a child workbook of the Spread component is created. | |
ClientSizeChanged | Occurs when the value of the System.Windows.Forms.Control.ClientSize property changes. (Inherited from System.Windows.Forms.Control) | |
ClipboardChanged | Occurs when a Clipboard change occurs that can affect the Spread component. | |
ClipboardChanging | Occurs when the Clipboard is changing through a Spread action. | |
ClipboardPasted | Occurs when the user pastes from the clipboard. | |
ClipboardPasting | Occurs when the user pastes from the clipboard. | |
ColumnDragMove | Occurs when AllowColumnMove is true and the user drags to move a column. | |
ColumnDragMoveCompleted | Occurs when the user finishes dragging to move a column. | |
ColumnViewportWidthChanged | Occurs when a viewport column width has changed. | |
ColumnWidthChanged | Occurs when the column width has changed. | |
ColumnWidthChanging | Occurs when the column width is changing. | |
ComboCloseUp | Occurs when the user closes a combo box in a cell. | |
ComboDropDown | Occurs when the user drops down a combo box in a cell. | |
ComboSelChange | Occurs when the user changes the selection in a combo box in a cell. | |
ContextMenuChanged | Occurs when the value of the System.Windows.Forms.Control.ContextMenu property changes. (Inherited from System.Windows.Forms.Control) | |
ContextMenuStripChanged | Occurs when the value of the System.Windows.Forms.Control.ContextMenuStrip property changes. (Inherited from System.Windows.Forms.Control) | |
ControlAdded | Occurs when a new control is added to the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control) | |
ControlRemoved | Occurs when a control is removed from the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control) | |
CursorChanged | Occurs when the value of the System.Windows.Forms.Control.Cursor property changes. (Inherited from System.Windows.Forms.Control) | |
DataColumnConfigure | Occurs when the sheet is binding a column to a data source after it has been initialized. | |
DialogChar | Occurs during message preprocessing of dialog characters. | |
DialogKey | Occurs during message preprocessing of dialog keys. | |
Disposed | (Inherited from System.ComponentModel.Component) | |
DockChanged | Occurs when the value of the System.Windows.Forms.Control.Dock property changes. (Inherited from System.Windows.Forms.Control) | |
DoubleClick | Occurs when the control is double-clicked. (Inherited from System.Windows.Forms.Control) | |
DragDrop | Occurs when a drag-and-drop operation is completed. (Inherited from System.Windows.Forms.Control) | |
DragDropBlock | Occurs when the user drags and drops a range of cells. | |
DragDropBlockCompleted | Occurs at the completion of the user dragging and dropping a range of cells. | |
DragEnter | Occurs when an object is dragged into the control's bounds. (Inherited from System.Windows.Forms.Control) | |
DragFillBlock | Occurs when the user drags to fill a range of cells. | |
DragFillBlockCompleted | Occurs at the completion of the user dragging to fill a range of cells. | |
DragLeave | Occurs when an object is dragged out of the control's bounds. (Inherited from System.Windows.Forms.Control) | |
DragOver | Occurs when an object is dragged over the control's bounds. (Inherited from System.Windows.Forms.Control) | |
EditChange | Occurs when the user changes the text in a cell in edit mode. | |
EditError | Occurs when the user performs an invalid input operation. | |
EditModeOff | Occurs when edit mode is stopped. | |
EditModeOn | Occurs when edit mode is started. | |
EditModeStarting | Occurs when edit mode is about to start in the active sheet's active cell. | |
EditorFocused | Occurs when the editing control gets focus. | |
EnabledChanged | Occurs when the System.Windows.Forms.Control.Enabled property value has changed. (Inherited from System.Windows.Forms.Control) | |
Enter | Occurs when the control is entered. (Inherited from System.Windows.Forms.Control) | |
EnterCell | Occurs when the user enters a cell. | |
Error | Occurs when the user performs an invalid operation. | |
Expand | Occurs when a row is expanded or collapsed. | |
FontChanged | Occurs when the System.Windows.Forms.Control.Font property value changes. (Inherited from System.Windows.Forms.Control) | |
GiveFeedback | Occurs during a drag operation. (Inherited from System.Windows.Forms.Control) | |
GotFocus | Occurs when the control receives focus. (Inherited from System.Windows.Forms.Control) | |
Grouped | Occurs when the grouping is finished. | |
Grouping | Occurs when the user performs grouping. | |
HandleCreated | Occurs when a handle is created for the control. (Inherited from System.Windows.Forms.Control) | |
HandleDestroyed | Occurs when the control's handle is in the process of being destroyed. (Inherited from System.Windows.Forms.Control) | |
HelpRequested | Occurs when the user requests help for a control. (Inherited from System.Windows.Forms.Control) | |
HyperLinkClicked | Occurs when the user clicks on text of hyper link. | |
ImeModeChanged | Occurs when the System.Windows.Forms.Control.ImeMode property has changed. (Inherited from System.Windows.Forms.Control) | |
Invalidated | Occurs when a control's display requires redrawing. (Inherited from System.Windows.Forms.Control) | |
KeyDown | Occurs when a key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control) | |
KeyPress | Occurs when a key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control) | |
KeyUp | Occurs when a key is released while the control has focus. (Inherited from System.Windows.Forms.Control) | |
Layout | Occurs when a control should reposition its child controls. (Inherited from System.Windows.Forms.Control) | |
Leave | Occurs when the input focus leaves the control. (Inherited from System.Windows.Forms.Control) | |
LeaveCell | Occurs when the user leaves a cell. | |
LeftChange | Occurs when left column changes. | |
LocationChanged | Occurs when the System.Windows.Forms.Control.Location property value has changed. (Inherited from System.Windows.Forms.Control) | |
LostFocus | Occurs when the control loses focus. (Inherited from System.Windows.Forms.Control) | |
MarginChanged | Occurs when the control's margin changes. (Inherited from System.Windows.Forms.Control) | |
MouseCaptureChanged | Occurs when the control loses mouse capture. (Inherited from System.Windows.Forms.Control) | |
MouseClick | Occurs when the control is clicked by the mouse. (Inherited from System.Windows.Forms.Control) | |
MouseDoubleClick | Occurs when the control is double clicked by the mouse. (Inherited from System.Windows.Forms.Control) | |
MouseDown | Occurs when the mouse pointer is over the control and a mouse button is pressed. (Inherited from System.Windows.Forms.Control) | |
MouseEnter | Occurs when the mouse pointer enters the control. (Inherited from System.Windows.Forms.Control) | |
MouseHover | Occurs when the mouse pointer rests on the control. (Inherited from System.Windows.Forms.Control) | |
MouseLeave | Occurs when the mouse pointer leaves the control. (Inherited from System.Windows.Forms.Control) | |
MouseMove | Occurs when the mouse pointer is moved over the control. (Inherited from System.Windows.Forms.Control) | |
MouseUp | Occurs when the mouse pointer is over the control and a mouse button is released. (Inherited from System.Windows.Forms.Control) | |
MouseWheel | Occurs when the mouse wheel moves while the control has focus. (Inherited from System.Windows.Forms.Control) | |
Move | Occurs when the control is moved. (Inherited from System.Windows.Forms.Control) | |
PaddingChanged | Occurs when the control's padding changes. (Inherited from System.Windows.Forms.Control) | |
Paint | Occurs when the control is redrawn. (Inherited from System.Windows.Forms.Control) | |
PaintGrayArea | Occurs when the gray area needs painting. | |
PaintGroupBarBackground | Occurs when the group bar background is painted. | |
PaintTabStrip | Occurs when the TabStrip needs painting. | |
PaintTabStripButton | Occurs when a TabStrip button needs painting. | |
PaintTabStripTab | Occurs when a TabStrip tab needs painting. | |
ParentChanged | Occurs when the System.Windows.Forms.Control.Parent property value changes. (Inherited from System.Windows.Forms.Control) | |
PreviewKeyDown | Occurs before the System.Windows.Forms.Control.KeyDown event when a key is pressed while focus is on this control. (Inherited from System.Windows.Forms.Control) | |
PreviewRowFetch | Occurs when the user custom preview row of the Spread component. | |
PrintAbort | Occurs continually as printing occurs in order to give the user the opportunity to discontinue a print job. | |
PrintBackground | Occurs before each page is printed. | |
PrintCancelled | Occurs when a print job is discontinued by the user. | |
PrintHeaderFooterArea | Occurs when header or footer needs printing. | |
PrintMessageBox | Occurs before and after a print job. | |
PrintPreviewShowing | Occurs before preview dialog appears. | |
QueryAccessibilityHelp | Occurs when System.Windows.Forms.AccessibleObject is providing help to accessibility applications. (Inherited from System.Windows.Forms.Control) | |
QueryContinueDrag | Occurs during a drag-and-drop operation and enables the drag source to determine whether the drag-and-drop operation should be canceled. (Inherited from System.Windows.Forms.Control) | |
RangeGroupStateChanged | Occurs when the user changed the state of some outline (range group) of rows or columns. | |
RangeGroupStateChanging | Occurs before user changes the state of some outline (range group) of rows or columns. | |
RegionChanged | Occurs when the value of the System.Windows.Forms.Control.Region property changes. (Inherited from System.Windows.Forms.Control) | |
Resize | Occurs when the control is resized. (Inherited from System.Windows.Forms.Control) | |
RightToLeftChanged | Occurs when the System.Windows.Forms.Control.RightToLeft property value changes. (Inherited from System.Windows.Forms.Control) | |
RowDragMove | Occurs when AllowRowMove is true and the user drags to move a row. | |
RowDragMoveCompleted | Occurs when the user finishes dragging to move a row. | |
RowHeightChanged | Occurs when the row height has changed. | |
RowHeightChanging | Occurs when the column width is changing. | |
RowViewportHeightChanged | Occurs when a viewport row height has changed. | |
ScrollTipFetch | Occurs when the user scrolls the Spread component. | |
SearchDialogClosing | Occurs when the search form is closing. | |
SelectionChanged | Occurs when the selection of cells on the sheet is changed. | |
SelectionChanging | Occurs when the selection of cells on the sheet is changing. | |
ShapeActivated | Occurs when the user changes the active shape object. | |
ShapeDeactivated | Occurs when the user deactivates the active shape object. | |
SheetTabClick | Occurs when the user clicks the sheet tab. | |
SheetTabDoubleClick | Occurs when the user double clicks the sheet tab. | |
SizeChanged | Occurs when the System.Windows.Forms.Control.Size property value changes. (Inherited from System.Windows.Forms.Control) | |
StyleChanged | Occurs when the control style changes. (Inherited from System.Windows.Forms.Control) | |
SubEditorClosed | Occurs when a subeditor is closed for a cell. | |
SubEditorOpening | Occurs when a subeditor is about to be displayed. | |
SystemColorsChanged | Occurs when the system colors change. (Inherited from System.Windows.Forms.Control) | |
TabIndexChanged | Occurs when the System.Windows.Forms.Control.TabIndex property value changes. (Inherited from System.Windows.Forms.Control) | |
TabStopChanged | Occurs when the System.Windows.Forms.Control.TabStop property value changes. (Inherited from System.Windows.Forms.Control) | |
TextChanged | Occurs when the System.Windows.Forms.Control.Text property value changes. (Inherited from System.Windows.Forms.Control) | |
TextTipFetch | Occurs when the pointer (cursor) is over a cell and the text tip or cell note should be displayed (the TextTip property is set to a value other than Off). | |
TopChange | Occurs when the top row changes. | |
Ungrouped | Occurs when all the grouping is removed. | |
UserFormulaEntered | Occurs when the user types a formula. | |
UserZooming | Occurs when the user zooms. | |
Validated | Occurs when the control is finished validating. (Inherited from System.Windows.Forms.Control) | |
Validating | Occurs when the control is validating. (Inherited from System.Windows.Forms.Control) | |
VisibleChanged | Occurs when the System.Windows.Forms.Control.Visible property value changes. (Inherited from System.Windows.Forms.Control) |
Reference
FpSpread ClassFarPoint.Win.Spread Namespace
User-Task Documentation
Customizing the AppearanceCustomizing the User Interaction