Spread Windows Forms 9.0 Product Documentation
BinaryOperatorExpression Constructor
Example 


Operator
Left-side operand
Right-side operand
Creates a new expression with a binary operator applied to a pair of operands.
Syntax
'Declaration
 
Public Function New( _
   ByVal oper As BinaryOperatorInfo, _
   ByVal arg0 As Expression, _
   ByVal arg1 As Expression _
)
'Usage
 
Dim oper As BinaryOperatorInfo
Dim arg0 As Expression
Dim arg1 As Expression
 
Dim instance As New BinaryOperatorExpression(oper, arg0, arg1)
public BinaryOperatorExpression( 
   BinaryOperatorInfo oper,
   Expression arg0,
   Expression arg1
)

Parameters

oper
Operator
arg0
Left-side operand
arg1
Right-side operand
Exceptions
ExceptionDescription
System.ArgumentNullExceptionoper or arg0 or arg1 is a null reference (Nothing in Visual Basic)
Example
This example creates a new expression with a binary operator applied to a pair of operands.
FarPoint.CalcEngine.Expression arg1 = new FarPoint.CalcEngine.DoubleExpression(1.0);
FarPoint.CalcEngine.Expression arg2 = new FarPoint.CalcEngine.DoubleExpression(2.0);
FarPoint.CalcEngine.Expression oneplustwo = new FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator,arg1, arg2);
//Spread for Windows Forms
((FarPoint.Win.Spread.Model.IExpressionSupport)fpSpread1.ActiveSheet.Models.Data).SetExpression(0, 0, oneplustwo);
//Spread for Web Forms
((FarPoint.Web.Spread.Model.IExpressionSupport)FpSpread1.Sheets[0].DataModel).SetExpression(0, 0, oneplustwo);
Dim arg1 As FarPoint.CalcEngine.Expression
Dim arg2 As FarPoint.CalcEngine.Expression
Dim oneplustwo As FarPoint.CalcEngine.Expression
arg1 = New FarPoint.CalcEngine.DoubleExpression(1.0)
arg2 = New FarPoint.CalcEngine.DoubleExpression(2.0)
oneplustwo = New FarPoint.CalcEngine.BinaryOperatorExpression(FarPoint.CalcEngine.BinaryOperatorInfo.AddOperator, arg1, arg2)
'Spread for Windows Forms
CType(FpSpread1.ActiveSheet.Models.Data, FarPoint.Win.Spread.Model.IExpressionSupport).SetExpression(0, 0, oneplustwo)
'Spread for Web Forms
CType(FpSpread1.Sheets(0).DataModel, FarPoint.Web.Spread.Model.IExpressionSupport).SetExpression(0, 0, oneplustwo)
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

BinaryOperatorExpression Class
BinaryOperatorExpression Members

 

 


Copyright © GrapeCity, inc. All rights reserved.