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 a relative reference to this row in the specified reference style
Exceptions
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, FarPoint.Win.Spread.Model.ReferenceStyle.A1) + "," + row2.ToString(row1, FarPoint.Win.Spread.Model.ReferenceStyle.A1)
+ ")"; |
| 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, FarPoint.Win.Spread.Model.ReferenceStyle.A1) + "," + row2.ToString(row1, FarPoint.Win.Spread.Model.ReferenceStyle.A1)
+ ")" |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
