FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > Row クラス > ToString メソッド : ToString(Row,ReferenceStyle) メソッド |
'Declaration Public Overloads Function ToString( _ ByVal relativeTo As Row, _ ByVal referenceStyle As ReferenceStyle _ ) As String
'使用法 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 )
例外 | 説明 |
---|---|
System.ArgumentNullException | 行が指定されていないか無効です。有効なRowオブジェクトを指定してください。 |
ヘッダ行は参照できないので、常に String.Empty を返します。
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) + ")"