Created attachment 190440 [details] "LibreOffice" folder (created with LO 7.6.2) System: MacBook Pro (Retina, 13-inch, Early 2015) MacOS 12.7 (Monterey) After installation of LO 7.6.2, I open an .odb (Base) file. A "LibreOffice" folder is created within /users/XXX/Library/Application Support This folder includes a folder named "4" which includes 2 folders : "cache" & "user" (which is the user profile, I suppose) This .odb file has a startup macro displaying a pop-up with user/pwd fields. This macro works well (login is properly checked) and access is allowed to the database. A second macro, immediately following the login, displays a form with several buttons. Here is the bug: the form is displayed but remains blank (no button) and LO freezes. Workaround (and possibly a source to look at to solve the problem): Uninstall LO 7.6.2 Delete the folder /users/Library/Application Support/Libreoffice/4 Install an older version of LO (I've tried LO 7.1.4.1) Open it (it creates a "/users/Library/Application Support/Libreoffice/4" file) Open the .odb file. It works (form is well displayed and all buttons are functional) Quit LO Install LO 7.6.2 Open it, open the .odb file. It works ! First guess: LO 7.6.2 creates a corrupted profile. When the profile already exists (not corrupted), it uses it and it works Attachments: both profiles (created with LO 7.1.4.1 & 7.6.2)
Created attachment 190441 [details] "LibreOffice" folder (created with LO 7.1.4.1)
Thank you for the report. Can you please provide the ODB file that contains the macros?
Created attachment 190789 [details] odb file Here is the odb file. Some forms and queries have been deleted (confidential). The remaining form "1. MENU - A lancer en premier" is the one which is to be displayed just after having entered login/password. The bad behavior is : the form remains blank and Libreoffice is stuck the good behavior should be : the form is well displayed (including buttons) and LibreOffice is ready to go on
[Automated Action] NeedInfo-To-Unconfirmed
What is the username and password to use in the example file? Which button do you press in the dialog: local, distant or VPN?
No username/password defined here. The odb file connects to a PostgreSQL database which is checked against username/password. Each buttons defines (macro "CONNEXION_DB") a database connection string related to either a local, remote or VPN connection (depending on where and how the computer should be connected to the database) Normal sequence is : 1. open odb file 2. macro "CONNEXION_DB" is triggered, displaying a from including 3 buttons. 3. Click on one button (the corresponding connection string to the database is defined) 4. The form "1. MENU - A lancer en premier" is displayed Steps 2,3 & 4 are related to the macro "CONNEXION_DB" (including a call to dialog "Boite_de_login") Please note that this bug (to be confirmed by now) occurs before having to select any of the 3 buttons : the form including these buttons remains blank (empty), no button displayed and LibreOffice is stuck
So for me, the issue is different: LO 7.6 does not notify the user that the file contains macros that are not going to be run. Not quite the same as what you describe, but might be related? Tested every time with a new profile: 7.5.8.2: macro security prompt at fileopen. Once macros are allowed, opening the file uses the custom dialog. 7.6.3.1: _no_ macro security prompt at fileopen. Once macros are allowed, opening the file uses the custom dialog. Version: 7.6.3.1 (X86_64) / LibreOffice Community Build ID: c4af5b1259bceea6e979e6fe2435dbee7a5a87c2 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Same on macOS: Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 2; OS: Mac OS X 13.2.1; UI render: Skia/Raster; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US This change I bibisected with the linux-64-7.6 repo to first bad build commit [90c59bb5b9c0b4d42872347f2f22fa2f2702361f] which points to: commit f41627ab60372345be646c53d967b65be43b562f author Samuel Mehrbrodt Fri Jan 27 10:34:29 2023 +0100 committer Samuel Mehrbrodt Mon Jan 30 08:15:09 2023 +0000 Show infobar instead of blocking dialog when macros are not allowed Reviewed-on: https://gerrit.libreoffice.org/c/core/+/146250 @Samuel, can you please have a look? Base does not show the infobar. @Can you test version 7.5 to see if it also works like 7.1? That would help narrow it down.
Have tried LO 7.5.8: same buggy behavior (without having ever launched LO 7.1, of course) I've also tried something a bit different: . install LO 7.5.8 . Open LO . Open database (including entering username/password), triggering the bug (blank screen, LO stuck) . Force quit LO . Open LO 7.1 . Open db. It works fine . Close db and quit LO 7.1 . Open LO 7.5.8 . Open db. It works fine I guess the same would occur with LO 7.6
Dear work, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug