addCustomName Method

Adds a custom name.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Workbook(host);
var value; // Type: any
value = instance.addCustomName(name, formula, baseRow, baseCol);

function addCustomName( 
   name : string,
   formula : string,
   baseRow : number,
   baseCol : number
) : any;

Parameters

name: The custom name.
formula: The formula.
baseRow: The row index.
baseCol: The column index.

Example

This example uses the addCustomName method.

Javascript

activeSheet.setValue(0, 0, 1);
activeSheet.setValue(0, 1, 2);
activeSheet.setValue(0, 2, 3);
spread.addCustomName("customName1","=12", 0, 0);
activeSheet.setFormula(1, 0, "customName1");
//spread.clearCustomNames();

Reference

Workbook type
Creating Custom Names

Send comments on this topic.