Spread WPF 14
GrapeCity.Windows.SpreadSheet.UI Namespace / GcSpreadSheet Class / CanUserEditFormula Property
Example


In This Topic
    CanUserEditFormula Property (GcSpreadSheet)
    In This Topic
    Gets or sets whether to allow the user to enter formulas in a cell in the component.
    Syntax
    'Declaration
     
    <CategoryAttribute("Spread Formulas")>
    <DefaultValueAttribute(True)>
    Public Property CanUserEditFormula As Boolean
    'Usage
     
    Dim instance As GcSpreadSheet
    Dim value As Boolean
     
    instance.CanUserEditFormula = value
     
    value = instance.CanUserEditFormula
    [Category("Spread Formulas")]
    [DefaultValue(true)]
    public 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;
    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
    See Also