Spread for ASP.NET 8.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 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)
+ ")";
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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

Cell Class
Cell Members
Overload List
ReferenceStyle Enumeration

 

 


Copyright © GrapeCity, inc. All rights reserved.