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

100

101

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).

Figure 250: Selecting the savings account reference cell

4) Switch back to the original spreadsheet.

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

Your spreadsheet should now resemble Figure 251.

Figure 251: Linked files

You will get a good feel for the format of the reference if you look

closely at the input line. Based on this line you can create the

reference using the keyboard.

Creating the reference with the keyboard

Typing the reference is simple once you know the format the reference

takes. The reference has three parts to it:

• Path and file name

• Sheet name

• Cell

Looking at Figure 251 you can see the the general format for the

reference is

=’file:///Path & File Name’#$SheetName.CellName

302 OpenOffice.org 3.x Calc Guide

1 2 ... 297 298 299 300 301 302 303 304 305 306 307 ... 496 497

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

Žádné komentáře

OpenOffice.org OpenOffice - 3.2 Základní průvodce Strana 302

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

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