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
   246   247   248   249   250   251   252   253   254   255   256