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) |
x |
x |
x |
|
|
alignv (1) |
x |
x |
x |
|
|
bold |
Boolean |
x |
x |
x |
x |
bordercolor |
x |
x |
x |
|
|
borderstyle (1) |
x |
x |
x |
|
|
fillpattern (1) |
x |
x |
x |
|
|
fontid |
Alphanumeric name you assign* |
x |
x |
x |
x |
fontcolor |
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 |
x |
x |
x |
|
|
numfmtid (1) |
x |
x |
x |
|
|
patternbgc (2) |
x |
x |
x |
|
|
patternfgc (2) |
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.
