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.
    Public Enum ReferenceStyle 
       Inherits System.Enum
    Dim instance As ReferenceStyle
    public enum ReferenceStyle : System.Enum 
    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
    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


    See Also