SpreadsheetGetCellFormat

Gets the formatting information of a cell.

Method Signature

SpreadsheetGetCellFormat(spreadsheetObj=[any], row=[any], column=[any])

Arguments

Argument	Type	Required	Description	Default
spreadsheetObj	ANY	true	The spreadsheet object.
row	NUMERIC	true	The row number (1-based).
column	NUMERIC	true	The column number (1-based).

Examples

Get cell formatting:

// Retrieve cell format
var spreadsheet = SpreadsheetNew();
SpreadsheetAddRow( spreadsheet, [ "Styled" ] );

var format = { bold = true, color = "0000FF" };
SpreadsheetFormatCell( spreadsheet, 1, 1, format );

var cellFormat = SpreadsheetGetCellFormat( spreadsheet, 1, 1 );
println( cellFormat );

Related

• SpreadsheetFormatCell() - Format cell

• SpreadsheetFormatCellRange() - Format range

• SpreadsheetGetCellValue() - Get cell value