Syntax
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim values() As Object Dim instance As New ArrayExpression(values) | |
Parameters
- values
- Array of constant values
Exceptions
| Exception | Description |
|---|---|
| System.ArgumentNullException | values is a null reference (Nothing in Visual Basic) |
Example
This example creates an expression with an array of constant values.
| C# | Copy Code |
|---|---|
object[,] knownY = {{2.0, 3.0, 9.0, 1.0, 8.0, 7.0, 5.0}}; object[,] knownX = {{6.0, 5.0, 11.0, 7.0, 5.0, 4.0, 4.0}}; FarPoint.CalcEngine.Expression arg1 = new FarPoint.CalcEngine.ArrayExpression(knownY); FarPoint.CalcEngine.Expression arg2 = new FarPoint.CalcEngine.ArrayExpression(knownX); FarPoint.CalcEngine.Expression[] args = new FarPoint.CalcEngine.Expression[] {arg1, arg2}; FarPoint.CalcEngine.Expression func = new FarPoint.CalcEngine.FunctionExpression(FarPoint.CalcEngine.FunctionInfo.SlopeFunction,args); //Spread for Windows Forms ((FarPoint.Win.Spread.Model.IExpressionSupport)fpSpread1.ActiveSheet.Models.Data).SetExpression(0, 0, func); //Spread for Web Forms ((FarPoint.Web.Spread.Model.IExpressionSupport)FpSpread1.Sheets[0].DataModel).SetExpression(0, 0, func); | |
| Visual Basic | Copy Code |
|---|---|
Dim x As Object(,) = {{2.0, 3.0, 9.0, 1.0, 8.0, 7.0, 5.0}} Dim y As Object(,) = {{6.0, 5.0, 11.0, 7.0, 5.0, 4.0, 4.0}} Dim arg1 As New FarPoint.CalcEngine.ArrayExpression(x) Dim arg2 As New FarPoint.CalcEngine.ArrayExpression(y) Dim args() As FarPoint.CalcEngine.Expression = {arg1, arg2} Dim func As New FarPoint.CalcEngine.FunctionExpression(FarPoint.CalcEngine.FunctionInfo.SlopeFunction, args) 'Spread for Windows Forms CType(FpSpread1.ActiveSheet.Models.Data, FarPoint.Win.Spread.Model.IExpressionSupport).SetExpression(0, 0, func) 'Spread for Web Forms CType(FpSpread1.Sheets(0).DataModel, FarPoint.Web.Spread.Model.IExpressionSupport).SetExpression(0, 0, func) | |
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