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: libreoffice-bugs@lists.freedesktop.org Reporter: gshock...@pm.me 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.