Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / EnableCrossSheetReference Property

In This Topic
    EnableCrossSheetReference Property
    In This Topic
    Gets or sets whether to enable cross-sheet referencing for the Spread component.
    Public Property EnableCrossSheetReference As Boolean
    Dim instance As FpSpread
    Dim value As Boolean
    instance.EnableCrossSheetReference = value
    value = instance.EnableCrossSheetReference
    public bool EnableCrossSheetReference {get; set;}

    Property Value

    true if cross-sheet referencing is allowed; false otherwise

    Cross-sheet referencing in formulas is the referencing of cells in others sheets in the component.

    For more information about formulas and cross-sheet referencing, refer to the Spread for .NET Formula Reference.

    FpSpread1.EnableCrossSheetReference = true;
    FpSpread1.ActiveSheetView.Cells[2, 2].Formula = "FirstRoundData!A2 + SecondRoundData!A2";
    FpSpread1.EnableCrossSheetReference = True
    FpSpread1.ActiveSheetView.Cells(2, 2).Formula = "FirstRoundData!A2 + SecondRoundData!A2"
    See Also


    FpSpread Class
    FpSpread Members

    User-Task Documentation

    Formula Reference