Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.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
    A1 Uses letters and numbers for column and row coordinates; uses dollar sign ($) for absolute coordinates
    R1C1 Uses "R" and number for row, "C" and number for column coordinates; uses brackets [ ] for relative coordinates
    Example
    This example sets the reference style for the formulas in the spreadsheet.
    fpSpread1.ActiveSheet.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
    fpSpread1.ActiveSheet.Cells[0, 0].Value = 10;
    fpSpread1.ActiveSheet.Cells[1, 0].Value = 30;
    fpSpread1.ActiveSheet.SetFormula(3, 0, "R1C1 * R2C1");
    FpSpread1.ActiveSheet.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
    FpSpread1.ActiveSheet.Cells(0, 0).Value = 10
    FpSpread1.ActiveSheet.Cells(1, 0).Value = 30
    FpSpread1.ActiveSheet.SetFormula(3, 0, "R1C1 * R2C1")
    Inheritance Hierarchy

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

    See Also