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

Creating the reference with the keyboard

Typing the reference is simple once you know the format the reference takes. The

reference has three parts:

• Path and file name

• Sheet name

• Cell

Looking at Figure 268 you can see the the general format for the reference is

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

Note

The reference for a file has three forward slashes /// and the reference

for a hyperlink has two forward slashes //. The format of the path and file

name depends on the operating system in use.

If a cell with a reference in it shows #REF it may mean that the link is no

longer valid. Check the location of the file and amend the reference to

the correct path and name.

Hyperlinks and URLs

Hyperlinks can be used in Calc to jump to a different location from within a

spreadsheet to other parts of the current file, to different files or even to web sites.

Relative and absolute hyperlinks

Hyperlinks can be stored within your file as either relative or absolute.

A relative hyperlink says, Here is how to get there starting from where you are now

(meaning from the folder in which your current document is saved) while an absolute

hyperlink says, Here is how to get there no matter where you start from.

An absolute link will stop working if the target is moved. A relative link will stop

working only if the start and target locations change in relation to each other. For

instance, if you have two spreadsheets in the same folder linked to each other and

you move the entire folder to a new location, a relative hyperlink will not break.

To change the way that OOo stores the hyperlinks in your file, select Tools >

Options > Load/Save > General and choose if you want URLs saved relatively

when referencing the File System, or the Internet, or both.

Calc will always display an absolute hyperlink. Don’t be alarmed when it does this

even when you have saved a relative hyperlink—this ‘absolute’ target address will be

updated if you move the file.

Note

Make sure that the folder structure on your computer is the same as the

file structure on your web server if you save your links as relative to the

file system and you are going to upload pages to the Internet.

Tip

When you rest the mouse pointer on a hyperlink, a help tip displays the

absolute reference, since OOo uses absolute path names internally. The

complete path and address can only be seen when you view the result of

the HTML export (saving the spreadsheet as an HTML file), by loading

the HTML file as Text, or by opening it with a text editor.

Chapter 10 Linking Calc Data 267

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

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

Žádné komentáře

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

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

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