Gets or sets whether the formula for the cell should be edited.
Syntax
Visual Basic (Declaration) | |
---|
Public Property EditFormula As Boolean |
C# | |
---|
public bool EditFormula {get; set;} |
Property Value
Boolean:
true if the formula should be edited;
false if not
Example
This example prevents the user from editing the formula.
C# | Copy Code |
---|
fpSpread1.Sheets[0].Cells[0, 0].Formula = "A2+A3";
fpSpread1.AllowUserFormulas = true;
private void fpSpread1_EditModeStarting(object sender, FarPoint.Win.Spread.EditModeStartingEventArgs e)
{
e.EditFormula =false;
}
|
Visual Basic | Copy Code |
---|
FpSpread1.Sheets(0).Cells(0, 0).Formula = "A2+A3"
FpSpread1.AllowUserFormulas = True
Private Sub FpSpread1_EditModeStarting(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.EditModeStartingEventArgs) Handles
FpSpread1.EditModeStarting
e.EditFormula = False
End Sub |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also