|
![]() |
![]() |
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 |
||
|
||