getCustomNames Method

Gets information for all custom names.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: Array
value = instance.getCustomNames();

function getCustomNames() : Array;

Return Value

The type GcSpread.Sheets.NameInfo is stored in an Array.

Example

This example gets the custom names.

Javascript

activeSheet.addCustomName("customName1", "=12", 0, 0);
activeSheet.addCustomName("customName2", "Average(20,45)", 0, 0);
activeSheet.setFormula(1, 0, "customName1");
activeSheet.setFormula(1, 1, "customName2");
var names = activeSheet.getCustomNames();
for (var i = 0; i < names.length; i++) {
    alert(names[i].getName());
}

Reference

Sheet type

Send comments on this topic.