SpreadsheetFormatcell()

Sets the formatting properties for the given cell by row:column

Usage

BOOLEAN = SpreadsheetFormatcell(
				
					
					
						p1, 
					
				
					
					
						p2, 
					
				
					
					
						p3, 
					
				
					
					
						p4
					
				
				)

Argument	Summary
p1	spreadsheet object
p2	format Structure. Keys: alignment=[vertical_top \| general \| vertical_center \| vertical_justify \| left \| justify \| center \| right \| fill \| vertical_bottom \| center_selection ]; bottomborder,topborder,leftborder,rightborder=[dashed \| double \| medium_dashed \| dash_dot \| dash_dot_dot \| none \| medium \| thick \| thin \| hair \| medium_dash_dot \| slanted_dash_dot \| dotted \| medium_dash_dot_dot ]; bottombordercolor,topbordercolor,leftbordercolor,rightbordercolor,fgcolor,bgcolor,color=[pink \| dark_red \| grey_25_percent \| grey_40_percent \| yellow \| olive_green \| blue_grey \| turquoise \| grey_80_percent \| light_turquoise \| dark_blue \| red \| gold \| aqua \| light_cornflower_blue \| white \| coral \| light_orange \| sea_green \| lavender \| dark_teal \| plum \| green \| dark_green \| lime \| black \| violet \| teal \| light_blue \| pale_blue \| brown \| royal_blue \| orange \| dark_yellow \| light_yellow \| grey_50_percent \| lemon_chiffon \| blue \| bright_green \| light_green \| rose \| cornflower_blue \| indigo \| maroon \| sky_blue \| orchid ]; fillpattern=[diamonds \| nofill \| big_spots \| thick_backward_diag \| squares \| sparse_dots \| thin_forward_diag \| thick_vert_bands \| thin_vert_bands \| thin_horz_bands \| solid_foreground \| least_dots \| thin_backward_diag \| less_dots \| alt_bars \| thick_horz_bands \| thick_forward_diag \| fine_dots ]; textwrap=[true\|false]; hidden=[true\|false]; locked=[true\|false]; indent=[value]; rotation=[value]; dateformat=[format]; strikeout=[true\|false]; bold=[true\|false]; underline=[value]; fontsize=[value]; font=[face];
p3	rowNo
p4	columnNo

IsSpreadsheetobject SpreadsheetAddcolumn SpreadsheetAddfreezepane SpreadsheetAddimage SpreadsheetAddinfo SpreadsheetAddrow SpreadsheetAddrows SpreadsheetAddsplitpane SpreadsheetColumnfittosize SpreadsheetCreatesheet SpreadsheetDeletecolumn SpreadsheetDeletecolumns SpreadsheetDeleterow SpreadsheetDeleterows SpreadsheetDeletesheet SpreadsheetFindcell SpreadsheetFormatcell SpreadsheetFormatcolumn SpreadsheetFormatcolumns SpreadsheetFormatrow SpreadsheetFormatrows SpreadsheetGetcellcomment SpreadsheetGetcellformula SpreadsheetGetcellvalue SpreadsheetInfo SpreadsheetMergecells SpreadsheetNew SpreadsheetQueryread SpreadsheetQuerywrite SpreadsheetRead SpreadsheetReadbinary SpreadsheetRemovecolumn SpreadsheetSetactivesheet SpreadsheetSetactivesheetnumber SpreadsheetSetcellcomment SpreadsheetSetcellformula SpreadsheetSetcellvalue SpreadsheetSetcolumnwidth SpreadsheetSetfooter SpreadsheetSetheader SpreadsheetSetrowwidth SpreadsheetShiftcolumns SpreadsheetShiftrows SpreadsheetWrite

SpreadsheetFormatcell()

Usage

See Also