HP Prime Graphing NW280AAABA manual Format Parameters

Models: Prime Graphing NW280AAABA

1 616
Download 616 pages 24.49 Kb
Page 213
Image 213

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.

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-

1 to 11, or

 

mal places

unspecified = –1

5

font

0 to 6, unspecified

 

 

= –1 (with 0 = 10 pt

 

 

and 6 = 22pt).

6

background

cell fill color, or

 

color

32786 if unspecified

7foreground color cell contents color, or 32786 if unspecified

8horizontal align- Left = 0, Center = 1,

 

ment

Right = 2,

 

 

unspecified = –1

9

vertical align-

Top = 0, Center = 1,

 

ment

Bottom = 2,

 

 

unspecified = –1

10

show strings in

Yes = 0, No = 1,

 

quotes

unspecified = –1

11

textbook mode

Yes = 0, No = 1,

 

(as opposed to

unspecified = –1

 

algebraic mode)

 

 

 

 

As well as retrieving format attributes, you can set a format attribute (or cell content) by specifying it in a formula in the

Spreadsheet

209

Page 213
Image 213
HP Prime Graphing NW280AAABA manual Format Parameters