Common //XL Parameters

The following table lists the parameters that can be used with several of the //XL directives. Note that

•   You must list only the parameters you want to use. Simply omit those you don't wish to set.

•   See Notes on Syntax.

•   Some of the links below connect to external webpages that contain definitions for multiple parameters. Scroll down the page as needed.

•   Numbers in parentheses (3) refer to the notes which immediately follow the table

 

 

Available For Use In...

Name

Value

Set

Row

Set

Col

Define

Format

Define

Font

alignh (1)

ALIGNH_xxx

x

x

x

 

alignv (1)

ALIGNV_xxx

x

x

x

 

bold

Boolean

x

x

x

x

bordercolor

COLOR_xxx

x

x

x

 

borderstyle (1)

BORDERSTYLE_xxx

x

x

x

 

fillpattern (1)

FILLPATTERN_xxx

x

x

x

 

fontid

Alphanumeric name you assign*

x

x

x

x

fontcolor

COLOR_xxx

x

x

x

x

fontname

Font name; eg "Arial", "Courier New"

x

x

x

x

fontsize

Integer number of points

x

x

x

x

formatid

Alphanumeric name you assign*

x

x

x

 

hidden

Boolean

x

x

x

 

indent

Integer 0 - 15

x

x

x

 

italic

Boolean (3)

x

x

x

x

locked

Boolean (3)

x

x

x

 

mask

mask

x

x

x

 

numfmtid (1)

NUMFMT_xxx

x

x

x

 

patternbgc (2)

COLOR_xxx

x

x

x

 

patternfgc (2)

COLOR_xxx

x

x

x

 

rotation

degrees (4)

x

x

x

 

shrinkfit

Boolean (3)

x

x

x

 

strikeout

Boolean (3)

x

x

x

x

underline

Boolean (3)

x

x

x

x

wrap

Boolean (3)

x

x

x

 

* so you can refer to it later

Notes

1   Because the values for these parameters are uniquely associated with a specific parameter ("ALIGNH_LEFT" or "BORDERSTYLE_THICK" or "FILLPATTERN_GRAY25"), it is not necessary to name the parameter. In other words, ALIGNH_LEFT by itself on the syntax line is equivalent to ALIGNH=ALIGNH_LEFT.

2   Counter-intuitive setting: To set the "normal" background color of a cell, set fillpattern to FILLPATTERN_SOLID and patternfgc to the color. The patternbgc parameter applies only to complex (non-solid) fill patterns.

3   All parameters Boolean values (a) default to no and therefore (b) do not need to be mentioned except to turn on, and (c) do not require a value (Y or 1) to turn on; just naming the parameter on the syntax line ("Italic") turns it on.

4. Rotation values 0-90 specify counterclockwise rotation in degrees.  Values 91-180 specify 1-90 degree rotation clockwise. 255 indicates vertical.