Spread Windows Forms 13.0 Product Documentation
FarPoint.CalcEngine Assembly / FarPoint.CalcEngine Namespace / CalcMissingArgument Class / CalcMissingArgument Constructor
Example


In This Topic
    CalcMissingArgument Constructor
    In This Topic
    Creates a new instance of the CalcMissingArgument class.
    Syntax
    'Declaration
     
    Public Function New()
    'Usage
     
    Dim instance As New CalcMissingArgument()
    public CalcMissingArgument()
    Example
    This example returns the number of columns and rows in the array.
    FarPoint.CalcEngine.Expression arg1 = new FarPoint.CalcEngine.DoubleExpression(0.01);
    FarPoint.CalcEngine.Expression arg2 = new FarPoint.CalcEngine.DoubleExpression(12.0);
    FarPoint.CalcEngine.Expression arg3 = new FarPoint.CalcEngine.DoubleExpression(-1000.0);
    FarPoint.CalcEngine.Expression arg4 = new FarPoint.CalcEngine.MissingArgumentExpression();
    FarPoint.CalcEngine.Expression arg5 = new FarPoint.CalcEngine.DoubleExpression(1.0);
    FarPoint.CalcEngine.Expression[] args = {arg1, arg2, arg3, arg4, arg5};
    FarPoint.CalcEngine.Expression expr = new FarPoint.CalcEngine.FunctionExpression(FarPoint.CalcEngine.FunctionInfo.FvFunction,args);
    //Spread for Windows Forms
    ((FarPoint.Win.Spread.Model.IExpressionSupport)fpSpread1.ActiveSheet.Models.Data).SetExpression(0, 0, expr);
    Object arg11 = 0.01;
    Object arg12 = 12.0;
    Object arg13 = -1000.0;
    FarPoint.CalcEngine.CalcMissingArgument arg14 = new FarPoint.CalcEngine.CalcMissingArgument();
    Object arg15 = 1.0;
    Object[] args20 = new Object[] {arg11, arg12, arg13, arg14, arg15};
    Object result = FarPoint.CalcEngine.FunctionInfo.FvFunction.Evaluate(args20);
    FarPoint.CalcEngine.MissingArgumentExpression ma = new FarPoint.CalcEngine.MissingArgumentExpression();
    arg14 = ma.MissingArgumentValue;
    MessageBox.Show(arg14.ToString());
    //Spread for Web Forms
    ((FarPoint.Web.Spread.Model.IExpressionSupport)FpSpread1.Sheets[0].DataModel).SetExpression(0, 0, expr);
    Object arg11 = 0.01;
    Object arg12 = 12.0;
    Object arg13 = -1000.0;
    FarPoint.CalcEngine.CalcMissingArgument arg14 = new FarPoint.CalcEngine.CalcMissingArgument();
    Object arg15 = 1.0;
    Object[] args20 = new Object[] {arg11, arg12, arg13, arg14, arg15};
    Object result = FarPoint.CalcEngine.FunctionInfo.FvFunction.Evaluate(args20);
    FarPoint.CalcEngine.MissingArgumentExpression ma = new FarPoint.CalcEngine.MissingArgumentExpression();
    arg14 = ma.MissingArgumentValue;
    TextBox1.Text = arg14.ToString();
    Dim arg1 As New FarPoint.CalcEngine.DoubleExpression(0.01)
    Dim arg2 As New FarPoint.CalcEngine.DoubleExpression(12.0)
    Dim arg3 As New FarPoint.CalcEngine.DoubleExpression(-1000.0)
    Dim arg4 As New FarPoint.CalcEngine.MissingArgumentExpression
    Dim arg5 As New FarPoint.CalcEngine.DoubleExpression(1.0)
    Dim args() As FarPoint.CalcEngine.Expression = {arg1, arg2, arg3, arg4, arg5}
    Dim expr As New FarPoint.CalcEngine.FunctionExpression(FarPoint.CalcEngine.FunctionInfo.FvFunction, args)
    'Spread for Windows Forms
    CType(FpSpread1.ActiveSheet.Models.Data, FarPoint.Win.Spread.Model.IExpressionSupport).SetExpression(0, 0, expr)
    Dim arg11 As Object = 0.01
    Dim arg12 As Object = 12.0
    Dim arg13 As Object = -1000.0
    Dim arg14 As New FarPoint.CalcEngine.CalcMissingArgument
    Dim arg15 As Object = 1.0
    Dim args20() As Object = {arg11, arg12, arg13, arg14, arg15}
    Dim result As [Object] = FarPoint.CalcEngine.FunctionInfo.FvFunction.Evaluate(args20)
    Dim ma As New FarPoint.CalcEngine.MissingArgumentExpression
    arg14 = ma.MissingArgumentValue
    MessageBox.Show(arg14.ToString())
    'Spread for Web Forms
    CType(FpSpread1.Sheets(0).DataModel, FarPoint.Web.Spread.Model.IExpressionSupport).SetExpression(0, 0, expr)
    Dim arg11 As Object = 0.01
    Dim arg12 As Object = 12.0
    Dim arg13 As Object = -1000.0
    Dim arg14 As New FarPoint.CalcEngine.CalcMissingArgument
    Dim arg15 As Object = 1.0
    Dim args20() As Object = {arg11, arg12, arg13, arg14, arg15}
    Dim result As [Object] = FarPoint.CalcEngine.FunctionInfo.FvFunction.Evaluate(args20)
    Dim ma As New FarPoint.CalcEngine.MissingArgumentExpression
    arg14 = ma.MissingArgumentValue
    TextBox1.Text = arg14.ToString()
    See Also