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

Chapter 4: Spreadsheets in Calc

While dragging the mouse to highlight the desired range, the Wizard dialogue will be

automatically minimized so that only the active input field is visible. The field indicates

the area being selected with the mouse. The dialogue can be reduced or enlarged manually

by clicking the Shrink / Maximize button to the right of the input field.

5. Finally, click OK to close the Wizard.

The formula is calculated according to the given arguments, and the final result appears in

cell B8.

References to Other Sheets

In any sheet cell, users can show a reference to a cell in another sheet.

1. Open a new, empty spreadsheet.

2. For example, enter in cell A1 of Sheet1 the following formula and complete the input

with the Enter key:

=Sheet2.A1

3. Now click the sheet tab labelled Sheet2 on the bottom window border to go to Sheet2

of the current document. Set the cursor in cell A1 there and enter text or a number.

4. Upon switching back to Sheet1, see the same content in cell A1 as was entered on

Sheet2. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also

change.

In a corresponding way a reference can also be made to a cell of another document. Open

another spreadsheet in addition to the new spreadsheet, which is already saved as a file (this

does not work unless a document has previously been saved).

1. If the samples from http:// www.pathtech.org / OpenOffice.org/templates / are installed,

choose File > Open and open the Movie1 document from the spreadsheet samples.

2. Change back to the new, still almost empty spreadsheet. Set the cursor in a free cell and

enter an equals sign to begin a formula.

3. Now switch to the document that has Movie1 loaded. Click cell C3.

4. Switch back to the new spreadsheet. In the calculation row notice that Calc has added the

reference to the formula. By way of example, the following will now be located there:

In *NIX:

='file:////OpenOffice.org/share/samples/english/spreadsheets/Movie 1.sdc'#$movievisits.C3

In Windows®:

='file:///C:/

OpenOffice.org/share/samples/english/spreadsheets/Movie 1.sdc'#$movievisits.C3

5. Confirm the formula by clicking the green check mark.

The reference to a cell of another document thus contains the name of the other document in

single inverted commas, then a hash #, then the name of the sheet in the other document

followed by a point and the name of the cell there C3.

OpenOffice.org User Guide for 2.x 233

1 2 ... 262 263 264 265 266 267 268 269 270 271 272 ... 507 508

Keine Kommentare

OpenOffice.org 2.x Betriebsanweisung Seite 267