Spread Windows Forms 12.0 Product Documentation
EditFormula Property

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > EditModeStartingEventArgs Class : EditFormula Property
Gets or sets whether the formula for the cell should be edited.
Public Property EditFormula As Boolean
Dim instance As EditModeStartingEventArgs
Dim value As Boolean
instance.EditFormula = value
value = instance.EditFormula
public bool EditFormula {get; set;}

Property Value

Boolean: true if the formula should be edited; false if not
This example prevents the user from editing the formula.
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;
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
        e.EditFormula = False
End Sub
See Also


EditModeStartingEventArgs Class
EditModeStartingEventArgs Members