Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / AllowUserFormulas Property
Example


In This Topic
    AllowUserFormulas Property (FpSpread)
    In This Topic
    Gets or sets whether to allow the user to enter formulas in a cell in the component.
    Syntax
    'Declaration
     
    Public Property AllowUserFormulas As Boolean
    'Usage
     
    Dim instance As FpSpread
    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 specifies that users are allowed to type formulas into cells in the Spread component.
    FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
    FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
    DialogResult dlg;
    fpSpread1.Location = new Point(10, 10);
    fpSpread1.Height = 200;
    fpSpread1.Width = 400;
    Controls.Add(fpSpread1);
    fpSpread1.Sheets.Add(shv);
    fpSpread1.ActiveSheet.Cells[0, 0].CellType = new FarPoint.Win.Spread.CellType.NumberCellType();
    fpSpread1.ActiveSheet.Cells[1, 0].CellType = new FarPoint.Win.Spread.CellType.NumberCellType();
    fpSpread1.ActiveSheet.Cells[1, 2].CellType = new FarPoint.Win.Spread.CellType.NumberCellType();
    fpSpread1.ActiveSheet.SetValue(0, 0, 20);
    fpSpread1.ActiveSheet.SetValue(1, 0, 20);
    dlg = MessageBox.Show("Without going into edit mode, type =SUM(A1,A2) in the second row of the third column.", "AllowUserFormulas",
    MessageBoxButtons.OKCancel);
    if (dlg == DialogResult.OK)
    {
         fpSpread1.AllowUserFormulas = true;
    }
    Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
    Dim shv As New FarPoint.Win.Spread.SheetView()
    Dim dlg As DialogResult
    fpSpread1.Location = New Point(10, 10)
    fpSpread1.Height = 200
    fpSpread1.Width = 400
    Controls.Add(fpSpread1)
    fpSpread1.Sheets.Add(shv)
    fpSpread1.ActiveSheet.Cells(0, 0).CellType = New FarPoint.Win.Spread.CellType.NumberCellType()
    fpSpread1.ActiveSheet.Cells(1, 0).CellType = New FarPoint.Win.Spread.CellType.NumberCellType()
    fpSpread1.ActiveSheet.Cells(1, 2).CellType = New FarPoint.Win.Spread.CellType.NumberCellType()
    fpSpread1.ActiveSheet.SetValue(0, 0, 20)
    fpSpread1.ActiveSheet.SetValue(1, 0, 20)
    dlg = MessageBox.Show("Without going into edit mode, type =SUM(A1,A2) in the second row of the third column.", "AllowUserFormulas",
    MessageBoxButtons.OKCancel)
    If dlg = DialogResult.OK Then
         fpSpread1.AllowUserFormulas = True
    End If
    See Also