ToString(Row,ReferenceStyle) Method

Gets a string that contains a relative reference to this cell in the specified reference style.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Function ToString( _
   ByVal relativeTo As Row, _
   ByVal referenceStyle As ReferenceStyle _
) As String

'Usage
 
Dim instance As Row
Dim relativeTo As Row
Dim referenceStyle As ReferenceStyle
Dim value As String
 
value = instance.ToString(relativeTo, referenceStyle)

public string ToString( 
   Row relativeTo,
   ReferenceStyle referenceStyle
)

Parameters

relativeTo: Row to use for computing the relative reference
referenceStyle: Reference style

Return Value

String containing the reference to this row

Exceptions

Exception	Description
System.ArgumentNullException	Row is not specified or is not valid; must provide a valid Row object

Example

This example uses the Formula property to sum two values and places the result in the appropriate cell.

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

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)
+ ")"

Reference

Row Class
Row Members
Overload List