setFormatName

sets a format for a cell

row	number	the row id
column	number	the column id
name	string	the name of the format
page	string	optional, the name of the sheet

Example

var name = $$("ssheet").addFormat("[green]0.0");
$$("ssheet").setFormatName(1, 1, name);

Related samples

Default number formats have predefined names:

• price - for the Currency format;
• int - for the Number format;
• percent - for the Percent format;
• date - for the Date format;
• string - for the Text format.

$$("ssheet").setFormatName(3, 1, "price");
$$("ssheet").setFormatName(5, 1, "date");

Back to top