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