Spread Windows Forms 8.0 Product Documentation
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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback