Operation Manual

3) Click Browse to locate the spreadsheet you want to access. If the spreadsheet is

password protected, check the Password required box. Click Next.

4) If the spreadsheet requires a user’s name, enter it. If a password is also required, check its

box. Click Next.

Note

Using this method of accessing a spreadsheet, you cannot change anything in the

spreadsheet. You can only view the contents of the spreadsheet, run queries, and

create reports based upon the data already entered into the spreadsheet.

All changes in a spreadsheet must be made in the spreadsheet itself, using Calc.

After modifying the spreadsheet and saving it, you will see the changes in the

database. If you create and save an additional sheet in your spreadsheet, the

database will have a new table the next time you access it.

Registering *.odb databases

Databases created by LibreOffice are in the *.odb (OpenDocument Base) format. Other programs

can also produce databases in this format. Registering a *.odb database is simple:

1) Choose Tools > Options > LibreOffice Base > Databases.

2) Under Registered databases, click New.

3) Browse to where the database is located.

4) Make sure the registered name is correct.

5) Click OK.

Note

Sometimes when updating LibreOffice to a newer version, your list of registered

database files disappears. When that happens, you need to use these steps to

Using data sources in LibreOffice

Having registered the data source, whether a spreadsheet, text document, external database or

other accepted data source, you can use it in other LibreOffice components including Writer and

Calc.

Viewing data sources

Open a document in Writer or Calc. To view the data sources available, press F4 or select View >

Data Sources from the pull-down menu. This brings up a list of registered databases, which will

include Bibliography and any other database registered, such as the Automobile database created

earlier in this chapter.

To view each database, click on the to the left of the database’s name (see Figure 226). This

brings up Tables and Queries. Click on the next to Tables to view the individual tables created.

Now click on a table to see all the records held in it.

Chapter 8 Getting Started with Base | 239