Name | Description | |
---|---|---|
FpSpread Constructor | Creates a new Spreadsheet component. |
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 | (Inherited from System.Windows.Forms.Control) | |
AccessibleDefaultActionDescription | (Inherited from System.Windows.Forms.Control) | |
AccessibleDescription | (Inherited from System.Windows.Forms.Control) | |
AccessibleName | (Inherited from System.Windows.Forms.Control) | |
AccessibleRole | (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. | |
ActiveWindowlessObject | Gets or sets the active windowless shape object of the component. | |
AllowCellContentFloat | Indicates whether the content of a cell should float when the display rectangle of that cell changes. | |
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 | (Inherited from System.Windows.Forms.Control) | |
AllowEditorReservedLocations | Gets or sets whether cell editor reserved mouse locations are allowed. | |
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 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 component. | |
AllowUserToTouchZoom | Gets or sets a value that indicates whether to allow the user to zoom FpSpread using touch behavior. | |
AllowUserZoom | Gets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel. | |
Anchor | (Inherited from System.Windows.Forms.Control) | |
AutoAdvance | Gets or sets whether the user can move to another control from the first or last cell using Shift+Tab or the Tab key. | |
AutoClipboard | Gets or sets whether the component handles the shortcut keys for Clipboard actions. | |
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 in a cell that is not in edit mode. | |
AutoLaunchSpreadDesigner | Gets or sets whether Spread Designer automatically launches when a Spread component is placed on a form. | |
AutoScrollOffset | (Inherited from System.Windows.Forms.Control) | |
AutoScrollWhenKeyboardShowing | Gets or sets the automatic scroll when the keyboard is displayed. | |
BackColor | (Inherited from System.Windows.Forms.Control) | |
BackgroundImage | Overridden. Gets or sets the image to paint in the background of the component. | |
BackgroundImageLayout | (Inherited from System.Windows.Forms.Control) | |
BindingContext | (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 | (Inherited from System.Windows.Forms.Control) | |
BoundaryFeedbackMode | Gets or sets the way FpSpread reacts when the manipulation has gone beyond certain boundaries. | |
Bounds | (Inherited from System.Windows.Forms.Control) | |
ButtonDrawMode | Gets or sets whether to display buttons in button and combo box cells in the component. | |
CanFocus | (Inherited from System.Windows.Forms.Control) | |
CanSelect | (Inherited from System.Windows.Forms.Control) | |
Capture | (Inherited from System.Windows.Forms.Control) | |
CausesValidation | (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. | |
CellSpanSelectionPolicy | Gets or sets the selection model to use with the span. | |
ClientRectangle | (Inherited from System.Windows.Forms.Control) | |
ClientSize | (Inherited from System.Windows.Forms.Control) | |
ClipboardOptions | Gets or sets whether the headers and the filter bar 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 | (Inherited from System.Windows.Forms.Control) | |
Container | (Inherited from System.ComponentModel.Component) | |
ContainsFocus | (Inherited from System.Windows.Forms.Control) | |
ContextMenu | (Inherited from System.Windows.Forms.Control) | |
ContextMenuStrip | Overridden. | |
Controls | (Inherited from System.Windows.Forms.Control) | |
Created | (Inherited from System.Windows.Forms.Control) | |
Cursor | Overridden. Gets or sets the pointer to display in this component. | |
CustomFillSeriesList | Gets the custom list fill series. | |
CustomIconContainer | Gets the CustomIconContainer object for the current spread object. | |
DataBindings | (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. | |
DeviceDpi | (Inherited from System.Windows.Forms.Control) | |
DisplayRectangle | (Inherited from System.Windows.Forms.Control) | |
Disposing | (Inherited from System.Windows.Forms.Control) | |
Dock | (Inherited from System.Windows.Forms.Control) | |
DocumentProperties | Gets or sets the DocumentProperties object that represents all properties of the Spread document. | |
DragFillDataOnly | Gets or sets a value that indicates whether the drag fill action copies data only. | |
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 | (Inherited from System.Windows.Forms.Control) | |
EnableDragFillMenu | Gets or sets a value to show drag fill button and drag fill context menu. | |
Focused | (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 | (Inherited from System.Windows.Forms.Control) | |
HasChildren | (Inherited from System.Windows.Forms.Control) | |
HeaderIndicatorPositionAdjusting | Gets or sets the distance between the sorting and filtering indicators and the right edge of the column. | |
Height | (Inherited from System.Windows.Forms.Control) | |
HorizontalScrollBar | Gets the horizontal scroll bar. | |
HorizontalScrollBarHeight | Gets or sets the height of horizontal scroll bars in this component. | |
HorizontalScrollBarMode | Gets or Sets horizontal scroll bar mode. | |
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. | |
ImeSentenceMode | Gets or sets IME sentence mode. | |
InputDeviceType | Gets the input device type which indicates the current device. | |
InputScope | Gets or sets the input scope for the Spread. | |
InterfaceRenderer | Gets or sets the tab strip renderer for drawing tab strip elements. | |
InvokeRequired | (Inherited from System.Windows.Forms.Control) | |
IsAccessible | (Inherited from System.Windows.Forms.Control) | |
IsDisposed | (Inherited from System.Windows.Forms.Control) | |
IsHandleCreated | (Inherited from System.Windows.Forms.Control) | |
IsLayoutSuspended | Returns whether the layout is suspended in this component. | |
IsMirrored | (Inherited from System.Windows.Forms.Control) | |
IsProtectedStructure | Specifies whether Spread allows the user to change the structure of the sheet collection. | |
LayoutEngine | (Inherited from System.Windows.Forms.Control) | |
Left | (Inherited from System.Windows.Forms.Control) | |
LeftTab | Gets or sets the leftmost sheet tab of the component. | |
Location | (Inherited from System.Windows.Forms.Control) | |
Margin | (Inherited from System.Windows.Forms.Control) | |
MaximumSize | (Inherited from System.Windows.Forms.Control) | |
MinimumSize | (Inherited from System.Windows.Forms.Control) | |
MinZoomFactor | Gets or sets a value that indicates the minimum zoom factor for the active SheetView. | |
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 | (Inherited from System.Windows.Forms.Control) | |
PaintActiveCellInSelection | Gets or sets whether the active cell is painted in the selection. | |
PaintSelectionBorder | Gets or sets a value that indicates whether to allow the border selection to paint. | |
PaintSelectionHeader | Gets or sets whether to allow the header selection to paint. | |
PanningMode | Gets or sets the way FpSpread reacts to touch manipulation. | |
Parent | (Inherited from System.Windows.Forms.Control) | |
PreferredSize | (Inherited from System.Windows.Forms.Control) | |
ProductName | (Inherited from System.Windows.Forms.Control) | |
ProductVersion | (Inherited from System.Windows.Forms.Control) | |
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. | |
RecreatingHandle | (Inherited from System.Windows.Forms.Control) | |
Region | (Inherited from System.Windows.Forms.Control) | |
ResizeZeroIndicator | Gets or sets the way FpSpread processes resizing for zero-height rows and zero-width columns. | |
RetainSelectionBlock | Gets or sets whether the selected range of cells remains highlighted when the component loses the focus. | |
Right | (Inherited from System.Windows.Forms.Control) | |
RightToLeft | (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. | |
ShowCellErrors | Gets or sets whether to allow the user to display row error by icon in the component. | |
ShowDragBandOnMoving | Gets or sets whether the drag band is displayed when moving the row or column. | |
ShowGrippersInEditingStatus | Gets or sets whether tapping displays the gripper in edit mode. | |
ShowRowErrors | Gets or sets whether to allow the user to display the cell error using an icon or sticky note in the component. | |
Site | (Inherited from System.Windows.Forms.Control) | |
Size | (Inherited from System.Windows.Forms.Control) | |
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 scaling uses the application width. | |
StatusBar | Gets the status bar control of spread. | |
StatusBarVisible | Gets or sets whether the status bar is enabled. | |
SuspendAnimations | Gets or sets whether to suspend animations such as an animated focus renderer. | |
TabIndex | (Inherited from System.Windows.Forms.Control) | |
TableStyleCollection | Gets a table style collection. | |
TabStop | (Inherited from System.Windows.Forms.Control) | |
TabStrip | Gets the object that represents 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. | |
TapToAddSelection | Gets or sets whether to tap to add selection. | |
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 Spread. | |
Top | (Inherited from System.Windows.Forms.Control) | |
TopLevelControl | (Inherited from System.Windows.Forms.Control) | |
TouchDropDownScale | Gets or sets the TouchDropDownScale to specify the zoom scale value that applies to a cell type drop-down item. | |
TouchSelectionGripperBackColor | Gets or sets the touch selection gripper's backcolor. | |
TouchSelectionGripperLineColor | Gets or sets the touch selection gripper's line color. | |
TouchSelectionGripperThickness | Gets or sets the touch selection gripper's thickness. | |
TouchZoomSnapDistance | Gets or sets a value that indicates the minmum distance that can cause the current zoom factor to snap to a zoom factor in TouchZoomSnapPoints. | |
TouchZoomSnapPoints | Gets a zoom factor group and when the zoom ends, the final zoom factor snaps to a snap point in this group. | |
UndoManager | Gets or sets the undo manager for this Spread component. | |
UseOptimizedSelectionForTouch | Gets or sets whether to use optimized selection for touch. | |
UseWaitCursor | (Inherited from System.Windows.Forms.Control) | |
VerticalScrollBar | Gets the vertical scroll bar. | |
VerticalScrollBarMode | Gets or Sets vertical scroll bar mode. | |
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 | (Inherited from System.Windows.Forms.Control) | |
VisualStyles | Gets or sets whether to use visual styles when rendering objects in the component. | |
Width | (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 | (Inherited from System.Windows.Forms.Control) | |
CanRaiseEvents | (Inherited from System.Windows.Forms.Control) | |
DefaultCursor | (Inherited from System.Windows.Forms.Control) | |
DefaultImeMode | (Inherited from System.Windows.Forms.Control) | |
DefaultMargin | (Inherited from System.Windows.Forms.Control) | |
DefaultMaximumSize | (Inherited from System.Windows.Forms.Control) | |
DefaultMinimumSize | (Inherited from System.Windows.Forms.Control) | |
DefaultPadding | (Inherited from System.Windows.Forms.Control) | |
DefaultSize | Overridden. Gets the default size of the component. | |
DoubleBuffered | (Inherited from System.Windows.Forms.Control) | |
Events | (Inherited from System.ComponentModel.Component) | |
FontHeight | (Inherited from System.Windows.Forms.Control) | |
ImeModeBase | Overridden. Gets or sets IME mode base. | |
ResizeRedraw | (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. | |
AddCustomFunction | Adds a user-defined custom function (GrapeCity.CalcEngine.Function object) to the model for use in formulas. | |
AddNewSheetView | Creates a new SheetView and inserts or replaces the sheet at the specified sheet index. | |
AddViewport | Overloaded. Adds a row or column of viewports. | |
BeginInvoke | Overloaded. (Inherited from System.Windows.Forms.Control) | |
BringToFront | (Inherited from System.Windows.Forms.Control) | |
CancelAnnotationMode | Cancels annotation mode. | |
CancelCellEditing | Cancels cell editing. | |
Contains | (Inherited from System.Windows.Forms.Control) | |
CreateControl | (Inherited from System.Windows.Forms.Control) | |
CreateGraphics | (Inherited from System.Windows.Forms.Control) | |
CreateTableStyle | Creates a table style based on the table style contained in the table style collection or a built-in table style. | |
DrawToBitmap | (Inherited from System.Windows.Forms.Control) | |
EndInvoke | (Inherited from System.Windows.Forms.Control) | |
FindForm | (Inherited from System.Windows.Forms.Control) | |
Focus | (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. (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 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. | |
GetContainerControl | (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. | |
GetFilterBarHeaderRectangle | Gets the rectangle of the column header. | |
GetFilterBarRectangle | Gets the rectangle of the filter bar. | |
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 | Overloaded. Gets the column page breaks for the specified sheet under the current printing conditions. | |
GetOwnerPrintInfo | Gets the printing information required to print a given sheet into the supplied rectangle. | |
GetOwnerPrintPageCount | Gets the number of pages required to print a given sheet into the supplied rectangle. | |
GetOwnerPrintRowPageBreaks | Overloaded. Gets the row page breaks for the specified sheet under the current printing conditions. | |
GetPreferredSize | (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 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. | |
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 | (Inherited from System.Windows.Forms.Control) | |
HideTouchKeyboard | Hides the touch keyboard. | |
HitTest | Performs a hit test. | |
Invalidate | Overloaded. (Inherited from System.Windows.Forms.Control) | |
Invoke | Overloaded. (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 that contains 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. | |
LoadXmlInputMapFile | Overloaded. Loads the XML input map file using the specified operation mode. | |
LoadXmlInputMapFileWhenChildHasFocus | Overloaded. Loads the XML input map file when the child has the focus. | |
LoadXmlInputMapFileWhenShapeHasFocus | Overloaded. Loads the XML input map file when the shape has the focus. | |
LogicalToDeviceUnits | (Inherited from System.Windows.Forms.Control) | |
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 | Overloaded. 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 | (Inherited from System.Windows.Forms.Control) | |
PointToScreen | (Inherited from System.Windows.Forms.Control) | |
PreProcessControlMessage | (Inherited from System.Windows.Forms.Control) | |
PrintSheet | Overloaded. Handles the printing of the specified sheet in a separate thread. | |
RectangleToClient | (Inherited from System.Windows.Forms.Control) | |
RectangleToScreen | (Inherited from System.Windows.Forms.Control) | |
Refresh | (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 | (Inherited from System.Windows.Forms.Control) | |
ResumeLayout | Overloaded. Resumes normal layout logic. | |
Save | Overloaded. Saves the content of the Spread component to the specified file. | |
SaveExcel | Overloaded. Saves the content of the Spread component to the specified stream. | |
SaveXmlInputMapFile | Overloaded. Saves the XML input map file. | |
SaveXmlInputMapFileWhenChildHasFocus | Overloaded. Saves the XML input map file when child has focus. | |
SaveXmlInputMapFileWhenShapeHasFocus | Overloaded. Saves the XML input map file when shape has focus. | |
Scale | (Inherited from System.Windows.Forms.Control) | |
ScaleBitmapLogicalToDevice | (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 | (Inherited from System.Windows.Forms.Control) | |
SendToBack | (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. (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. | |
SetProtect | Changes the protect structure setting with the password parameter. | |
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 | (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. | |
ShowCellValidatorsForm | Shows the form that is used to edit Cell Validators of selected range | |
ShowCollectionEditor | Shows the collection editor. | |
ShowColumn | Moves a column of cells in the specified viewport to the specified position in the component. | |
ShowDataValidationForm | Shows the form that is used to edit DataValidation of selected range | |
ShowDependents | Shows the dependent cells for a formula cell. | |
ShowEditForm | Displays the form used for editing custom names. | |
ShowInputMapEditor | Displays the input map editor. | |
ShowListCustomNameForm | Displays the form that contains a list of custom names. | |
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. | |
ShowTouchKeyboard | Displays the touch keyboard. | |
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) | |
TriggerVolatileCells | This function will notify all cells, which contains volatile functions or belong to a circuit, to recalculate. | |
Update | (Inherited from System.Windows.Forms.Control) |
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 the first or last row in Spread. | |
AllowUserToTouchZoomChanged | Occurs when the AllowUserToZoom property has changed. | |
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. | |
AutoScrollWhenKeyboardShowingChanged | Occurs when the AutoScrollWhenKeyboardShowing property is changed. | |
AutoSortedColumn | Occurs when a column has just been automatically sorted. | |
AutoSortingColumn | Occurs when a column is about to be automatically sorted. | |
BackColorChanged | (Inherited from System.Windows.Forms.Control) | |
BackgroundImageChanged | (Inherited from System.Windows.Forms.Control) | |
BackgroundImageLayoutChanged | (Inherited from System.Windows.Forms.Control) | |
BindingContextChanged | (Inherited from System.Windows.Forms.Control) | |
BoundaryFeedbackModeChanged | Occurs when the BoundaryFeedbackMode property has changed. | |
ButtonClicked | Occurs when the user clicks a button, check box, or hyperlink in a cell. | |
CausesValidationChanged | (Inherited from System.Windows.Forms.Control) | |
CellClick | Occurs when the user presses the left mouse button down in a cell. | |
CellDoubleClick | Occurs when the user presses the left mouse button down twice (double-clicks) in a cell. | |
CellErrorTextChanged | Occurs when the cell error text has changed. | |
CellValidateInfoNeeded | Occurs when cell validate infomation is needed. | |
Change | Occurs after the user modifies data in a cell. | |
ChangeUICues | (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. | |
CircularFormula | Occurs when one or more circular reference is created. | |
ClientSizeChanged | (Inherited from System.Windows.Forms.Control) | |
ClipboardChanged | Occurs when a Clipboard change occurs that can affect the FarPoint 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 moving a column by dragging. | |
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 | (Inherited from System.Windows.Forms.Control) | |
ContextMenuStripChanged | (Inherited from System.Windows.Forms.Control) | |
ControlAdded | (Inherited from System.Windows.Forms.Control) | |
ControlRemoved | (Inherited from System.Windows.Forms.Control) | |
CursorChanged | (Inherited from System.Windows.Forms.Control) | |
CustomNameChanged | Occurs when the custom name of the data model changes. | |
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 | (Inherited from System.Windows.Forms.Control) | |
DoubleClick | (Inherited from System.Windows.Forms.Control) | |
DpiChangedAfterParent | (Inherited from System.Windows.Forms.Control) | |
DpiChangedBeforeParent | (Inherited from System.Windows.Forms.Control) | |
DragDrop | (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 | (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 | (Inherited from System.Windows.Forms.Control) | |
DragOver | (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 | (Inherited from System.Windows.Forms.Control) | |
Enter | (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. | |
FilterBarClick | Occurs when the user presses the left mouse button in a filter bar cell. | |
FilterBarDoubleClick | Occurs when the user presses the left mouse button down twice (double-clicks) in a filter bar cell. | |
FilterBarDropDownSelectionChanging | Occurs when the user selects a value from the drop-down list in the filter bar editor. | |
FontChanged | (Inherited from System.Windows.Forms.Control) | |
GiveFeedback | (Inherited from System.Windows.Forms.Control) | |
GotFocus | (Inherited from System.Windows.Forms.Control) | |
Grouped | Occurs when the grouping is finished. | |
Grouping | Occurs when the user performs grouping. | |
HandleCreated | (Inherited from System.Windows.Forms.Control) | |
HandleDestroyed | (Inherited from System.Windows.Forms.Control) | |
HeaderIndicatorPositionAdjustingChanged | Occurs when the HeaderIndicatorPositionAdjusting property has changed. | |
HelpRequested | (Inherited from System.Windows.Forms.Control) | |
HyperLinkClicked | Occurs when the user clicks on hyper link text. | |
ImeModeChanged | (Inherited from System.Windows.Forms.Control) | |
InputScopeChanged | Occurs when the InputScope property is changed. | |
Invalidated | (Inherited from System.Windows.Forms.Control) | |
KeyDown | (Inherited from System.Windows.Forms.Control) | |
KeyPress | (Inherited from System.Windows.Forms.Control) | |
KeyUp | (Inherited from System.Windows.Forms.Control) | |
Layout | (Inherited from System.Windows.Forms.Control) | |
Leave | (Inherited from System.Windows.Forms.Control) | |
LeaveCell | Occurs when the user leaves a cell. | |
LeftChange | Occurs when the left column changes. | |
LocationChanged | (Inherited from System.Windows.Forms.Control) | |
LostFocus | (Inherited from System.Windows.Forms.Control) | |
MarginChanged | (Inherited from System.Windows.Forms.Control) | |
MouseCaptureChanged | (Inherited from System.Windows.Forms.Control) | |
MouseClick | (Inherited from System.Windows.Forms.Control) | |
MouseDoubleClick | (Inherited from System.Windows.Forms.Control) | |
MouseDown | (Inherited from System.Windows.Forms.Control) | |
MouseEnter | (Inherited from System.Windows.Forms.Control) | |
MouseHover | (Inherited from System.Windows.Forms.Control) | |
MouseLeave | (Inherited from System.Windows.Forms.Control) | |
MouseMove | (Inherited from System.Windows.Forms.Control) | |
MouseUp | (Inherited from System.Windows.Forms.Control) | |
MouseWheel | (Inherited from System.Windows.Forms.Control) | |
Move | (Inherited from System.Windows.Forms.Control) | |
PaddingChanged | (Inherited from System.Windows.Forms.Control) | |
Paint | (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 tab strip needs painting. | |
PaintTabStripButton | Occurs when a TabStrip button needs painting. | |
PaintTabStripTab | Occurs when a TabStrip tab needs painting. | |
PanningModeChanged | Occurs when the PanningMode property has changed. | |
ParentChanged | (Inherited from System.Windows.Forms.Control) | |
PreviewKeyDown | (Inherited from System.Windows.Forms.Control) | |
PreviewRowFetch | Occurs when the user customizes the 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. | |
PrintDocument | Occurs when printing a sheet. | |
PrintHeaderFooterArea | Occurs when the header or footer needs printing. | |
PrintMessageBox | Occurs before and after a print job. | |
PrintPreviewShowing | Occurs before the preview dialog appears. | |
QueryAccessibilityHelp | (Inherited from System.Windows.Forms.Control) | |
QueryContinueDrag | (Inherited from System.Windows.Forms.Control) | |
RangeGroupStateChanged | Occurs when the user has changed the state of the row or column outline (range group). | |
RangeGroupStateChanging | Occurs before the user changes the state of row or column outlines (range group). | |
RegionChanged | (Inherited from System.Windows.Forms.Control) | |
Resize | (Inherited from System.Windows.Forms.Control) | |
ResizeZeroIndicatorChanged | Occurs when the ResizeZeroIndicator property has changed. | |
RightToLeftChanged | (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 moving a row by dragging. | |
RowErrorTextChanged | Occurs when the row error text has changed. | |
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 has 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. | |
SheetDragMoved | Occurs right after the user finishes drag-moving the sheet to another index. | |
SheetDragMoving | Occurs when the user drag-move the sheet name tab to move sheet. | |
SheetTabClick | Occurs when the user clicks the sheet tab. | |
SheetTabDoubleClick | Occurs when the user double-clicks the sheet tab. | |
ShowGrippersInEditingStatusChanged | Occurs when the ShowGrippersInEditingStatus value is changed. | |
SizeChanged | (Inherited from System.Windows.Forms.Control) | |
Sorted | Occurs when spread is sorted. | |
Sorting | Occurs when spread is sorting. | |
StyleChanged | (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 | (Inherited from System.Windows.Forms.Control) | |
TabIndexChanged | (Inherited from System.Windows.Forms.Control) | |
TableChanged | Occurs when the table changes. | |
TabStopChanged | (Inherited from System.Windows.Forms.Control) | |
TapToAddSelectionChanged | Occurs when the TapToAddSelection property is changed. | |
TextChanged | (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. | |
TouchDropDownScaleChanged | Occurs when the TouchDropDownScale property has changed. | |
TouchSelectionGripperBackColorChanged | Occurs when the TouchSelectionGripperBackColor is changed. | |
TouchSelectionGripperLineColorChanged | Occurs when TouchSelectionGripperLineColor is changed. | |
TouchSelectionGripperThicknessChanged | Occurs when the TouchSelectionGripperThickness is changed. | |
TouchStripOpening | Occurs when FpSpread tries to show a FarPoint.Win.Spread.TouchStrip in a touch device. | |
TouchZoomSnapDistanceChanged | Occurs when the TouchZoomSnapDistance property has changed. | |
Ungrouped | Occurs when all the grouping is removed. | |
UseOptimizedSelectionForTouchChanged | Occurs when the UseOptimizedSelectionForTouch is changed. | |
UserFormulaEntered | Occurs when the user types a formula. | |
UserZooming | Occurs when the user zooms. | |
Validated | (Inherited from System.Windows.Forms.Control) | |
Validating | (Inherited from System.Windows.Forms.Control) | |
VisibleChanged | (Inherited from System.Windows.Forms.Control) |