Scribd
Upload
9 views1 page

Registering ODB Data Sources in Calc

Chapter 6 discusses linking spreadsheet data in LibreOffice Calc, highlighting two methods: creating references to other sheets/documents and linking external data. It differentiates between absolute and relative hyperlinks, outlines steps for extracting tables from web pages, and explains how to register a data source in *.odb format. The chapter also lists advantages of extracting web data, including accuracy, efficiency, and improved collaboration.

Uploaded by

dilbagh.1511
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views1 page

Registering ODB Data Sources in Calc

Chapter 6 discusses linking spreadsheet data in LibreOffice Calc, highlighting two methods: creating references to other sheets/documents and linking external data. It differentiates between absolute and relative hyperlinks, outlines steps for extracting tables from web pages, and explains how to register a data source in *.odb format. The chapter also lists advantages of extracting web data, including accuracy, efficiency, and improved collaboration.

Uploaded by

dilbagh.1511
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Chapter – 6

Linking Spreadsheet Data

Q1. Name the two ways to link the sheets in a LibreOffice Calc.

1. Create reference to other sheet/document by using keyboard and mouse.


2. By linking external data.

Q2. Differentiate between Relative and Absolute Hyperlink.

An absolute hyperlink stores the complete location where the file is stored. So, if the file is
removed from the location, absolute hyperlink will not work

A relative hyperlink stores the location with respect to the current location.

Q3. Write steps to extract a table from a web page in a spreadsheet.

1. Open the spreadsheet where external data is to be inserted.


2. Select Sheet > External Links…….
3. The External Data dialog box will open.
4. Type the URL of the source document and press enter.
5. A dialog box is displayed to select the language for import. Selecting Automatic shows data
in the same language as in the webpage.
6. From the Available Tables?Ranges list, choose the desired table and clock ok.
7. Table will be inserted in the spreadsheet.

Q4. Write steps to register a data source that is in *.odb format.

1. Select Tools > Options > LibreOffice Base > Databases. The dialog box appears.
2. Click the new button to open the Create Database Link dialog box.
3. Click Browse to open a file browser and select the database file.
4. Type a name to use as the registered name for the database and click ok.

Q5. State advantages of extracting data from a web page into spreadsheet.

1. Accuracy: Extracting data directly from a webpage, ensure that the information is up-to-
date and accurate.
2. Efficiency: Extracting data automates the process of gathering data from a webpage.
3. Collaboration: It also facilitates organization and collaboration of data.

You might also like