OpenOffice.org 2.x Betriebsanweisung PDF herunterladen (Seite 257)

Chapter 4: Spreadsheets in Calc

Formatting a Spreadsheet

A spreadsheet is hardly ever used without formatting. Cell contents, such as texts and

numbers, are given certain formats, and the cells themselves are formatted with different

colours, borders and other attributes.

Either create the numbers format or use one of the many predefined formats. For cells, a wide

selection of cell Styles is provided and personal cell Styles can be defined in the same way as

one does text Styles.

Certain values in spreadsheets are often given particular emphasis, e.g. in a table of turnovers

to show all the values above the average in green and all those below the average in red. This

is possible using the Conditional Formatting for spreadsheet documents (covered in a later

chapter.)

Formating Numbers

Enter a number into the sheet, for example, 1234.5678. This number will be displayed in

the default number format, with two decimal places. One will see 12 34. 57 when the the

entry is confirmed. Only the display in the document will be rounded off; internally, the

number retains all four decimal places after the decimal point.

1. Set the cursor at the number and choose Format > Cells to start the Cell Attributes

dialogue.

2. On the Numbers tab there is a selection of predefined number formats. A preview box, n

the bottom right of the dialogue, shows how the current number will appear with a

particular format.

3. This dialogue also allows defining other attributes (in addition to number formats) which

apply to the selected cells or cell contents. For example, font, size, and colour can be

defined on the Font tab page.

Modifying the number of the decimal places displayed in a cell is sometimes

required. The easiest method is to use the Number Format: Add Decimal Place or

Number Format: Delete Decimal Place icons on the object bar.

Dates

1. Likewise, from the list of options, the date and time can be formatted as desired.

The year in the date details is often stated as two digits. Internally the year is managed by

OpenOffice.org as four digits, so that in the calculation of difference from 1/1/99 to

1/1/ 01 the result will correctly be two years.

• Tools > Options > OpenOffice.org > General defines up to which year a two-digit year

“xx” should be displayed as “20xx”.

This means that if a date of 1/1/30 or higher is entered, it will be treated internally as

1/1/1930 or higher. All lower years apply to the next century. So, for example, 1/1/20 is

converted into 1/1/2020.

OpenOffice.org User Guide for 2.x 223

1 2 ... 252 253 254 255 256 257 258 259 260 261 262 ... 507 508

Keine Kommentare

OpenOffice.org 2.x Betriebsanweisung Seite 257