OpenOffice.org 2.x Podręcznik Użytkownika Pobierz pdf (Strona 268)

100

101

Chapter 4: Spreadsheets in Calc

The name of the sheet automatically receives a leading dollar sign, since the sheet has

absolute addressing.

Examine the name of the other document in this formula and notice that it is written as a

URL. This means that a URL from the Internet can be entered too. For example, supposing

there is an Internet page containing current stock exchange information in spreadsheet cells,

just follow these steps to load this page in Calc:

1. In a Calc document, position the cursor in the cell in which to start inserting the external

data.

2. Select Insert > External Data. The External Data dialogue appears.

3. In the dialogue, enter the URL of the document or Web page. Write the URL in the

following way: (fictional example) http://www.my-broker.com/table.html. Enter a file

name from the local or network file system in the usual way, i.e., via the File > Open

dialogue.

OpenOffice.org loads the Web page or file in the background, that is, without displaying it.

In the large list box of the External Data dialogue are the names of all the sheets or areas

from which to choose.

4. Select one or more sheets or areas, optionally activate the automatic update function to

every n minutes and click OK.

The contents are inserted as a link in the Calc document.

5. Save the spreadsheet. Upon re-opening, Calc updates the linked cells.

6. Under Tools > Options > OpenOffice.org Calc > General, choose to have the update, on

opening, execute always, upon request or never. The update can be started manually in the

dialogue under Edit > Links.

OpenOffice.org User Guide for 2.x 234

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

Komentarze do niniejszej Instrukcji

Brak uwag

OpenOffice.org 2.x Podręcznik Użytkownika Strona 268

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Podręczniki do oprogramowania OpenOffice.org 2.x