ToString(ReferenceStyle) Method

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

Syntax

Visual Basic
C#

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

'Usage
 
Dim instance As Cell
Dim referenceStyle As ReferenceStyle
Dim value As String
 
value = instance.ToString(referenceStyle)

public string ToString( 
   ReferenceStyle referenceStyle
)

Parameters

referenceStyle: Style of cell reference

Return Value

String containing an absolute reference to this cell in the specified reference style

Example

This example creates a Cell object and uses its formula property to sum the values of two cells.

FarPoint.Web.Spread.Cell acell, mycell, urcell;
acell = fpSpread1.ActiveSheetView.Cells[0, 0];
mycell = fpSpread1.ActiveSheetView.Cells[2, 2];
urcell = fpSpread1.ActiveSheetView.Cells[2, 3];
fpSpread1.ActiveSheetView.Cells[2, 2].Value = 10;
fpSpread1.ActiveSheetView.Cells[2, 3].Value = 10;
acell.Formula = "SUM(" + mycell.ToString(FarPoint.Web.Spread.Model.ReferenceStyle.A1) + "," + urcell.ToString(FarPoint.Web.Spread.Model.ReferenceStyle.A1)
+ ")";

Visual Basic

Dim acell, mycell, urcell As FarPoint.Web.Spread.Cell
acell = FpSpread1.ActiveSheetView.Cells(0, 0)
mycell = FpSpread1.ActiveSheetView.Cells(2, 2)
urcell = FpSpread1.ActiveSheetView.Cells(2, 3)
FpSpread1.ActiveSheetView.Cells(2, 3).Value = 10
FpSpread1.ActiveSheetView.Cells(2, 2).Value = 10
acell.Formula = "SUM(" + mycell.ToString(FarPoint.Web.Spread.Model.ReferenceStyle.A1) + "," + urcell.ToString(FarPoint.Web.Spread.Model.ReferenceStyle.A1)
+ ")"

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

Cell Class
Cell Members
Overload List
ReferenceStyle Enumeration