Page 212 - Trackpad 402_Class-X_Final
P. 212
• New Document: This option will create a hyperlink that moves you to a newly created worksheet. You can choose
create and Edit now or just create it and Edit later. Select the File type as text, spreadsheet, etc. give a name to a file
in File textbox. You may select the path for a specific directory where you wish to create your file. In the Text textbox
type the text you wish to make as hyperlink. Click on Apply button.
Some of the common steering in all four tabs are:
• Frame: This specifies how the link will open.
• Form: The hyperlink created will be a text or a button.
• Text: The text you type here will become a hyperlink.
• Name: It is the name of the hyperlink.
Step 4: Click on Apply button.
Step 5: Then click on Close button to finish the process of linking.
Linking To External Data
An OpenOffice worksheet can have data from an external source like an HTML table, data arranged in a grid in any
other spreadsheet like Excel.
Follow the given steps to insert data from an external source:
Step 1: Select the cell in the OpenOffice worksheet where you want to insert an HTML table.
Step 2: Click on Insert tab and select Link to External Data option. The External Data dialog box opens.
This dialog box contains the following fields:
• URL of the external data source: Click on the three dots … to open a file selection dialog box. Then a list of files will
be displayed. Select the one needed.
• Available tables/ranges: Select the named ranges or tables you want to insert.
• Update every: If this option is selected then the ranges or tables are updated every specified second/seconds.
Step 3: Click on OK button to close this dialog and insert the linked data.
212 Trackpad Information Technology-X

