GC.Spread.Sheets 名前空間 > Worksheet タイプ : addCustomName メソッド |
Javascript (Usage) | |
---|---|
var instance = new GC.Spread.Sheets.Worksheet(name); var value; // Type: any value = instance.addCustomName(name, formula, baseRow, baseCol); |
Javascript (Specification) | |
---|---|
function addCustomName( name : string, formula : string, baseRow : number, baseCol : number ) : any; |
sheet.setValue(0, 0, 1); sheet.setValue(0, 1, 2); sheet.setValue(0, 2, 3); sheet.addCustomName("customName1","=12", 0, 0); sheet.addCustomName("customName2","Average(20,45)", 0, 0); sheet.addCustomName("customName3", "=$A$1:$C$1", 0, 0); sheet.setFormula(1, 0, "customName1"); sheet.setFormula(1, 1, "customName2"); sheet.setFormula(1, 2, "sum(customName3)");