FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : SetExpression Method |
'Declaration Public Overridable Sub SetExpression( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal value As Expression _ )
'Usage Dim instance As DefaultSheetDataModel Dim row As Integer Dim column As Integer Dim value As Expression instance.SetExpression(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())
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