MESCIUS SPREAD for Windows Forms 17.0J
ResetFormula メソッド

空にするセルの数式をリセットします。
構文
'Declaration
 
Public Sub ResetFormula() 
public void ResetFormula()
次のサンプルコードは、ResetFormulaメソッドを使用します。
FarPoint.Win.Spread.Cell acell, mycell, urcell;
acell = fpSpread1.ActiveSheet.Cells[0, 0];
mycell = fpSpread1.ActiveSheet.Cells[2, 2];
urcell = fpSpread1.ActiveSheet.Cells[2, 3];
mycell.Value = 10;
urcell.Value = 10;
acell.Formula = "SUM(" + mycell.ToString() + "," + urcell.ToString() + ")";
acell.ResetFormula();
Dim acell, mycell, urcell As FarPoint.Win.Spread.Cell
acell = FpSpread1.ActiveSheet.Cells(0, 0)
mycell = FpSpread1.ActiveSheet.Cells(2, 2)
urcell = FpSpread1.ActiveSheet.Cells(2, 3)
mycell.Value = 10
urcell.Value = 10
acell.Formula = "SUM(" + mycell.ToString() + "," + urcell.ToString() + ")"
acell.ResetFormula()
参照

Cell クラス
Cell メンバ

 

 


© MESCIUS inc. All rights reserved.