Spread Windows Forms 8.0 Product Documentation
MissingArgumentValue Property
Example 


Gets the missing argument value as a CalcMissingArgument object.
Syntax
'Declaration
 
Public ReadOnly Property MissingArgumentValue As CalcMissingArgument
'Usage
 
Dim instance As MissingArgumentExpression
Dim value As CalcMissingArgument
 
value = instance.MissingArgumentValue
public CalcMissingArgument MissingArgumentValue {get;}

Property Value

CalcMissingArgument object containing the missing argument value
Example
This example returns a missing argument.
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()
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

Reference

MissingArgumentExpression Class
MissingArgumentExpression Members

 

 


Copyright © GrapeCity, inc. All rights reserved.