vert line

Color Constants

Constant Red Green Blue

BLACKCOLOR 0 0 0

BLUECOLOR 0 0 1

CYANCOLOR 01 1

DKGRAYCOLOR 0.3330.333 0.333

GREENCOLOR 0 1 0

LTGRAYCOLOR 0.6660.666 0.666

MAGENTACOLOR 1 0 1

WHITECOLOR 11 1

YELLOWCOLOR 1 1 0

REDCOLOR 10 0

 

Alignment Constants

Constant Effect

RIGHTALIGN Aligns text to right side of cell

LEFTALIGN Aligns text to left side of cell

CENTERALIGN Centers text in cell

SMARTALIGN Aligns strings left, numbers and dates right

FILLALIGN Makes copies of cell contents to fill the cell

TOPALIGN Aligns text to top of cell

BOTTOMALIGN Aligns text to bottom of cell

WRAPALIGN Wraps text to fit inside width of cell

Formatting Constants

Constant Effect

GENERALFMT Displays numbers as typed

FIXEDFMT Displays numbers in fixed decimal format with the default number of decimal places

SCIENTIFICFMT Displays numbers in scientific notation

CURRENCYFMT Displays numbers in the default currency format

COMMAFMT Displays numbers using commas to separate groups of three digits

CHARTFMT Displays numbers as a series of plus signs of length equal to the number

PERCENTFMT Displays numbers in percentage format with the default number of decimal places

TEXTFMT Displays formulas directly, not as values

HIDDENFMT Hides numbers

DMYFMT Treats number as a serial number of a date and displays the date in day-month-year format

DMFMT Displays the date in day-month format

MYFMT Displays the date in month-year format

HMSFMT Number must be fractional; treats number as a time and displays it in twelve-hour hours:minutes-second format

HMFMT Displays the time in twelve-hour hours:minutes format

DATE1FMT Displays date in month/day/year format

DATE2FMT Displays date in month/day format

TIME1FMT Displays time in 24-hour hour:minutes:seconds format

TIME2FMT Displays time in 24-hour hour:minutes format

Graph Type Constants

Constant Meaning

BARGRAPH Bar chart

STACKEDBARGRAPH Stacked bar chart

COLGRAPH Column chart

STACKEDCOLGRAPH Stacked column chart

SCATTERGRAPH Scatter chart

XYGRAPH X-Y chart

AREAGRAPH Area chart

PIEGRAPH Pie chart

HILOGRAPH High/Low chart

HILOCLOSEGRAPH Hi/Low/Close chart

BAR3DGRAPH 3D bar chart

RIBBONGRAPH Ribbon chart

PYRAMIDGRAPH Pyramid chart

SURFACEGRAPH Surface chart

Error Constants

Constant Meaning

ERR General error

ERRORCONST General error

NA Special NA error

NACONST Special NA error

 

Also go to:

Index help

Contents help