Saving of data with Firebird should be done automatically since LO 7.6., see bug 117118. Automatically saving will only work if there has nothing been saved before like a new created query, a delete view, any change of a form or something else. If Save has been pressed and after this action there will input new data in a table you could close the database file and LO. Reopen database file and all new inserted data will be lost. See: https://bugs.documentfoundation.org/show_bug.cgi?id=117118#c23 File for testing: https://bugs.documentfoundation.org/attachment.cgi?id=189553 Seems this bug doesn't appear in Windows, as described in https://bugs.documentfoundation.org/show_bug.cgi?id=117118#c25
No repro on macOS. Repro with Version: 7.6.1.2 (AARCH64) / LibreOffice Community Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674 CPU threads: 8; OS: Mac OS X 13.4; UI render: Skia/Raster; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded This works correctly with Version: 7.5.6.2 (AARCH64) / LibreOffice Community Build ID: f654817fb68d6d4600d7d2f6b647e47729f55f15 CPU threads: 8; OS: Mac OS X 13.4; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded ==>> regression
With Version: 7.5.6.2 (AARCH64) / LibreOffice Community Build ID: f654817fb68d6d4600d7d2f6b647e47729f55f15 CPU threads: 8; OS: Mac OS X 13.4; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded I get asked upon closure whether I want to save the changes made, i.e. the added tuples. Clicking on Save then writes those changes to the ODB file and closes the file. After shutting down LO and re-opening the ODB the added tuples are still there, as they should be.
(In reply to Alex Thurgood from comment #1) > > ==>> regression May be it is a regression generated by my patch to tdf#117118, so I've reverter the patch until further investigation
The problematic commit was reverted in https://cgit.freedesktop.org/libreoffice/core/commit/?id=fbf71a4c21106fbed7c070ba940809fd84c76dfe, so this issue can be consider fixed.