setFormatName
sets a format for a cell
void setFormatName(number rowId,number columnId,string name, [string page] );
| rowId | number | the row id |
| columnId | 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
Details
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");
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
See also
Back to top
Join Our Forum
We've retired comments here. Visit our forum for faster technical support,
connect with other developers, and share your feedback there.