EditFormula Property | Spread Windows Forms 13.0 Product Documentation

EditFormula Property

In This Topic

Gets or sets whether the formula for the cell should be edited.

Syntax

Visual Basic
C#

'Declaration
 
Public Property EditFormula As Boolean

'Usage
 
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

Example

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;
}

Visual Basic

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

Reference

EditModeStartingEventArgs Class
EditModeStartingEventArgs Members

Product Support Forum | Print this page