Gets a string that contains a relative reference to this column in the current reference style.

Syntax

Visual Basic (Declaration)
Public Overloads Function ToString( _ ByVal relativeTo As Column _ ) As String

Visual Basic (Usage)	Copy Code
Dim instance As Column Dim relativeTo As Column Dim value As String value = instance.ToString(relativeTo)

C#
public string ToString( Column relativeTo )

Parameters

relativeTo: Column to use for computing the relative reference

Return Value

String containing the reference to this column

Exceptions

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

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.Column col, col1, col2; col = fpSpread1.ActiveSheetView.Columns[0]; col.CellType = new FarPoint.Web.Spread.CellType.NumberCellType(); col1 = fpSpread1.ActiveSheetView.Columns[2]; col2 = fpSpread1.ActiveSheetView.Columns[3]; fpSpread1.ActiveSheetView.Cells[2, 3].Value = 10; fpSpread1.ActiveSheetView.Cells[2, 2].Value = 10; col.Formula = "SUM(" + col1.ToString(col2) + "," + col2.ToString(col1) + ")";

Copy Code

FarPoint.Web.Spread.Column col, col1, col2;
col = fpSpread1.ActiveSheetView.Columns[0];
col.CellType = new FarPoint.Web.Spread.CellType.NumberCellType();
col1 = fpSpread1.ActiveSheetView.Columns[2];
col2 = fpSpread1.ActiveSheetView.Columns[3];
fpSpread1.ActiveSheetView.Cells[2, 3].Value = 10;
fpSpread1.ActiveSheetView.Cells[2, 2].Value = 10;
col.Formula = "SUM(" + col1.ToString(col2) + "," + col2.ToString(col1) + ")";

Visual Basic	Copy Code
Dim col, col1, col2 As FarPoint.Web.Spread.Column col = FpSpread1.ActiveSheetView.Columns(0) col.CellType = New FarPoint.Web.Spread.CellType.NumberCellType() col1 = FpSpread1.ActiveSheetView.Columns(2) col2 = FpSpread1.ActiveSheetView.Columns(3) FpSpread1.ActiveSheetView.Cells(2, 3).Value = 10 FpSpread1.ActiveSheetView.Cells(2, 2).Value = 10 col.Formula = "SUM(" + col1.ToString(col2) + "," + col2.ToString(col1) + ")"

Visual Basic

Copy Code

Dim col, col1, col2 As FarPoint.Web.Spread.Column
col = FpSpread1.ActiveSheetView.Columns(0)
col.CellType = New FarPoint.Web.Spread.CellType.NumberCellType()
col1 = FpSpread1.ActiveSheetView.Columns(2)
col2 = FpSpread1.ActiveSheetView.Columns(3)
FpSpread1.ActiveSheetView.Cells(2, 3).Value = 10
FpSpread1.ActiveSheetView.Cells(2, 2).Value = 10
col.Formula = "SUM(" + col1.ToString(col2) + "," + col2.ToString(col1) + ")"

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