beautypg.com

HP Prime Graphing Calculator User Manual

Page 211

background image

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