Page 251 - TP_IT_V1.0_C10_flipbpookl
P. 251
Absolute Hyperlink
It refers to reaching to the linked file by writing the complete address starting from the root directory. If the target
location is changed then the absolute hyperlink will stop working.
To make it work, follow the given steps:
Step 1: Select the Tools Options option in the Menu bar. The Options dialog box will open.
Step 2: Click on the Load/Save category. The Load/Save category expands and displays the options.
Step 3: Select the General option. The general options related to Calc displays on the right-side of the Options dialog
box.
Step 4: Deselect the Save URLs relative to file system and Save URLs relative to internet check boxes if you want the
absolute hyperlink.
Step 5: Click the OK button.
In LibreOffice Calc, each sheet can have a maximum of 1,048,576 rows and a maximum
of 16384 columns.
Creating a Hyperlink
To create a hyperlink, steps are as follows:
Step 1: Select the cell in a spreadsheet in which you want to create hyperlink. If there is already some text, then select
the text.
Step 2: Click on Hyperlink icon on the Standard toolbar.
OR
Select the Insert Hyperlink option from the Menu bar.
Electronic Spreadsheet (Advanced) using LibreOffice Calc 249

