Spread for ASP.NET 7.0 Product Documentation
EnableCrossSheetReference Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class : EnableCrossSheetReference Property


Glossary Item Box

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

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

C#Copy Code
FpSpread1.EnableCrossSheetReference = true;
FpSpread1.ActiveSheetView.Cells[2, 2].Formula = "FirstRoundData!A2 + SecondRoundData!A2";
Visual BasicCopy 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

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Formula Reference

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.