Calc Guide

Launching Base to work on data sources
You can launch OOo Base at any time from the Data Source View pane. Right-click on
a database or the Tables or Queries icons and select Edit Database File. Once in
Base, you can edit, add, and delete tables, queries, forms, and reports.
For more about using Base, see Chapter 8 (Getting Started with Base) in the Getting
Started guide.
Using data sources in Calc spreadsheets
Data from tables in the data source pane can be placed into Calc documents in a
variety of ways.
You can select a cell or an entire row in the data source pane and drag and drop the
data into the spreadsheet. The data is inserted at the place where you release the
mouse button.
An alternative method uses the Data to Text icon and will include the column
headings above the data you insert:
1) Click the cell of the spreadsheet which you want to be the top left of your data
set including the column names.
2) Press F4 to open the database source window and select the table containing
the data you want to use.
3) Select the rows of data you want to add to the spreadsheet:
• Click the gray box to the left of the row you want to select if only selecting
one row. That row is highlighted.
• To select multiple adjacent rows, hold down the Shift key while clicking
the gray box of the rows you need.
• To select multiple separate rows, hold down the Control key while
selecting the rows. The selected rows are highlighted.
• To select all the rows, click the gray box in the upper left corner. All rows
are highlighted.
4) Click the Data to text icon to insert the data into the spreadsheet cells.
You can also drag the data source column headings (field names) onto your
spreadsheet to create a form for viewing and editing individual records one at a time.
Follow these steps:
1) Click the gray box at the top of the column (containing the field name you wish
to use) to highlight it.
2) Drag and drop the gray box to where you want the record to appear in the
spreadsheet.
3) Repeat until you have moved all of the fields you need to where you want
them.
4) Close the Data Source window: press F4.
5) Save the spreadsheet and click the Edit File button on the Standard
toolbar, to make the spreadsheet read-only. All of the fields will show the value
for the data of the first record you selected.
6) Add the Form Navigation toolbar: View > Toolbars > Form Navigation. By
default, this toolbar opens at the bottom of the Calc window, just above the
status bar.
Chapter 10 Linking Calc Data 277