Page 249 - TP_IT_V1.0_C10_flipbpookl
P. 249

You can add cell reference between sheets outside the document using keyboard by performing the following steps:
                 Step 1:  Click on cell B4 in the Sheet 1 sheet in the Sheet tab of the Total Inventory spreadsheet.

                 Step 2:   Type  the following formula  =’file:///C:/Data/Branch  Inventory.ods’#$Meerut.B5+’file:///C:/Data/Branch
                         Inventory.ods’#$Delhi.B5+ ‘file:///C:/Data/Branch Inventory.ods’#$Lucknow.B5.






















                 Step 3:  Press the Enter key to see the total inventory sales of Scrub i.e. 12100, as shown below:















                 Working with Hyperlinks

                 In LibreOffice Calc, a hyperlink is a feature that allows you to  jump to a different location from within a spreadsheet.
                 When users click on the hyperlink, Calc will navigate to the specified destination, whether it’s another location within
                 the spreadsheet, a file on the computer, or a website on the internet.
                 Hyperlinks in Calc can be edited or removed by selecting the cell containing the hyperlink and then using the appropriate
                 options by using the context menu.
                 Hyperlinks helps you to:
                 •  Move to a specific cell within the current spreadsheet.
                 •  Move to a specific location in another file. This file can be a spreadsheet, document, or any other file.
                 •  Accessing a specific website.

                 •  Sending an email to a specific address.
                 •  Creating a new file.
                 Hyperlink in a spreadsheet is of two types which are as follows:
                 •  Relative Hyperlink
                 •  Absolute Hyperlink
                 Relative Hyperlink

                 It refers to reaching the linked document with respect to the current location. It will include the partial cell address in
                 hyperlink. If the start and target locations change relative to each other, then relative hyperlink will not work.



                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  247
   244   245   246   247   248   249   250   251   252   253   254