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 | FpSpread.AllowDragDrop property |
| Drag and fill cell | FpSpread.AllowDragFill property |
| Edit cell notes | SheetView.AllowNoteEdit property |
| Input formulas | FpSpread.AllowUserFormulas property |
| Filter rows | Column.AllowAutoFilter property |
| Expand or collapse hierarchy | SheetView.GetRowExpandable, SetRowExpandable method |
| Movement of hands on clock face | FarPoint.PluginCalendar.WinForms.FpClock.AllowMoveHands property |
| Move rows and columns | FpSpread.AllowRowMove property and AllowColumnMove property |
| Perform a standard search | FpSpread.SearchWithDialog method |
| Performa an advanced search | FpSpread.SearchWithDialogAdvanced method |
| Resize rows or columns | Column.Resizable property andRow.Resizable property |
| Sort by clicking the sort indicator in the column header | Column.AllowAutoSort property |
| Filtering a range | Cells.AutoFilter method |
| Access filter settings | Worksheet.AutoFilter property, Worksheet.Tables.AutoFilter property |
| Sorting a range | Sort.Apply method |
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 and RestrictRows property |
| Zoom, or scale the display of the component | FpSpread.AllowUserZoom property |
| Use of Clipboard shortcuts (keys) | SuperEditBase.AllowClipboardKeys property |
| Edit the sheet name | 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 |