OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 266)

100

101

Referencing other documents: links to sheets in

other spreadsheets

John decides to keep his family account information in a different spreadsheet file

from his own summary. Fortunately Calc can link different files together. The process

is the same as described for different sheets in a single spreadsheet, but we add one

more step to indicate which file the sheet is in. For this example we use two different

spreadsheet files.

Creating the reference using the mouse

To create the reference with the mouse, both spreadsheets need to be open. Select

the cell in which the formula is going to be entered.

1) Click the = icon next to the input line.

2) Switch to the other spreadsheet (the process to do this will vary depending on

which operating system you are using).

3) Select the sheet (Savings Account) and then the reference cell (F3). See Figure

267.

4) Switch back to the original spreadsheet.

5) Click on the green check mark on the input line.

Your spreadsheet should now resemble Figure 268.

Figure 267: Selecting the savings account reference cell

Figure 268: Linked files

To get a good idea of the format of the reference, look closely at the input line. Based

on this line you can create the reference using the keyboard.

266 OpenOffice.org 3.3 Calc Guide

1 2 ... 261 262 263 264 265 266 267 268 269 270 271 ... 433 434

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 266

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3