Gets or sets whether to enable cross-sheet referencing for the Spread component.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property EnableCrossSheetReference As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As FpSpread
Dim value As Boolean
instance.EnableCrossSheetReference = value
value = instance.EnableCrossSheetReference |
| C# | |
|---|
public bool EnableCrossSheetReference {get; set;} |
Property Value
true if cross-sheet referencing is allowed;
false otherwise
Remarks
Example
| C# | Copy Code |
|---|
FpSpread1.EnableCrossSheetReference = true;
FpSpread1.ActiveSheetView.Cells[2, 2].Formula = "FirstRoundData!A2 + SecondRoundData!A2"; |
| Visual Basic | Copy Code |
|---|
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
See Also
