Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / ReferenceStyle Enumeration
Example Example


In This Topic
    ReferenceStyle Enumeration
    In This Topic
    Specifies the reference style in formulas and custom names in the sheet.
    Syntax
    'Declaration
     
    Public Enum ReferenceStyle 
       Inherits System.Enum
    'Usage
     
    Dim instance As ReferenceStyle
    public enum ReferenceStyle : System.Enum 
    Members
    MemberDescription
    A1Uses letters and numbers for column and row coordinates; uses dollar sign ($) for absolute coordinates
    R1C1Uses "R" and number for row, "C" and number for column coordinates; uses brackets [ ] for relative coordinates
    Example
    This example uses three Command Buttons, each of which uses a different reference style to multiply the values in two cells in the sheet. The type of reference style used is returned to a list box.
    private void Page_Load(object sender,System.EventArgs e)
    {
    FpSpread1.ActiveSheetView.SetValue(0,0,5);
    FpSpread1.ActiveSheetView.SetValue(0,1,15);
    }
    
    private voidA1_Click(object sender,System.EventArgs e)
    {
    FpSpread1.ActiveSheetView.ReferenceStyle=FarPoint.Web.Spread.Model.ReferenceStyle.A1;
    FpSpread1.ActiveSheetView.SetFormula(0,3,"(A1*B1)");
    FarPoint.Web.Spread.Model.ReferenceStyle refstyle;
    refstyle=FpSpread1.ActiveSheetView.ReferenceStyle;
    ListBox1.Items.Add(refstyle.ToString());
    }
    
    private voidR1C1_Click(object sender,System.EventArgs e)
    {
    FpSpread1.ActiveSheetView.ReferenceStyle=FarPoint.Web.Spread.Model.ReferenceStyle.R1C1;
    FpSpread1.ActiveSheetView.SetFormula(0,3,"(R1C1*R1C2)");
    FarPoint.Web.Spread.Model.ReferenceStyle refstyle;
    refstyle=FpSpread1.ActiveSheetView.ReferenceStyle;
    ListBox1.Items.Add(refstyle.ToString());
    }
    Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load
    FpSpread1.ActiveSheetView.SetValue(0,0,5)
    FpSpread1.ActiveSheetView.SetValue(0,1,15)
    End Sub
    
    Private SubA1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles A1.Click
    FpSpread1.ActiveSheetView.ReferenceStyle=FarPoint.Web.Spread.Model.ReferenceStyle.A1
    FpSpread1.ActiveSheetView.SetFormula(0,3,"(A1*B1)")
    Dim refstyle As FarPoint.Web.Spread.Model.ReferenceStyle
    refstyle=FpSpread1.ActiveSheetView.ReferenceStyle
    ListBox1.Items.Add(refstyle.ToString())
    End Sub
    
    Private SubR1C1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles R1C1.Click
    FpSpread1.ActiveSheetView.ReferenceStyle=FarPoint.Web.Spread.Model.ReferenceStyle.R1C1
    FpSpread1.ActiveSheetView.SetFormula(0,3,"(R1C1*R1C2)")
    Dim refstyle As FarPoint.Web.Spread.Model.ReferenceStyle
    refstyle=FpSpread1.ActiveSheetView.ReferenceStyle
    ListBox1.Items.Add(refstyle.ToString())
    End Sub
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             FarPoint.Web.Spread.Model.ReferenceStyle

    See Also