There are several aspects of the Spread component that can be set to allow or restrict how the user can interact with the component.
Here is a list summarizing the things you can allow the user to do (or prevent the user from doing) with the data area of the component:
| User functionality to allow | Related property or method |
|---|---|
|
Drag and drop cell data |
FpSpread.AllowDragDrop property |
|
Drag and fill cell data |
FpSpread.AllowDragFill property |
|
Edit cell notes |
SheetView.AllowNoteEdit property |
|
Enter formulas |
FpSpread.AllowUserFormulas property |
|
Filter rows |
Column.AllowAutoFilter property |
|
Expand or collapse hierarchy |
Get, SetRowExpandable |
|
Moving clock face hands |
FarPoint.PluginCalendar.WinForms. AllowMoveHands property |
|
Move rows and columns |
FpSpread.AllowRowMove property and FpSpread.AllowColumnMove property |
|
Perform a standard search |
FpSpread.SearchWithDialog method) |
|
Perform an advanced search |
FpSpread.SearchWithDialogAdvanced method |
|
Resize rows or columns |
|
|
Sort by clicking the sort indicator in the column header |
Column.AllowAutoSort property |
Here is a list summarizing the things you can allow the user to do (or prevent the user from doing) with the component:
| User functionality to allow | Related property or method |
|---|---|
|
Restrict access to rows or columns |
SheetView.RestrictColumns property SheetView.RestrictRows property |
|
Zoom, or scale the display of the component |
FpSpread.AllowUserZoom property |
|
Use of Clipboard shortcuts (keys) |
FarPoint.Win.SuperEditBase. AllowClipboardKeys property |
|
Edit the sheet names |
FpSpread.TabStrip.Editable property |
Here is a list of things you can allow the user to do (or prevent the user from doing) with the shapes (on the drawing space layer):
| User functionality to allow | Related property or method |
|---|---|
|
Move shapes |
PSObject.CanMove property |
|
Resize shapes |
PSObject.CanSize property |
|
Rotate shapes |
PSObject.CanRotate property |
You can also customize how the user interacts with the keyboard; refer to Managing Keyboard Interaction.
You can also customize how the user interacts with printing; refer to Managing Printing.
For more information on shapes, refer to Customizing Drawing.
Return to the overall list of tasks in Setting and Resetting User Interaction.