Spread for ASP.NET 9.0 Product Documentation
EnableCrossSheetReference Property
Example 


Gets or sets whether to enable cross-sheet referencing for the Spread component.
Syntax
'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";
FpSpread1.EnableCrossSheetReference = True
FpSpread1.ActiveSheetView.Cells(2, 2).Formula = "FirstRoundData!A2 + SecondRoundData!A2"
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Formula Reference

 

 


Copyright © GrapeCity, inc. All rights reserved.