Data Entry Form - Is there a "smarter" form to Modify/Add records in/to a Calc Database Range?

[najevi]

By a “smarter” Data Entry Form (DEF) I mean the following capabilities:

1. I can specify a prefill value for any field of a new record
2. Data Validation (Alt+d+v) configured for corresponding columns within the target Database Range will function on the form field in real time. (The current DEF fails silently.)
3. Autocomplete functions while the DEF is being used. i.e. leveraging values previously entered into that same field (corresponding column) of the target Database Range.

To be very clear

• I am talking about Calc’s (Alt+d+o) “Data Entry Form” (DEF)
• When I mention database here, I am referring to a plain old (Alt+d+d) Database Range defined within the current Calc spreadsheet (as opposed to an external database).

I can see that there is another Calc creation referred to as a (user designed) “Form” but it is not clear to me that such a form can be used for:

1. Adding a new record to a Database Range
2. Modifying an existing record in a Database Range

• If I am mistaken then please set me straight by guiding me toward documentation for this feature.

Help topics and previous questions posted here describe either the plain old Data Entry Form in Calc or a Form created in Base for interface to an external database. I prefer not to switch to the Base UI and an external database.

• Am I exploring the wrong kind of form?
• If there is a more powerful form for data entry into a plain old Database Range then please point me in that direction.

[Villeroy]

Calc is a spreadsheet program. Input forms are made for databases. Base is the LibreOffice component dealing with databases.

[najevi]

Calc expressly provides the Database Range object so that simple database applications can be handled without an external database.

This particular data input form (the Data Entry Form) is expressly designed to be “… a tool to make table data entry easy in spreadsheets”

So I do not think it unreasonable to be asking what alternative form features exist to enhance the data entry process for simple spreadsheets.

[Villeroy]

LibreOffice expressively provides access to databases. Database ranges on sheets are bullshit (unless linked to a database query). A spreadsheet has no tables, no filelds.and therefore no records. A form control bound to a cell edits that single cell.