Gets a string that contains a relative reference to this cell in the specified reference style.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Row
Dim relativeTo As Row
Dim referenceStyle As ReferenceStyle
Dim value As String
value = instance.ToString(relativeTo, referenceStyle) |
Parameters
- relativeTo
- Row to use for computing the relative reference
- referenceStyle
- Reference style
Return Value
String containing the reference to this row
Exceptions
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, FarPoint.Web.Spread.Model.ReferenceStyle.A1) + "," + row2.ToString(row1, FarPoint.Web.Spread.Model.ReferenceStyle.A1)
+ ")" |
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
