SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / clearCustomNames Method
In This Topic
    clearCustomNames Method
    In This Topic
    Clears custom names.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: any
    value = instance.clearCustomNames();
    function clearCustomNames() : any;
    Example
    This example creates custom names and then clears them.
    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();
    See Also

    Reference

    Worksheet type