https://bugs.documentfoundation.org/show_bug.cgi?id=157357
Bug ID: 157357
Summary: Autonumber indexing error on required fields
Product: LibreOffice
Version: 7.6.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
When editing a table, if a field that is designated as required is not
populated, an error message pops up that a required field has not been filled
in. The error is that when the dialog box is closed, the Autonumber function
increments, such that the primary key ID will increment without adding a new
record, however, the incremented value is not displayed until the next row is
entered or the table is saved. For each error message that occurs, the
Autonumber will increment +1. For a particular row in the table, if there are
5 attempts to move beyond a required field, that results in 5 error messages,
which will have the effect of indexing the Autonumber +5 for a single row.
This makes the numbering sequence out of sync by the number of error messages
that have popped up or been displayed. The next row will continue to have the
same delta, i.e. +5 from the last value.
A temporary workaround is to turn off the Autonumber, close the table, save,
reopen in edit mode, and turn on the Autonumber. This appears to clear the
counter and allows the Autonumber to increment correctly from the previous
value.
--
You are receiving this mail because:
You are the assignee for the bug.
