Spread Windows Forms 7.0 Product Documentation
ErrorExpression Constructor
See Also  Example Support Options
FarPoint.CalcEngine Assembly > FarPoint.CalcEngine Namespace > ErrorExpression Class : ErrorExpression Constructor


value
Error value

Glossary Item Box

Creates a new expression with an error constant value.

Syntax

Visual Basic (Declaration) 
Public Function New( _
   ByVal value As CalcError _
)
Visual Basic (Usage)Copy Code
Dim value As CalcError
 
Dim instance As New ErrorExpression(value)
C# 
public ErrorExpression( 
   CalcError value
)

Parameters

value
Error value

Exceptions

ExceptionDescription
System.ArgumentNullExceptionvalue is a null reference (Nothing in Visual Basic)

Example

This example returns the error.
C#Copy Code
FarPoint.CalcEngine.ErrorExpression expr = new FarPoint.CalcEngine.ErrorExpression(FarPoint.CalcEngine.CalcError.NotAvailable);
FarPoint.CalcEngine.Expression[] args = {expr};
FarPoint.CalcEngine.FunctionExpression func = new FarPoint.CalcEngine.FunctionExpression(FarPoint.CalcEngine.FunctionInfo.IsErrorFunction,
args);
//Spread for Windows Forms
((FarPoint.Win.Spread.Model.IExpressionSupport)(fpSpread1.ActiveSheet.Models.Data)).SetExpression(0, 0, func);
MessageBox.Show(FarPoint.CalcEngine.CalcError.Name.ToString());
//Spread for Web Forms
((FarPoint.Web.Spread.Model.IExpressionSupport)(FpSpread1.Sheets[0].DataModel)).SetExpression(0, 0, func);
TextBox1.Text = FarPoint.CalcEngine.CalcError.Name.ToString();
Visual BasicCopy Code
Dim expr As New FarPoint.CalcEngine.ErrorExpression(FarPoint.CalcEngine.CalcError.NotAvailable)
Dim args() As FarPoint.CalcEngine.Expression = {expr}
Dim func As New FarPoint.CalcEngine.FunctionExpression(FarPoint.CalcEngine.FunctionInfo.IsErrorFunction, args)
'Spread for Windows Forms
CType(FpSpread1.ActiveSheet.Models.Data, FarPoint.Win.Spread.Model.IExpressionSupport).SetExpression(0, 0, func)
MessageBox.Show(expr.ErrorValue.Name.ToString)
'Spread for Web Forms
CType(FpSpread1.Sheets(0).DataModel, FarPoint.Web.Spread.Model.IExpressionSupport).SetExpression(0, 0, func)
TextBox1.Text = expr.ErrorValue.Name.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

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