Gets a string that contains a relative reference to this row in the current reference style.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overloads Function ToString( _
ByVal relativeTo As Row _
) As String |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Row
Dim relativeTo As Row
Dim value As String
value = instance.ToString(relativeTo) |
Parameters
- relativeTo
- Row to use for computing the relative reference
Return Value
String containing a relative reference to this row in the current reference style
Remarks
Example
This example uses the Formula property to sum two values and places the result in the appropriate cell.
| C# | Copy Code |
|---|
FarPoint.Win.Spread.Row row0, row1, row2;
row0 = fpSpread1.ActiveSheet.Rows[0];
row0.CellType = new FarPoint.Win.Spread.CellType.NumberCellType();
row1 = fpSpread1.ActiveSheet.Rows[2];
row2 = fpSpread1.ActiveSheet.Rows[3];
fpSpread1.ActiveSheet.Cells[2, 3].Value = 10;
fpSpread1.ActiveSheet.Cells[2, 2].Value = 10;
row0.Formula = "SUM(" + row1.ToString(row2) + "," + row2.ToString(row1) + ")"; |
| Visual Basic | Copy Code |
|---|
Dim row0, row1, row2 As FarPoint.Win.Spread.Row
row0 = FpSpread1.ActiveSheet.Rows(0)
row0.CellType = New FarPoint.Win.Spread.CellType.NumberCellType()
row1 = FpSpread1.ActiveSheet.Rows(2)
row2 = FpSpread1.ActiveSheet.Rows(3)
FpSpread1.ActiveSheet.Cells(2, 3).Value = 10
FpSpread1.ActiveSheet.Cells(2, 2).Value = 10
row0.Formula = "SUM(" + row1.ToString(row2) + "," + row2.ToString(row1) + ")" |
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
