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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
