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.