Spread Windows Forms 11.0 Product Documentation
AllowUserFormulas Property (SpreadView)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SpreadView Class : AllowUserFormulas Property
Gets or sets whether to allow the user to enter formulas in a cell in the view.
Syntax
'Declaration
 
Public Property AllowUserFormulas As Boolean
'Usage
 
Dim instance As SpreadView
Dim value As Boolean
 
instance.AllowUserFormulas = value
 
value = instance.AllowUserFormulas
public bool AllowUserFormulas {get; set;}

Property Value

Boolean: true to allow users to enter formulas in cells; false otherwise
Remarks

When this property is set to true, the user can press the equal sign key to type, display, or make modifications to formulas in cells. Even if this property is set to false, you can still provide formulas for cells programmatically using the Formula property (in the Cell, Row, or Column object). This property simply prevents users from entering formulas.

For more information on formulas, refer to the Formula Reference.

Example
This example sets the AllowUserFormulas property.
FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
sv.AllowUserFormulas = true;
Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook
sv.AllowUserFormulas = True
See Also

Reference

SpreadView Class
SpreadView Members

User-Task Documentation

Placing a Formula in a Cell