Spread Windows Forms 13.0 Product Documentation
Spread Windows Forms 13.0 Product Documentation / Developer's Guide / Customizing Sheet Interaction / Setting and Resetting User Interaction / Allowing User Functionality
In This Topic
    Allowing User Functionality
    In This Topic

    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.