FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class : EnableCrossSheetReference Property |
'Declaration Public Property EnableCrossSheetReference As Boolean
'Usage Dim instance As FpSpread Dim value As Boolean instance.EnableCrossSheetReference = value value = instance.EnableCrossSheetReference
public bool EnableCrossSheetReference {get; set;}
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"
Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional