Data Entry Forms for Spreadsheets

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.

Preparing the data entry form

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

Ativar o formulário

1. Coloque o cursor na linha de cabeçalho da tabela.

2. Escolha Dados - Formulário...

Preencher o formulário com dados

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

Botões da caixa de diálogo do formulário

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

Eliminar: elimina o registo atual.

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.

Fechar: fecha o formulário.

Reopening the form dialog

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