Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / ReferenceStyle Property
Example


In This Topic
    ReferenceStyle Property (Worksheet)
    In This Topic
    Gets or sets the style for cell and range references in cell formulas on this sheet.
    Syntax
    'Declaration
     
    <DefaultValueAttribute(Mono.Cecil.CustomAttributeArgument)>
    Public Property ReferenceStyle As ReferenceStyle
    'Usage
     
    Dim instance As Worksheet
    Dim value As ReferenceStyle
     
    instance.ReferenceStyle = value
     
    value = instance.ReferenceStyle
    [DefaultValue(Mono.Cecil.CustomAttributeArgument)]
    public ReferenceStyle ReferenceStyle {get; set;}
    Example
    This example sets the ReferenceStyle property.
    gcSpreadSheet1.Sheets[0].DefaultColumnWidth = 30;
    gcSpreadSheet1.Sheets[0].DefaultRowHeight = 20;
    gcSpreadSheet1.Sheets[0].Cells(0, 0).Text = "test";
    gcSpreadSheet1.Sheets[0].ReferenceStyle = GrapeCity.Windows.SpreadSheet.Data.ReferenceStyle.A1;
    listBox1.Items.Add(gcSpreadSheet1.Sheets[0].LastNonEmptyRowIndex.ToString());
    gcSpreadSheet1.Invalidate();
    GcSpreadSheet1.Sheets(0).DefaultColumnWidth = 30
    GcSpreadSheet1.Sheets(0).DefaultRowHeight = 20
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "test"
    GcSpreadSheet1.Sheets(0).ReferenceStyle = GrapeCity.Windows.SpreadSheet.Data.ReferenceStyle.A1
    ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).LastNonEmptyRowIndex.ToString())
    GcSpreadSheet1.Invalidate()
    See Also