Spread for ASP.NET 9.0 Product Documentation
ToString(Column) Method
Example 


Column to use for computing the relative reference
Gets a string that contains a relative reference to this column in the current reference style.
Syntax
'Declaration
 
Public Overloads Function ToString( _
   ByVal relativeTo As Column _
) As String
'Usage
 
Dim instance As Column
Dim relativeTo As Column
Dim value As String
 
value = instance.ToString(relativeTo)
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
ExceptionDescription
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.
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) + ")";
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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

Column Class
Column Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.