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
Boolean: true if cross-sheet referencing is enabled; false otherwiseRemarks
In a multiple-sheet Spread component, a formula in a cell can refer to a cell in an entirely different sheet. This allows calculations to make use of data and formulas on any of the sheets in a Spread component. Referencing a cell in another sheet is called cross-sheet referencing.
Set this property to true to allow and enable cross-sheet references; set this property to false to disallow or disable cross-sheet references.
Refer to Sheet References in a Formula for more information about making the sheet name explicit in a cell reference.
Example
| C# | Copy Code |
|---|---|
fpSpread1.EnableCrossSheetReference = true; fpSpread1.Sheets.Count = 2; fpSpread1.Sheets[0].Cells[0, 0, 50, 50].CellType = new FarPoint.Win.Spread.CellType.NumberCellType(); fpSpread1.ActiveSheet.Cells[0, 0].Value = 100; fpSpread1.ActiveSheet.Cells[1, 0].Value = 100; fpSpread1.Sheets(1).Cells[0, 0, 50, 50].CellType = new FarPoint.Win.Spread.CellType.NumberCellType(); fpSpread1.Sheets(1).Cells[1, 3].Formula = "Sheet1!A1+Sheet1!A2"; | |
| Visual Basic | Copy Code |
|---|---|
FpSpread1.EnableCrossSheetReference = True FpSpread1.Sheets.Count = 2 FpSpread1.Sheets(0).Cells(0, 0, 50, 50).CellType = New FarPoint.Win.Spread.CellType.NumberCellType FpSpread1.ActiveSheet.Cells(0, 0).Value = 100 FpSpread1.ActiveSheet.Cells(1, 0).Value = 100 FpSpread1.Sheets(1).Cells(0, 0, 50, 50).CellType = New FarPoint.Win.Spread.CellType.NumberCellType FpSpread1.Sheets(1).Cells(1, 3).Formula = "Sheet1!A1+Sheet1!A2" | |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
Reference
FpSpread ClassFpSpread Members
Sheet References in a Formula