clearCustomNames メソッド

カスタム名をクリアします。

シンタックス

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: any
value = instance.clearCustomNames();

function clearCustomNames() : any;

使用例

Javascript

// 次のサンプルコードは、カスタム名を作成してからそれらをクリアします。 activeSheet.setValue(0, 0, 1); activeSheet.setValue(0, 1, 2); activeSheet.setValue(0, 2, 3); activeSheet.addCustomName("customName1","=12", 0, 0); activeSheet.addCustomName("customName2","Average(20,45)", 0, 0); activeSheet.addCustomName("customName3", "=$A$1:$C$1", 0, 0); activeSheet.setFormula(1, 0, "customName1"); activeSheet.setFormula(1, 1, "customName2"); activeSheet.setFormula(1, 2, "sum(customName3)"); activeSheet.clearCustomNames();

This example creates custom names and then clears them.

Javascript

activeSheet.setValue(0, 0, 1);
activeSheet.setValue(0, 1, 2);
activeSheet.setValue(0, 2, 3);
activeSheet.addCustomName("customName1","=12", 0, 0);
activeSheet.addCustomName("customName2","Average(20,45)", 0, 0);
activeSheet.addCustomName("customName3", "=$A$1:$C$1", 0, 0);
activeSheet.setFormula(1, 0, "customName1");
activeSheet.setFormula(1, 1, "customName2");
activeSheet.setFormula(1, 2, "sum(customName3)");
activeSheet.clearCustomNames();

参照

Worksheet タイプ