getFormat

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

object getFormat(number row,number column, [string page] );
row
numberthe row id column
numberthe column id page
stringoptional, 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
  • API
  • Articles
  • 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.