setFormat

sets a custom format for a cell and returns the name of the format

string setFormat(number rowId,number columnId,string format, [string page] );
rowIdnumberthe row id
columnIdnumberthe column id
formatstringconditions for formatting the cell content, separated by semi-colons
pagestringoptional, the name of the sheet
stringthe name of the format

Example

$$("ssheet").setFormat(2, 2, "[>1000]> 0.0;[>100]Check 0,000.0#;[=0]Nope", "Sheet1");

Related samples

Details

Check the format details.

See also
Back to top
If you have not checked yet, be sure to visit site of our main product Webix web development library and page of javascript spreadshee product.