# Allowing User Functionality

Discover how to control user functionality with the Spread component, including restricting access to rows or columns, enabling zooming, and using clipboard shortcuts.

## Content

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](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cell-dragops/spwin-cell-dragdrop) | [FpSpread](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.html).[AllowDragDrop](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.AllowDragDrop.html) property |
| [Drag and fill cell](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interactcell/spwin-cell-dragops/spwin-cell-dragfill) | FpSpread.[AllowDragFill](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.AllowDragFill.html) property |
| [Edit cell notes](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-cell/spwin-cell-note) | [SheetView](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.html).[AllowNoteEdit](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.AllowNoteEdit.html) property |
| [Input formulas](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-cell-formula/spwin-formulaallowuser) | FpSpread.[AllowUserFormulas](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.AllowUserFormulas.html) property |
| [Filter rows](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interact-rowcol/spwin-filtering) | [Column](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.html).[AllowAutoFilter](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.AllowAutoFilter.html) property |
| [Expand or collapse hierarchy](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-data-binding/spwin-databind-hierarchy) | SheetView.[GetRowExpandable](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.GetRowExpandable.html), [SetRowExpandable](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.SetRowExpandable.html) method |
| Movement of hands on clock face | FarPoint.PluginCalendar.WinForms.FpClock.AllowMoveHands property |
| [Move rows and columns](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcol-usermove) | FpSpread.[AllowRowMove](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.AllowRowMove.html) property and [AllowColumnMove](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.AllowColumnMove.html) property |
| [Perform a standard search](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interact-rowcol/spwin-datasearch) | FpSpread.[SearchWithDialog](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.SearchWithDialog.html) method |
| [Performa an advanced search](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interact-rowcol/spwin-datasearch/spwin-searchadvanced) | FpSpread.[SearchWithDialogAdvanced](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.SearchWithDialogAdvanced.html) method |
| [Resize rows or columns](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssobject-rowcol/spwin-rowcolsize) | Column.[Resizable](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.Resizable.html) property and[Row](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Row.html).[Resizable](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Row.Resizable.html) property |
| [Sort by clicking the sort indicator in the column header](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-interact-rowcol/spwin-sorting) | Column.[AllowAutoSort](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.Column.AllowAutoSort.html) 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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.RestrictColumns.html) property and [RestrictRows](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.RestrictRows.html) property |
| [Zoom, or scale the display of the component](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-cntrlzoom) | FpSpread.[AllowUserZoom](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.FpSpread.AllowUserZoom.html) property |
| Use of Clipboard shortcuts (keys) | [SuperEditBase](/spreadnet/api/latest/online-win/FarPoint.Win/FarPoint.Win.SuperEditBase.html).[AllowClipboardKeys](/spreadnet/api/latest/online-win/FarPoint.Win/FarPoint.Win.SuperEditBase.AllowClipboardKeys.html) property |
| Edit the sheet name | [TabStrip](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.TabStrip.html).[Editable](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.TabStrip.Editable.html) 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](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.DrawingSpace.PSObject.html).[CanMove](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.DrawingSpace.PSObject.CanMove.html) property |
| Resize shapes | PSObject.[CanSize](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.DrawingSpace.PSObject.CanSize.html) property |
| Rotate shapes | PSObject.[CanRotate](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.DrawingSpace.PSObject.CanRotate.html) property |

## See Also

[Spreadsheet Objects](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects)
[Understanding Parts of the Component](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-useinterface)
[Object Parentage](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-knowobjparentage)
[Resetting Parts of the Interface](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-cntrlresets)
[Improving Performance by Suspending the Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-complayout)
[Allowing the User to Zoom the Display of the Component](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-cntrlzoom)
[Working with Scroll Bars](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-scroll)
[Adding a Status Bar](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-statusbar)
[Customizing Viewports](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-sheetviewports)
[Customizing Split Boxes](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-sheetsplitboxes)
[Ways to Improve Performance](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-ssojbects/spwin-perfimprovements)