PowerTools SPREAD for ASP.NET 8.0J
ClearCustomNames メソッド (ICustomNameSupport2)

すべてのユーザー定義名をモデルから削除します。
構文
'Declaration
 
Sub ClearCustomNames() 
void ClearCustomNames()
FarPoint.Web.Spread.Model.ICustomNameSupport cns; 
cns = (FarPoint.Web.Spread.Model.ICustomNameSupport)FpSpread1.ActiveSheetView.DataModel; 
cns.AddCustomName("ALPHA", new FarPoint.CalcEngine.DoubleExpression(20)); 
FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA * 20");

private void Button1Click(object sender, System.EventArgs e)
{
    FarPoint.Web.Spread.Model.ICustomNameSupport2 cns2; 
    cns2 = (FarPoint.Web.Spread.Model.ICustomNameSupport2)FpSpread1.ActiveSheetView.DataModel; 
    cns2.ClearCustomNames();
    FpSpread1.ActiveSheetView.Recalculate();
}
Dim cns As FarPoint.Web.Spread.Model.ICustomNameSupport
cns = FpSpread1.ActiveSheetView.DataModel
cns.AddCustomName("ALPHA", New FarPoint.CalcEngine.DoubleExpression(20))
FpSpread1.ActiveSheetView.SetFormula(1, 1, "ALPHA * 20")

Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim cns2 As FarPoint.Web.Spread.Model.ICustomNameSupport2
    cns2 = FpSpread1.ActiveSheetView.DataModel
    cns2.ClearCustomNames()
    FpSpread1.ActiveSheetView.Recalculate()
End Sub
参照

ICustomNameSupport2 インタフェース
ICustomNameSupport2 メンバ

 

 


© 2003-2015, GrapeCity inc. All rights reserved.