Spread Windows Forms 6.0 Product Documentation
Value Property
See Also  Example Support Options
FarPoint.CalcEngine Assembly > FarPoint.CalcEngine Namespace > MissingArgumentExpression Class : Value Property


Glossary Item Box

Gets the missing argument value as an object.

Syntax

Visual Basic (Declaration) 
Public ReadOnly Property Value As Object
Visual Basic (Usage)Copy Code
Dim instance As MissingArgumentExpression
Dim value As Object
 
value = instance.Value
C# 
public object Value {get;}

Property Value

Object containing the value

Example

This example returns a missing argument.
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 = (FarPoint.CalcEngine.CalcMissingArgument)ma.Value;
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 = (FarPoint.CalcEngine.CalcMissingArgument)ma.Value;
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.Value
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.Value
TextBox1.Text = arg14.ToString()

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

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