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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8