getFormat

returns an object containing the format name and the format specified for the given cell

object getFormat(number row,number column, [string page] );
rownumberthe row id
columnnumberthe column id
pagestringoptional, the name of the sheet
objectan object with the format name and the format itself (a string of formatting conditions, separated by semicolons)

Example

const name = $$("ssheet").getFormat(2, 1, "Sheet1");
// -> {"name":"price","format":"[>=0][$$]#,0.00;[<0]-[$$]#,0.00"}

Related samples

Details

Note that the method returns null if a cell has no assigned format.

See also
Back to top