MESCIUS SPREAD for Windows Forms 17.0J
Number プロパティ (CalcError)

数式の数字に問題があったときに発生します。
構文
'Declaration
 
Public Shared ReadOnly Property Number As CalcError
public static CalcError Number {get;}

プロパティ値

この種類のエラーを含むCalcErrorオブジェクト
次のサンプルコードは、エラー値を返します。
//Spread for Windows Forms
FarPoint.CalcEngine.ErrorExpression err = new FarPoint.CalcEngine.ErrorExpression(FarPoint.CalcEngine.CalcError.Number);
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.Number);
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.Number)
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.Number)
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel
dataModel = FpSpread1.ActiveSheetView.DataModel
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
参照

CalcError クラス
CalcError メンバ

 

 


© MESCIUS inc. All rights reserved.