Spread Windows Forms 9.0 Product Documentation
ToString(ReferenceStyle) Method
Example 


Style of cell reference
Gets a string that contains an absolute reference to this cell in the specified reference style.
Syntax
'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 label text 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.Win.Spread.Cell acell, mycell, urcell;
acell = fpSpread1.ActiveSheet.Cells[0, 0];
mycell = fpSpread1.ActiveSheet.Cells[2, 2];
urcell = fpSpread1.ActiveSheet.Cells[2, 3];
fpSpread1.ActiveSheet.Cells[2, 2].Value = 10;
fpSpread1.ActiveSheet.Cells[2, 3].Value = 10;
acell.Formula = "SUM(" + mycell.ToString(FarPoint.Win.Spread.Model.ReferenceStyle.A1) + "," + urcell.ToString(FarPoint.Win.Spread.Model.ReferenceStyle.A1)
+ ")";
Dim acell, mycell, urcell As FarPoint.Win.Spread.Cell
acell = FpSpread1.ActiveSheet.Cells(0, 0)
mycell = FpSpread1.ActiveSheet.Cells(2, 2)
urcell = FpSpread1.ActiveSheet.Cells(2, 3)
FpSpread1.ActiveSheet.Cells(2, 3).Value = 10
FpSpread1.ActiveSheet.Cells(2, 2).Value = 10
acell.Formula = "SUM(" + mycell.ToString(FarPoint.Win.Spread.Model.ReferenceStyle.A1) + "," + urcell.ToString(FarPoint.Win.Spread.Model.ReferenceStyle.A1)
+ ")"
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

Cell Class
Cell Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.