Please enable JavaScript to view this site.

A-Shell Consolidated Reference

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.
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

1Because 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.
2Counter-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.
3All 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.