Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Hyperlinks and URLs"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: {{DISPLAYTITLE:Hyperlinks and URLs}} {{Documentation/CG3Ch9TOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Referencing other documents |NextPage=Documentation/O...)
 
(→‎Relative and absolute hyperlinks)
Line 59: Line 59:
 
== Removing hyperlinks ==
 
== Removing hyperlinks ==
 
To remove a hyperlink, select it and press the ''Delete'' key. The ''Delete'' dialog opens if it is a text hyperlink.
 
To remove a hyperlink, select it and press the ''Delete'' key. The ''Delete'' dialog opens if it is a text hyperlink.
−
 
−
== Relative and absolute hyperlinks ==
 
−
Hyperlinks can be saved as either absolute or relative. An absolute hyperlink says, “Here is how to get there from this known starting point” and a relative hyperlink says, “Here is how to get there starting from where you are now”.
 
−
 
−
To change the way that OOo saves the hyperlinks choose '''Tools > Options > Load/Save > General''' and choose if you want URLs saved relative to the ''File System'', to the ''Internet'', or both.
 
−
 
−
Calc always displays an absolute hyperlink. Don’t be alarmed when it does this when you have chosen a relative hyperlink.
 
−
 
−
If you have a relative hyperlink and you move files (the document and any linked files) on your computer, you shouldn’t have to remake your hyperlink as long as you maintain the same directory structure. 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, the hyperlink will not break. This is only true as long as the files’ locations relative to each other do not change.
 
−
 
−
In the example below, the path is ''D:\My Documents'' for the linked file. That is because the folder both sheets are in is in that directory.
 
−
 
−
[[Image:CG3Ch9F16.png|thumb|none|500px|''Files on D drive'']]
 
−
 
−
If we move that folder to the ''H:\ ''drive, the links in Calc will automatically update because we have not changed the location of the files relative to each other. Both files are still in the ''working with multiple sheets'' folder.
 
−
 
−
[[Image:CG3Ch9F17.png|thumb|none|500px|''Files on H drive'']]
 
−
 
−
[[Image:CG3Ch9F18.png|thumb|none|500px|''Directory with linked files'']]
 
−
 
−
[[Image:CG3Ch9F19.png|thumb|none|500px|''Updated links on H drive'']]
 
−
 
−
Again, note that in the examples, the path is displayed as absolute even though it is relative.
 
−
 
−
{{Documentation/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.}}
 
−
 
−
{{Documentation/Tip| When you rest the mouse cursor 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.}}
 
−
 
−
 
−
{{CCBY}}
 
−
[[Category: Calc Guide (Documentation)]]
 

Revision as of 18:51, 3 January 2011



Hyperlinks can be used in Calc to create spreadsheets that will be used in a web interface or to jump to a different location from within a spreadsheet. This section covers inserting, editing, removing, and using hyperlinks.

Creating hyperlinks

When you type text (such as a website addresses or URL) that can be used as a hyperlink, OOo formats it automatically, creating the hyperlink and applying to the text a color and underlining. If this does not happen, you can enable this feature using Tools > AutoCorrect > Options and selecting URL Recognition.

Template:Documentation/Tip

Template:Documentation/Tip

Template:Documentation/Tip

You can also insert and modify links using the Hyperlink dialog. To display the dialog, click the Hyperlink icon HyperlinkIcon.png on the Standard toolbar or select Insert > Hyperlink from the menu bar. To turn existing text into a link, highlight it before opening the Hyperlink dialog.

On the left hand side, select one of the four types of hyperlinks:

  • Internet: a web address, normally starting with http://
  • Mail & News: for example an email address.
  • Document: the hyperlink points to another document or to another place in the presentation.
  • New document: the hyperlink creates a new document.
Hyperlink dialog showing details for Internet links

The top right part of the dialog changes according to the choice made for the hyperlink type. A full description of all the choices, and their interactions, is beyond the scope of this chapter. Here is a summary of the most common choices used in presentations.

For an Internet type hyperlink, choose the type of hyperlink (choose between Web, FTP or Telnet), and enter the required web address (URL).

For a Mail and News type hyperlink, specify whether it is a mail or news link, the receiver address and for email, also the subject.

For a Document type hyperlink, specify the document path (the Open File button opens a file browser); leave this blank if you want to link to a target in the same presentation. Optionally specify the target in the document (for example a specific slide). Click on the Target icon to open the Navigator where you can select the target, or if you know the name of the target, you can type it into the box.

For a New Document type hyperlink, specify whether to edit the newly created document immediately or just create it (Edit later) and the type of document to create (text, spreadsheet, etc.). For a presentation, Edit now is the more likely choice. The Select path button opens a directory picker.

The Further settings section in the bottom right part of the dialog is common to all the hyperlink types, although some choices are more relevant to some types of links.

  • Set the value of Frame to determine how the hyperlink will open. This applies to documents that open in a Web browser.
  • Form specifies if the link is to be presented as text or as a button. The figure below shows a link formatted as a button.
OOo Authors hyperlink as button
  • Text specifies the text that will be visible to the user.
  • Name is applicable to HTML documents. It specifies text that will be added as a NAME attribute in the HTML code behind the hyperlink.
  • Event button: this button will be activated to allow OOo to react to events for which the user has written some code (macro). This function is not covered in this book.

Template:Documentation/Note

Editing hyperlinks

To edit an existing link, place the cursor anywhere in the link and click Edit > Hyperlink. The Hyperlink dialog opens. 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.

The standard (default) behavior for activating hyperlinks in OOo 3 is to use Ctrl+click. This behavior can be changed in Tools > Options > OpenOffice.org > Security > Options, by deselecting the option Ctrl+click required to follow hyperlinks. If clicking in your links activates them, check that page to see if the option has been deselected.

Removing hyperlinks

To remove a hyperlink, select it and press the Delete key. The Delete dialog opens if it is a text hyperlink.

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/OOo3_User_Guides/Calc_Guide/Hyperlinks_and_URLs&oldid=191217"
Personal tools