Gets a string that contains an absolute reference to this cell in the specified reference style.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Cell
Dim referenceStyle As ReferenceStyle
Dim value As String
value = instance.ToString(referenceStyle) |
Parameters
- referenceStyle
- Style of cell reference
Return Value
String containing label text an absolute reference to this cell in the specified reference style
Example
This example creates a Cell object and uses its formula property to sum the values of two cells.
| C# | Copy Code |
|---|
FarPoint.Win.Spread.Cell acell, mycell, urcell;
acell = fpSpread1.ActiveSheet.Cells[0, 0];
mycell = fpSpread1.ActiveSheet.Cells[2, 2];
urcell = fpSpread1.ActiveSheet.Cells[2, 3];
fpSpread1.ActiveSheet.Cells[2, 2].Value = 10;
fpSpread1.ActiveSheet.Cells[2, 3].Value = 10;
acell.Formula = "SUM(" + mycell.ToString(FarPoint.Win.Spread.Model.ReferenceStyle.A1) + "," + urcell.ToString(FarPoint.Win.Spread.Model.ReferenceStyle.A1)
+ ")"; |
| Visual Basic | Copy Code |
|---|
Dim acell, mycell, urcell As FarPoint.Win.Spread.Cell
acell = FpSpread1.ActiveSheet.Cells(0, 0)
mycell = FpSpread1.ActiveSheet.Cells(2, 2)
urcell = FpSpread1.ActiveSheet.Cells(2, 3)
FpSpread1.ActiveSheet.Cells(2, 3).Value = 10
FpSpread1.ActiveSheet.Cells(2, 2).Value = 10
acell.Formula = "SUM(" + mycell.ToString(FarPoint.Win.Spread.Model.ReferenceStyle.A1) + "," + urcell.ToString(FarPoint.Win.Spread.Model.ReferenceStyle.A1)
+ ")" |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
