Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

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.

Image:Tip.png If you do not want OOo to convert a specific URL to a hyperlink, select Edit > Undo Insert from the menu bar or press Control+Z immediately after the formatting has been applied.
Image:Tip.png To change the color of hyperlinks, go to Tools > Options > > Appearance, scroll to Unvisited links and/or Visited links, pick the new colors and click OK. Caution: this will change the color for all hyperlinks in all components of—this may not be what you want.
Image:Tip.png In Writer and Calc (but not Draw or Impress), you can also change the Internet link character style or define and apply new styles to selected links.

You can also insert and modify links using the Hyperlink dialog. To display the dialog, click the Hyperlink icon Image: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 https://
  • 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.
Image:documentation_note.png A hyperlink button is a type of form control. As with all form controls, it can be anchored or positioned by right-clicking on the button in design mode. More information about forms can be found in Chapter 15 of the Writer Guide.

For the button to work , the spreadsheet must not be in design mode. To toggle design mode on and off, view the Form Controls toolbar (View > Toolbars > Form Controls) and click the Design Mode On/Off button Image:FormDesignOffIcon.png.

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire