MESCIUS SPREAD for ASP.NET 10.0J
SetExpression メソッド (DefaultSheetDataModel)

セルの行インデックス
セルの列インデックス
設定する数式(式)
指定した行と列のセルに、数式を式値として設定します。
構文
'Declaration
 
Public Overridable Sub SetExpression( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal value As Expression _
) 
public virtual void SetExpression( 
   int row,
   int column,
   Expression value
)

パラメータ

row
セルの行インデックス
column
セルの列インデックス
value
設定する数式(式)
次のサンプルコードは、指定した行および列のセルの数式を、式の値として返します。
FarPoint.CalcEngine.Expression one; 
FarPoint.CalcEngine.Expression two; 
FarPoint.CalcEngine.Expression oneplustwo; 
FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel; 
one = new FarPoint.CalcEngine.DoubleExpression(100); 
two = new FarPoint.CalcEngine.DoubleExpression(20); 
oneplustwo = new FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two);

dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
dataModel.SetExpression(0, 0, oneplustwo);
 
FarPoint.CalcEngine.Expression x; 
x = dataModel.GetExpression(0, 0); 
Response.Write(x.ToString());
Dim dfltdatamodel As FarPoint.Web.Spread.Model.DefaultSheetDataModel
Dim one As FarPoint.CalcEngine.Expression
Dim two As FarPoint.CalcEngine.Expression
Dim oneplustwo As FarPoint.CalcEngine.Expression
one = New FarPoint.CalcEngine.DoubleExpression(100.0)
two = New FarPoint.CalcEngine.DoubleExpression(20.0)
oneplustwo = New FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, one, two)

dfltdatamodel = FpSpread1.ActiveSheetView.DataModel
dfltdatamodel.SetExpression(0, 0, oneplustwo)

Dim x As FarPoint.CalcEngine.Expression
x = dfltdatamodel.GetExpression(0, 0)
Response.Write(x.ToString()) 
参照

DefaultSheetDataModel クラス
DefaultSheetDataModel メンバ
GetExpression メソッド

 

 


© MESCIUS inc. All rights reserved.