Spread Windows Forms 8.0 Product Documentation
CalcMissingArgument Constructor
Example 


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()
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

CalcMissingArgument Class
CalcMissingArgument Members

 

 


Copyright © GrapeCity, inc. All rights reserved.