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.DefaultValueAttribute()>
<System.ComponentModel.CategoryAttribute("Spread Formulas")>
Public Property CanUserEditFormula As System.Boolean

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

[System.ComponentModel.DefaultValue()]
[System.ComponentModel.Category("Spread Formulas")]
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

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

GcSpreadSheet Class
GcSpreadSheet Members