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

Chapter 4: Spreadsheets in Calc

Inserting a note

To keep a note, perhaps reminding one to sell a certain share later on, select the relevant cell

and choose Insert > Note. A shadowed area in the document appears in which to enter text.

To make this note visible all the time, click in the relevant cell (cells with notes have a small

red dot in the corner, provided "Note Indicator” in Tools > Options > OpenOffice.org Calc

> View is marked), open the context menu and choose Show Note. Otherwise, one only sees

the note when the mouse pointer is moved on to the cell.

Inserting a sheet into another document

Select the cell range and copy it to the clipboard (Copy icon on the Standard toolbar). Open

the document into which to insert the sheet (generally a text document) and insert the sheet

(Insert command).

Displaying formulae

To display the references in the spreadsheets, choose Tools > Options > OpenOffice.org

Calc > View and mark formulae. The best way to examine an individual formula is to click

the cell containing the formula and then click the Wizard: Functions icon on the formula

bar.

Using print ranges

Print ranges have been used in the sample document to print specifically targeted cells.

Freezing Columns

Select the column to the right of the column to be frozen, say a list of names, by clicking on

the column header, and click Freeze in the Window menu. This makes is possible to scroll

horizontally, while the area to the left of the freeze line remains fixed. This fixes the display

so that the column containing the names is always in view. This function is especially useful

for large sheets.

Splitting a Calc Window

Sometimes a user may need to work with a spreadsheet in which the active data is in different

rows. Scrolling up and down can be inconvenient. In this case splitting the display can be an

advantage. Select the cell tat which to split the display,and click Split in the Window menu.

This make is possible to scroll vertically in each of the split sections. This function can be

especially useful for large sheets.

Conditional Formatting

With this function, information can be displayed simply by entering a letter. For example, if

this is an employee list, use this feature to instantly find out if a particular employee is

present, sick, or on vacation.

To do so, use the following steps:

1. Open the Styles and Formatting window (click the icon in the Standard toolbar)

2. create three Cell Styles.

3. For the Cell Styles, choose names that correspond to the information to be represented. In

the case of the employee list , choose: Sick, Vacation and Present.

OpenOffice.org User Guide for 2.x 273

1 2 ... 302 303 304 305 306 307 308 309 310 311 312 ... 507 508

Keine Kommentare

OpenOffice.org 2.x Betriebsanweisung Seite 307