Visual Basic (Declaration) | |
---|---|
Public Function New() |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As New CalcMissingArgument() |
C# | |
---|---|
public CalcMissingArgument() |
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 Basic | Copy 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() |
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