Enter and correct records with Data Form

Use Data > Form to view and edit one table record at a time. The column headings become field labels, making a wide table easier to maintain without repeatedly scrolling sideways.

Prepare a clean record table

This procedure follows LibreOffice Calc 25.2 Community desktop with English menu-bar controls on Windows or Linux. It is documentary, not natively tested. Use a local practice ODS and preserve a saved baseline before editing records.

Enter these rows starting at A1:

ID	Item	Quantity	Shelf	Status
P101	Bolts	10	A2	Ready
P102	Washers	20	B3	Check

Keep the headers in row 1, with no merged cells or blank separator columns inside the table. Each row is one complete record; each column has one purpose. Use an identifier such as P101 so you can distinguish records with similar item names.

Place any totals outside this data table, preferably on another sheet. The starting record count is two, and the quantity total is 30. These controls help catch an accidental overwrite when adding a new row.

Open and inspect the form

Select a header or data cell within A1:E3 and choose Data > Form. The dialog shows fields labeled from the header row. Use Next Record, Previous Record or the scrollbar to move between records. Read the ID before editing a quantity; the first record displayed is not necessarily the row you meant to correct.

Tab moves forward between form fields and Shift+Tab moves backward. This is useful when a wide sheet makes adjacent cells hard to see together. If the labels are wrong or a field is missing, close the dialog and repair the table structure before entering more data. A form cannot infer the intended schema from an irregular layout.

Correct a record and test Restore

Navigate to P102. Change Quantity from 20 to 25, then use Enter to commit the updated data. Close the form and confirm the change in the sheet: P101 must still be 10, P102 must be 25, and the total should be 35.

Reopen the form, return to P102 and type 99 in Quantity without committing it. Choose Restore. The field should return to the record’s initial value of 25. Restore undoes the current form edit; it is not a version-history system for arbitrary previously saved changes.

If you already committed an incorrect quantity, navigate back to the identified record and deliberately correct it, then inspect the sheet. Do not assume closing the dialog cancels every edit you made.

Append rather than overwrite

Move to the last record before starting a new entry. Use New to advance to a new record at the bottom, then enter P103, Nuts, 6, C1 and Ready. Commit with Enter or the form’s New control as appropriate, then close and inspect the table.

The decisive check is three records: P101=10, P102=25 and P103=6. The total is 41. If the table still has only two records, you probably edited the current record instead of appending. Recover from your baseline or restore the overwritten record before continuing; a plausible quantity total alone cannot prove that all IDs survived.

Delete removes the current record. Practice deletion only on a disposable copy, and identify the record first. It is not a way to clear one field while keeping the rest of the row.

Verify saved data

Save and reopen the ODS. Reopen Data > Form and walk through all three IDs. Change P103’s quantity to 7, commit, and verify the new total 42 without changing the other two records. This checks both record selection and persistence.

For rules that restrict allowed entries, use a separate drop-down validation workflow. The form is an entry interface, not proof that every entered quantity or status meets your business rules.

Official references

• LibreOffice documentation 1