-
-
Notifications
You must be signed in to change notification settings - Fork 36
formatCell
Julian Halliwell edited this page Mar 3, 2023
·
12 revisions
Formats/styles the contents of a cell.
formatCell( workbook, [format,] row, column[, overwriteCurrentStyle [, cellStyle ] ] )
-
workbook
spreadsheet object -
format
struct OR cellStyle object: See Formatting options for details. -
row
numeric -
column
numeric
-
overwriteCurrentStyle
boolean default=true: for performance/efficiency reasons all of the existing styles will be completely overwritten when using this method. To preserve existing formatting properties other than the ones being changed, set this flag tofalse
, but please note that this should only be used when formatting a limited number of cells (you may run into errors if applied to too many cells).
Chainable? Yes.
data = QueryNew( "First,Last","VarChar,VarChar",[ [ "Susi","Sorglos" ],[ "Frumpo","McNugget" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.formatCell( workbook,{bold="true"},1,1 );