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
   181   182   183   184   185   186   187   188   189   190   191