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


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.
    Syntax
    'Declaration
     
    Public Property ReferenceStyle As ReferenceStyle
    'Usage
     
    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

    Remarks

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

    Example
    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

    Reference

    SheetView Class
    SheetView Members

    User-Task Documentation

    Formula Reference