Spread Windows Forms 12.0 Product Documentation
Allowing User Functionality
Spread Windows Forms 12.0 Product Documentation > Developer's Guide > Customizing Sheet Interaction > Setting and Resetting User Interaction > 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 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
Filtering a range Cells.AutoFilter method
Access filter settings Worksheet.AutoFilter property and 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

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.