Spreadsheet 207
Format
Parameters
Each format attribute is represented by a parameter that can be
referenced in a formula. For example, =D1(1) returns the
formula in cell D1 (or nothing if D1 has no formula). The
attributes that can be retrieved in a formulas by referencing its
associated parameter are listed below.
As well as retrieving format attributes, you can set a format
attribute (or cell content) by specifying it in a formula in the
Parameter Attribute Result
0 content contents (or empty)
1formula formula
2 name name (or empty)
3 number format Standard = 0
Fixed = 1
Scientific = 2
Engineering = 3
4number of deci-
mal places
1 to 11, or unspeci-
fied = –1
5font 0 to 6, unspecified
= –1 (with 0 = 10 pt
and 6 = 22pt).
6background
color
cell fill color, or
32786 if unspecified
7 foreground color cell contents color,
or 32786 if unspeci-
fied
8 horizontal align-
ment
Left = 0, Center = 1,
Right = 2, unspeci-
fied = –1
9vertical align-
ment
Top = 0, Center = 1,
Bottom = 2, unspeci-
fied = –1
10 show strings in
quotes
Yes = 0, No = 1,
unspecified = –1
11 textbook mode
(as opposed to
algebraic mode)
Yes = 0, No = 1,
unspecified = –1
To Next Page
