Gets a string containing 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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
