Operation Manual

4) Move the fields you want in your table from the Database Columns list to the Table
column(s) list.
– To place the fields in the order you select, click the field and use the single arrow to
move the fields in the order you desire. You can also limit the fields you use to less than
all of the fields available.
– If you want to use all of the fields, use the double arrow pointing to the right to move all
of them at one time. The order of the fields in the table you create will be the same as in
the data source table.
– To remove a single field from the Table Column(s) list, click the field and use the single
arrow pointing to the left.
5) To start over, click the double arrow pointing to the left.
6) Select the settings for your table. Use the default settings as in Figure 264.
7) Click OK. Save the document.
Calc spreadsheets
There are two ways to transfer data into a Calc spreadsheet. One enters the data into the
spreadsheet cells. The other creates complete new records in the spreadsheet. While you can
directly access the data inserted into the spreadsheet cells, new records created in the
spreadsheet are read-only.
Entering data directly to the spreadsheet cells uses the Data to Text icon as when making a table
in a Writer document. But there are certain differences.
The steps are straightforward.
1) Click the cell of the spreadsheet which you want to be the top left cell of your data,
including the column names.
2) Use F4 to open the database source window and select the table whose 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 rows, hold down the Control key while clicking the gray box of the
rows you need. Those 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.
5) Save the spreadsheet.
Adding records to a spreadsheet is fairly easy. You need to have the Data Source window open,
your spreadsheet open, and the table you want to use selected.
1) Click the gray box containing the field name for the table’s ID field.
2) Drop and drag the gray box for the table’s ID field 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) Name and save the spreadsheet.
5) Click a row of the table in the Data Source window.
6) Drag the data in the ID field in the selected row onto the ID field in the spreadsheet. The
Save icon should activate.
262 | Getting Started with LibreOffice 5.0