Spread for ASP.NET 8.0 Product Documentation
Null Property
Example 


Occurs when you specify an intersection of two intersections that do not intersect.
Syntax
'Declaration
 
Public Shared ReadOnly Property Null As CalcError
'Usage
 
Dim value As CalcError
 
value = CalcError.Null
public static CalcError Null {get;}

Property Value

CalcError object containing this type of error
Example
This example returns the error value.
//Spread for Windows Forms
FarPoint.CalcEngine.ErrorExpression err = new FarPoint.CalcEngine.ErrorExpression(FarPoint.CalcEngine.CalcError.Null);
fpSpread1.ActiveSheet.AddCustomName("Alpha", err);
fpSpread1.ActiveSheet.SetFormula(0, 0, "Alpha * 10");
FarPoint.CalcEngine.Expression expr = fpSpread1.ActiveSheet.GetCustomName("Alpha"); 
if (expr is FarPoint.CalcEngine.ErrorExpression) 
{ 
FarPoint.CalcEngine.ErrorExpression ex = ((FarPoint.CalcEngine.ErrorExpression)(expr)); 
MessageBox.Show("The error is " + ex.ErrorValue.ToString()); 
}
//Spread for Web Forms
FarPoint.CalcEngine.ErrorExpression err = new FarPoint.CalcEngine.ErrorExpression(FarPoint.CalcEngine.CalcError.Null);
FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Web.Spread.Model.DefaultSheetDataModel();  
dataModel = (FarPoint.Web.Spread.Model.DefaultSheetDataModel)FpSpread1.ActiveSheetView.DataModel;
dataModel.AddCustomName("Alpha", err);
FpSpread1.Sheets[0].SetFormula(0, 0, "Alpha * 10");
FarPoint.CalcEngine.Expression expr = dataModel.GetCustomName("Alpha"); 
if (expr is FarPoint.CalcEngine.ErrorExpression) 
{ 
FarPoint.CalcEngine.ErrorExpression ex = ((FarPoint.CalcEngine.ErrorExpression)(expr)); 
TextBox1.Text = "The error is " + ex.ErrorValue.ToString(); 
}
'Spread for Windows Forms
Dim err As New FarPoint.CalcEngine.ErrorExpression(FarPoint.CalcEngine.CalcError.Null)
FpSpread1.ActiveSheet.AddCustomName("Alpha", err)
FpSpread1.ActiveSheet.SetFormula(0, 0, "Alpha")
Dim expr As FarPoint.CalcEngine.Expression = FpSpread1.ActiveSheet.GetCustomName("Alpha")
If TypeOf expr Is FarPoint.CalcEngine.ErrorExpression Then
Dim ex As FarPoint.CalcEngine.ErrorExpression = CType(expr, FarPoint.CalcEngine.ErrorExpression)
MessageBox.Show("The error is " & ex.ErrorValue.ToString())
End If
'Spread for Web Forms
Dim err As New FarPoint.CalcEngine.ErrorExpression(FarPoint.CalcEngine.CalcError.Null)
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
dataModel = FpSpread1.ActiveSheetView.DataModel
dataModel.AddCustomName("Alpha", err)
FpSpread1.Sheets(0).SetFormula(0, 0, "Alpha")
Dim expr As FarPoint.CalcEngine.Expression = dataModel.GetCustomName("Alpha")
If TypeOf expr Is FarPoint.CalcEngine.ErrorExpression Then
Dim ex As FarPoint.CalcEngine.ErrorExpression = CType(expr, FarPoint.CalcEngine.ErrorExpression)
TextBox1.Text = "The error is " & ex.ErrorValue.ToString()
End If
Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

CalcError Class
CalcError Members

 

 


Copyright © GrapeCity, inc. All rights reserved.