Description: Two different buttons "test connection" with different result. Th user will be confused. Steps to Reproduce: I created a ODS File with a few addresses and saved it as ODS file "Adressen.ods". Then created a new ODB and connected it to the ODS file. In Database - Tables - <Sheet1> - <double-click>: the content of the ODS is shown in "table data view: OK Right click on Tables - <Sheet1> - Database - property - "Test Connection": --> Error is shown "A driver is not registered for the URL ~sdbc:calc:/home/<path>/Adressen.ods" Right click on Tables - <Sheet1> - Database - Data Source Properties - Database type: Spreadsheet - Next - "Test Connection" --> no Error: "Connection Test: The connection was established successfully" Actual Results: So, why there a one time a error message and another time a success message. It makes no sense for the user, I think. Expected Results: Both "test connection" should success Reproducible: Always User Profile Reset: No Additional Info:
Have tested both ways to test the connection to the *.ods-file. Couldn't reproduce an error. The connection is established every way I could test. Tested with LO 6.2.5.2 on OpenSUSE 64bit rpm Linux.
I have done more tests and found a workaround. First, my setup, which has this error is: LibreOffice 6.2.4.2 (VCL kde5 !), installed via apt-get in my Kubuntu 64bit Then I removed the package "libreoffice-kde5" (1:6.2.4-0ubuntu0.19.04.1) The package "libreoffice-gtk3" (1:6.2.4-0ubuntu0.19.04.1) was already installed and is now active Now it works with: LibreOffice 6.2.4.2 (VCL gtk3 !), installed via apt-get in my Kubuntu 64bit: The connection is established in both ways --> OK Crosscheck: Install package "libreoffice-kde5" (1:6.2.4-0ubuntu0.19.04.1) with apt-get: Error as described reappeares Other Systems I tested, which do it right: LibreOffice 6.2.4.2 (VCL gtk3 !) on another PC Linux Mint 32bit: The connection is established in both ways --> OK LibreOffice 6.2.4.2 (VCL gtk3 !) on my Kubuntu via snap 64bit: The connection is established in both ways --> OK It seem that the package "libreoffice-kde5" causes this.
OK, I can reproduce it with VCL: x11. If I test the connection with contextmenue of the table > Database > Property > Test Connection it fails and the connection to the database has gone. Tested with LO 6.3.0.0beta2 on OpenSUSE 15, 64bit rpm Linux Works right with VCL: gtk3. So a special bug of VCL.
Dear Eugen, 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://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Couldn't confirm the buggy behavior any more with Version: 7.1.5.2 / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded Same version with VCL: x11 won't show the bug. … but: the path description has been changed table → Database → Properties… table → Database → Connection Type… All tested with OpenSUSE 15.2 64bit rpm Linux. I will set this one to WORKSFORME. Feel free to reopen if you could see the bug with LO 7.1 or newer.
The bug seemed to be resolved. My used versions: Version: 7.1.5.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 12; OS: Linux 5.11; UI render: default; VCL: kf5 Locale: de-DE (de_DE.UTF-8); UI: de-DE Ubuntu package version: 1:7.1.5-0ubuntu0.21.04.1 Calc: threaded