CanUserEditFormula Property (GcSpreadSheet)

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

Syntax

Visual Basic
C#

'Declaration
 
<System.ComponentModel.CategoryAttribute("Spread Formulas")>
<System.ComponentModel.DefaultValueAttribute()>
Public Property CanUserEditFormula As System.Boolean

'Usage
 
Dim instance As GcSpreadSheet
Dim value As System.Boolean
 
instance.CanUserEditFormula = value
 
value = instance.CanUserEditFormula

[System.ComponentModel.Category("Spread Formulas")]
[System.ComponentModel.DefaultValue()]
public System.bool CanUserEditFormula {get; set;}

Example

This example sets the CanUserEditFormula property.

gcSpreadSheet1.ActiveSheetIndex = 0;
gcSpreadSheet1.CanUserEditFormula = true;
\\Silverlight
\\gcSpreadSheet1.GridLineColor = Color.FromArgb(100, 100, 50, 10);
\\WPF
\\gcSpreadSheet1.GridLineColor = Color.FromRgb(100, 50, 10);
gcSpreadSheet1.Protect = false;

VB.NET

GcSpreadSheet1.ActiveSheetIndex = 0
GcSpreadSheet1.CanUserEditFormula = True
'Silverlight
'GcSpreadSheet1.GridLineColor = Color.FromArgb(100, 100, 50, 10)
'WPF
'GcSpreadSheet1.GridLineColor = Color.FromRgb(100, 50, 10)
GcSpreadSheet1.Protect = False

Reference

GcSpreadSheet Class
GcSpreadSheet Members