HP Prime Graphing Calculator User Manual
Page 211
![background image](/manuals/397026/211/background.png)
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)
1
formula
formula
2
name
name (or empty)
3
number format
Standard = 0
Fixed = 1
Scientific = 2
Engineering = 3
4
number of deci-
mal places
1 to 11, or unspeci-
fied = –1
5
font
0 to 6, unspecified
= –1 (with 0 = 10 pt
and 6 = 22pt).
6
background
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
9
vertical 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