setFormatName

sets a format for a cell

void setFormatName(number rowId,number columnId,string name, [string page] );

rowId

numberthe row id columnId

numberthe column id name

stringthe name of the format pagestringoptional, the name of the sheet

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

Details

Default number formats have predefined names:

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

When a new column or row is added, new cells inherit the existing formats in the following way:

on adding a new row/rows, new cells inherit the format from the cells of the above row
on adding a new column/columns, new cells inherit the format from the cells of the column to the left