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 the reference to this row
Example
This example uses the Formula property to sum two values and places the result in the appropriate cell.
| C# | Copy Code |
|---|
FarPoint.Web.Spread.Row row0, row1, row2;
row0 = fpSpread1.ActiveSheetView.Rows[0];
row0.CellType = new FarPoint.Web.Spread.IntegerCellType();
row1 = fpSpread1.ActiveSheetView.Rows[2];
row2 = fpSpread1.ActiveSheetView.Rows[3];
fpSpread1.ActiveSheetView.Cells[2, 3].Value = 10;
fpSpread1.ActiveSheetView.Cells[2, 2].Value = 10;
row0.Formula = "SUM(" + row1.ToString(row2) + "," + row2.ToString(row1) + ")"
|
| Visual Basic | Copy Code |
|---|
Dim row0, row1, row2 As FarPoint.Web.Spread.Row
FpSpread1.ActiveSheetView.RowCount = 4
row0 = FpSpread1.ActiveSheetView.Rows(0)
row0.CellType = New FarPoint.Web.Spread.IntegerCellType
row1 = FpSpread1.ActiveSheetView.Rows(2)
row2 = FpSpread1.ActiveSheetView.Rows(3)
FpSpread1.ActiveSheetView.Cells(2, 3).Value = 10
FpSpread1.ActiveSheetView.Cells(2, 2).Value = 10
row0.Formula = "SUM(" + row1.ToString(row2) + "," + row2.ToString(row1) + ")" |
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
