Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / ReferenceStyle Property

In This Topic
    ReferenceStyle Property (SheetView)
    In This Topic
    Gets or sets the style for cell and range references in formulas in cells on this sheet.
    Public Property ReferenceStyle As ReferenceStyle
    Dim instance As SheetView
    Dim value As ReferenceStyle
    instance.ReferenceStyle = value
    value = instance.ReferenceStyle
    public ReferenceStyle ReferenceStyle {get; set;}

    Property Value

    ReferenceStyle setting that determines the cell reference style


    For more information about formulas, refer to the Formula Reference.

    This example sets the reference style used by the sheet to represent formulas.
    fpSpread1.ActiveSheet.Iteration = true;
    fpSpread1.ActiveSheet.SetValue(0, 1, 20);
    fpSpread1.ActiveSheet.MaximumIterations = 5;
    fpSpread1.ActiveSheet.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
    fpSpread1.ActiveSheet.SetFormula(0, 0, "R1C2+R1C3");
    fpSpread1.ActiveSheet.SetFormula(0, 2, "R1C1*3");
    FpSpread1.ActiveSheet.Iteration = True
    FpSpread1.ActiveSheet.SetValue(0, 1, 20)
    FpSpread1.ActiveSheet.MaximumIterations = 5
    FpSpread1.ActiveSheet.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
    FpSpread1.ActiveSheet.SetFormula(0, 0, "R1C2+R1C3")
    FpSpread1.ActiveSheet.SetFormula(0, 2, "R1C1*3")
    See Also


    SheetView Class
    SheetView Members

    User-Task Documentation

    Formula Reference