Spread Windows Forms 7.0 Product Documentation
CalcMissingArgument Constructor
See Also  Example Support Options
FarPoint.CalcEngine Assembly > FarPoint.CalcEngine Namespace > CalcMissingArgument Class : CalcMissingArgument Constructor


Glossary Item Box

Creates a new instance of the CalcMissingArgument class.

Syntax

Visual Basic (Declaration) 
Public Function New()
Visual Basic (Usage)Copy Code
Dim instance As New CalcMissingArgument()
C# 
public CalcMissingArgument()

Example

This example returns the number of columns and rows in the array.
C#Copy Code
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();
Visual BasicCopy Code
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()

Requirements

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.