
●
Color—Color for the content (text, number, etc.) in the selected cells; the gray-dotted option represents
Auto.
●
Fill—Background color that lls the selected cells; the gray-dotted option represents Auto.
●
Align —Auto, Left, Center, or Right horizontal alignment.
●
Align —Auto, Top, Center, or Bottom vertical alignment.
●
Column —Displays an input form for you to specify the required width of the selected columns;
available only if you have selected the entire spreadsheet or one or more entire columns.
You can also change the width of a selected column with an open or closed horizontal pinch gesture.
●
Row —Displays an input form for you to specify the required height of the selected rows; available only
if you have selected the entire spreadsheet or one or more entire rows.
You can also change the height of a selected row with an open or closed vertical pinch gesture.
●
show " "—Show quote marks around strings in the body of the spreadsheet. Options are Auto, Yes, or
No.
●
Textbook—Display formulas in textbook format. Options are Auto, Yes, or No.
●
Caching—Turn this option on to speed up calculations in spreadsheets with many formulas; available
only if you have selected the entire spreadsheet.
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
formula 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
Scientic—2
Engineering—3
4 number of decimal places 1 to 11, or unspecied (–1)
5 font 0 to 6, or unspecied (-1)
0 equals 10 point and 6 equals 22 point
6 background color Cell ll color, or 32768 if unspecied
7 foreground color Cell contents color, or 32768 if unspecied
8 horizontal alignment Left—0
Center—1
Right—2
Formatting options 225
Komentarze do niniejszej Instrukcji