Description: When trying to open Format > Spreadsheet theme, a BASIC runtime error and the macro editor appear. Steps to Reproduce: 1. Open Calc 2. Click on Format > Spreadsheet Theme Actual Results: This error pops up: BASIC runtime error. An exception occurred Type: com.sun.star.container.NoSuchElementException Message:. And the LibreOffice Macros & Dialogs.Tools window opens at the same time, with the following script in focus: LibreOffice Macros & Dialogues > Tools > ModuleControls ... with the line 159 highlighted: oLibContainer.LoadLibrary(LibName) (see screenshot) In LO 7.0.1, the error message is slightly different: BASIC runtime error. An exception occurred Type: com.sun.star.container.NoSuchElementException Message: /build/libreoffice-vH3EQM/libreoffice-7.0.1~rc1/basic/source/uno/namecont.cxx:117 Expected Results: The dialogue with the list of spreadsheet themes opens. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: The issue does not appear in safe mode, but I thought it would still be interesting to report this and maybe figure it why the error pops up? I am not sure what exactly in my configuration would be the source of this error. Version: 6.4.6.2 Build ID: 1:6.4.6~rc2-0ubuntu0.18.04.1 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: en-AU (en_AU.UTF-8); UI-Language: en-US Calc: threaded and Version: 7.0.1.1 Build ID: <buildversion> CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Ubuntu package version: 1:7.0.1_rc1-0ubuntu0.18.04.1 Calc: threaded
Created attachment 164881 [details] error message and macro window in LO 6.4.6
Thank you for reporting the bug. I can not reproduce the bug in Version: 6.4.6.2 Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115 CPU threads: 8; OS: Mac OS X 10.15.6; UI render: default; VCL: osx; Locale: de-DE (de_DE.UTF-8); UI-Language: en-US Calc: threaded
The issues seems to be linked to the "basic" folder in my user profile folder. I renamed "basic" to "basic.bak", reopened Calc and tested again: no error. I then narrowed it down to the dialog.xlc file, inside the "basic" directory: renaming it to "dialog.xlc.bak" allowed me to use the spreadsheet themes. Interestingly, there is nothing in this file: it is completely empty, 0 bytes. Where does this file come from? Is it supposed to be there? Or should it contain something, and it is the fact that it is empty that causes the error?
This is similar to bug 47953. Taking care of 44128 would solve this problem, let's mark this as dupe. Another interesting question is how the file in your profile got corrupted, but that could be really hard to find. If you can repro that, this bug can be kept open on that problem. *** This bug has been marked as a duplicate of bug 44128 ***
Your writing is really great. I’m so glad I read it. It kept me hooked the whole way through. https://www.imybkexperience.com/ https://www.mykfc-experience.com/ https://www.mybpcreditcard.one/
*** This bug has been marked as a duplicate of bug 44128 ***