PowerTools SPREAD for ASP.NET 8.0J
ToString(ReferenceStyle) メソッド

参照スタイル
この行を指定した参照スタイルで参照する文字列を取得します。
構文
'Declaration
 
Public Overloads Function ToString( _
   ByVal referenceStyle As ReferenceStyle _
) As String
public string ToString( 
   ReferenceStyle referenceStyle
)

パラメータ

referenceStyle
参照スタイル

戻り値の型

この行を参照するString
この例では、Formulaプロパティを使用して、2つの値を加算し、その結果を適切なセルに設定します。
FarPoint.Web.Spread.Row row0, row1, row2;
row0 = fpSpread1.ActiveSheetView.Rows[0];
row0.CellType = new FarPoint.Web.Spread.IntegerCellType();
row1 = fpSpread1.ActiveSheetView.Rows[2];
row2 = fpSpread1.ActiveSheetView.Rows[3];
fpSpread1.ActiveSheetView.Cells[2, 3].Value = 10;
fpSpread1.ActiveSheetView.Cells[2, 2].Value = 10;
row0.Formula = "SUM(" + row1.ToString(FarPoint.Web.Spread.Model.ReferenceStyle.A1) + "," + row2.ToString(FarPoint.Web.Spread.Model.ReferenceStyle.A1)
+ ")";
Dim row0, row1, row2 As FarPoint.Web.Spread.Row
FpSpread1.ActiveSheetView.RowCount = 4
row0 = FpSpread1.ActiveSheetView.Rows(0)
row0.CellType = New FarPoint.Web.Spread.IntegerCellType
row1 = FpSpread1.ActiveSheetView.Rows(2)
row2 = FpSpread1.ActiveSheetView.Rows(3)
FpSpread1.ActiveSheetView.Cells(2, 3).Value = 10
FpSpread1.ActiveSheetView.Cells(2, 2).Value = 10
row0.Formula = "SUM(" + row1.ToString(FarPoint.Web.Spread.Model.ReferenceStyle.A1) + "," + row2.ToString(FarPoint.Web.Spread.Model.ReferenceStyle.A1)
+ ")"
参照

Row クラス
Row メンバ
オーバーロード一覧

 

 


© 2003-2015, GrapeCity inc. All rights reserved.