Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Form

Data Entry Form is a tool to make table data entry easy in spreadsheets. With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide.

To access this command...

Choose Data – Form...

Preparing the data entry form

To be effective, the Calc data table should have a header row, where the content of each cell is the label of the column. The content of header cells become the label of each data field in the form.

Activating the form

  1. Place the cursor in the header row of the table.

  2. Choose Data - Form....

Filling the form with data

Enter the data in the text fields. Press Enter or click New to add it to the table.

Form dialog buttons

New: fill the record (table row cells) using the content of form fields and jump to the next record or add a new record in the bottom of the table.

Delete: deletes the current record.

Restore: when a form field is edited, restore the record contents to its initial state.

Previous record: move to the previous record (table row).

Next record: move to the next record.

Close: close the form.

The form dialog box and header row cells as field labels

Use the Tab and Shift-Tab keys to jump forward and backward between text boxes of the form dialog.

You also can use the form scroll bar to move between text boxes.

Reopening the form dialog

To reopen the form dialogue box, place the cursor on the header row and open the form. The displayed record in the form dialogue box is the first data record. Move to the last record before entering new data otherwise the current record will be edited.