FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Row Class > ToString Method : ToString(Row,ReferenceStyle) Method |
'Declaration Public Overloads Function ToString( _ ByVal relativeTo As Row, _ ByVal referenceStyle As ReferenceStyle _ ) As String
'Usage Dim instance As Row Dim relativeTo As Row Dim referenceStyle As ReferenceStyle Dim value As String value = instance.ToString(relativeTo, referenceStyle)
public string ToString( Row relativeTo, ReferenceStyle referenceStyle )
Exception | Description |
---|---|
System.ArgumentNullException | Row is not specified or is not valid; must provide a valid Row object |
Header rows always return String.Empty because they cannot be referenced.
FarPoint.Win.Spread.Row row0, row1, row2; row0 = fpSpread1.ActiveSheet.Rows[0]; row0.CellType = new FarPoint.Win.Spread.CellType.NumberCellType(); row1 = fpSpread1.ActiveSheet.Rows[2]; row2 = fpSpread1.ActiveSheet.Rows[3]; fpSpread1.ActiveSheet.Cells[2, 3].Value = 10; fpSpread1.ActiveSheet.Cells[2, 2].Value = 10; row0.Formula = "SUM(" + row1.ToString(row2, FarPoint.Win.Spread.Model.ReferenceStyle.A1) + "," + row2.ToString(row1, FarPoint.Win.Spread.Model.ReferenceStyle.A1) + ")";
Dim row0, row1, row2 As FarPoint.Win.Spread.Row row0 = FpSpread1.ActiveSheet.Rows(0) row0.CellType = New FarPoint.Win.Spread.CellType.NumberCellType() row1 = FpSpread1.ActiveSheet.Rows(2) row2 = FpSpread1.ActiveSheet.Rows(3) FpSpread1.ActiveSheet.Cells(2, 3).Value = 10 FpSpread1.ActiveSheet.Cells(2, 2).Value = 10 row0.Formula = "SUM(" + row1.ToString(row2, FarPoint.Win.Spread.Model.ReferenceStyle.A1) + "," + row2.ToString(row1, FarPoint.Win.Spread.Model.ReferenceStyle.A1) + ")"
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8