Visual Basic (Declaration) | |
---|---|
Public Property AllowUserFormulas As Boolean |
Visual Basic (Usage) | ![]() |
---|---|
Dim instance As SpreadView 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 otherwiseWhen 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.
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