Page 186 - IT_V1.0_Class10
P. 186
For a Document hyperlink, specify the sheet’s path in Path field (the Open File button opens a file browser);
leave this blank if you want to link to a target in the same spreadsheet. Optionally specify the target in the
sheet (for example a specific sheet). Click on the Target in Document 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 Target box.
For a New Document hyperlink, specify whether to edit the
newly created sheet immediately (Edit now) or just create it now
and edit later and enter the file name and the type of sheet to
create (text, spreadsheet, etc.). The Select path button opens a
directory picker dialog box.
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.
Frame: Set the value of Frame to determine how the hyperlink will open (top, parent, blank, self). This
applies to sheets that open in a Web browser.
Form: Form specifies if the link is to be presented as text or as a button.
Text: Text specifies the text that will be visible to the user. If you do not enter anything here, Calc will use
the full URL or path as the link text. Note that if the link is relative and you move the file, this text will not
change, though the target will.
Name: Name is applicable to HTML documents. It specifies text that will be added as a NAME attribute in
the HTML code behind the hyperlink.
Open file
Target in
Document
Linking to External Data
Internet is a rich source of information, which is stored in the form of web pages. The web pages are written
in HTML documents. Data on a web page can be stored in the form of tables. It is possible to insert tables
from HTML documents, and data located within named ranges from LibreOffice Calc or Microsoft Excel
spreadsheet, into a Calc spreadsheet.
This can be done in two ways: using the External Data dialog or using the Navigator.
To Link External Data/Document:
Step 1: On the left panel, select the Document option.
184 Information Technology Play (Ver 1.0)-X

