Operation Manual

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 arrow to the left of the database’s name (see Figure 259). This
brings up Queries and Tables. 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.
Figure 259: Databases
Editing data sources
Some data sources (but not spreadsheets) can be edited in the Data View window. A record can be
edited, added, or deleted.
View a table’s data
If you click on a table its rows and columns of data appear on the right side of the Data Source
window. Editing this data requires only a click in the cell whose data should be changed, change
the data, and click in the row above or below it to save the new data.
Beneath the records are five tiny buttons. The first four move the cursor to the beginning, to the
left, to the right, and to the end respectively. The fifth button, with a small star, inserts a new record.
Figure 260: View Data Sources navigation buttons
To delete a record, right-click on the gray box to the left of a row to highlight the entire row, and
select Delete Rows to remove the selected row.
Figure 261: Deleting a row in the Data View window
Chapter 8 Getting Started with Base | 259