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

Editing hyperlinks

To edit an existing link, place the cursor anywhere in the link and click the Hyperlink

icon on the Standard toolbar or select Edit > Hyperlink from the menu bar. The

Hyperlink dialog (Figure 269) opens. If the Hyperlink is in button form, the

spreadsheet must have Design Mode on in order to edit the Hyperlink. Make your

changes and click Apply. If you need to edit several hyperlinks, you can leave the

Hyperlink dialog open until you have edited all of them. Be sure to click Apply after

each one. When you are finished, click Close.

Removing hyperlinks

You can remove the clickable link from hyperlink text—leaving just the text—by right-

clicking on the link and selecting Default Formatting. This option is also available

from the Format menu. You may then need to re-apply some formatting in order for it

to match the rest of your document.

To erase the link text or button from the document completely, select it and press the

Backspace or Delete key.

Linking to external data

You can insert tables from HTML documents, and data located within named ranges

from an OpenOffice.org Calc or Microsoft Excel spreadsheet, into a Calc spreadsheet.

(To use other data sources, including database files in OOo Base, see “Linking to

registered data sources” on page 274.)

You can do this in two ways: using the External Data dialog or using the Navigator. If

your file has named ranges or named tables, and you know the name of the range or

table you want to link to, using the External Data dialog method is quick and easy.

However, if the file has several tables, and you want to pick only one of them, you

may not be able to easily determine which is which; in that case, the Navigator

method may be easier.

Using the External Data dialog

1) Open the Calc document where the external data is to be inserted. This is the

target document.

2) Select the cell where the upper left-hand cell of the external data is to be

inserted.

3) Choose Insert > Link to External Data.

4) On the External Data dialog (Figure 271), type the URL of the source

document or click the [...] button to open a file selection dialog. Press Enter to

get Calc to load the list of available tables.

5) In the Available tables/range list, select the named ranges or tables you want

to insert. You can also specify that the ranges or tables are updated every

(number of) seconds.

6) Click OK to close the dialog and insert the linked data.

270 OpenOffice.org 3.3 Calc Guide

1 2 ... 265 266 267 268 269 270 271 272 273 274 275 ... 433 434

Žádné komentáře

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