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

