Spread Windows Forms 7.0 Product Documentation
AllowUserFormulas Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : AllowUserFormulas Property


Glossary Item Box

Gets or sets whether to allow the user to enter formulas in a cell in the component.

Syntax

Visual Basic (Declaration) 
Public Property AllowUserFormulas As Boolean
Visual Basic (Usage)Copy Code
Dim instance As FpSpread
Dim value As Boolean
 
instance.AllowUserFormulas = value
 
value = instance.AllowUserFormulas
C# 
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.
C#Copy Code
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;
}
Visual BasicCopy Code
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

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.