EnableCrossSheetReference Property

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

Boolean: true if cross-sheet referencing is enabled; false otherwise

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.

This example sums the values from the first sheet and places the sum in the second.

C#

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

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"

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FpSpread Class
FpSpread Members
Sheet References in a Formula

User-Task Documentation

Specifying a Cell Reference