EnableCrossSheetReference Property

Gets or sets whether to enable cross-sheet referencing for the Spread component.

Syntax

Visual Basic
C#

'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;}

Property Value

true if cross-sheet referencing is allowed; false otherwise

Remarks

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.

Example

FpSpread1.EnableCrossSheetReference = true;
FpSpread1.ActiveSheetView.Cells[2, 2].Formula = "FirstRoundData!A2 + SecondRoundData!A2";

Visual Basic

FpSpread1.EnableCrossSheetReference = True
FpSpread1.ActiveSheetView.Cells(2, 2).Formula = "FirstRoundData!A2 + SecondRoundData!A2"

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Formula Reference