SpreadsheetFormatcolumn()

Sets the default formatting properties for the given column(s). It will not reformat any existing columns

Usage

BOOLEAN = SpreadsheetFormatcolumn(
				
					
					
						p1, 
					
				
					
					
						p2, 
					
				
					
					
						p3
					
				
				)

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	columnNo - expressed as single or a range (1,2,3,5-8)

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

SpreadsheetFormatcolumn()

Usage

See Also