Allowing User Functionality

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	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 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.