Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Input form for existing populated spreadsheet?

I have a LO (ver. 5.2) spreadsheet in which I have been maintaining our church's accounts, and I am now trying to create an input form to simplify entry of new records.

I have gone to Data -> Form when the row with the column names is selected and I see all the fields I need in the form, but when I try to enter data it enters into the row immediately below the one with the headings. If I move to the first empty row, which is where I want to enter new data, Data -> Form shows me just one field, Date. The Form does not seem to exist as a separate entity that can be edited: there is not even a Save button.

Is the only way to use a Form to start with a spreadsheet that contains no data?