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 | GetRowExpandable, SetRowExpandable methods |
| 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 | Column.Resizable property and Row.Resizable property |
| 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 customize how the user interacts with the keyboard. For more information, refer to Managing Keyboard Interaction.
You can also customize how the user interacts with printing. For more information, refer to Managing Printing.
For more information on shapes, refer to Customizing Drawing.