Description: Testing with Version: 7.5.0.0.beta1 (AARCH64) / LibreOffice Community Build ID: 3aca23eec42e9d6fbe57071d7633ae1fc4bc5fcc CPU threads: 8; OS: Mac OS X 13.0.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded using an existing, and functional ODB file which is configured to connect to a local instance of a mysql server. When I open the ODB file, I'm asked for my password. Correct entry of the password leads to the display of the accessible tables. Double-click on any table entry from the list of tables. The grid view of the opened table shows no column headers, everything is blank, and no data is displayed. The grid is only displayed as the grey coloured top and side cell structure. Steps to Reproduce: 1. Open a ODB file which is configured to connect to a mysql server instance. 2. Double-click on a table from the list of available tables for that database. 3. Notice how the grid display contains no headers, nor rows, and no data. Actual Results: See above Expected Results: The grid view should display the data present in the table along with field names across the top of the grid. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.5.0.0.beta1 (AARCH64) / LibreOffice Community Build ID: 3aca23eec42e9d6fbe57071d7633ae1fc4bc5fcc CPU threads: 8; OS: Mac OS X 13.0.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
For comparison, this works correctly in Version: 7.4.1.2 / LibreOffice Community aarch64 Ventura macOS 13.0.1 Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0 CPU threads: 8; OS: Mac OS X 13.0.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded
Further testing shows that if I create a new ODB in my "Downloads" folder and connecting to the same database instance, with the exact same connection parameters, the tables and data are displayed correctly, so there must be something wrong with the file permissions granted to the LibreOfficeDev.app that causes the ODB file to be set to read-only.
Hopefully, this is a problem only with the current LibreOfficeDev 7.5 beta.
Hmm, well, sorry, guess there's more to it. If I create a new mysql/ODB file in LO 7.5 beta, none of the tables will display any data. If I
Not sure how to test this further.
The problem manifests itself independently of the connector type. I have now tried: direct connector JDBC connector ODBC connector. All three lead to the same result, cf attached screenshot (ODBC connector).
Created attachment 184155 [details] Screenshot of table grid display with ODBC connector
That's not a special MySQL-bug. Opened a HSQLDB embedded and a Firebird embedded. No grid is shown, no field. Will report a new bug for this. Did you really doesn't get this behavior with ODBC?
Comment on attachment 184155 [details] Screenshot of table grid display with ODBC connector Can I ask an admin to remove this image ? Not sure what happened here.
(In reply to Robert Großkopf from comment #8) > That's not a special MySQL-bug. Opened a HSQLDB embedded and a Firebird > embedded. No grid is shown, no field. Will report a new bug for this. > > Did you really doesn't get this behavior with ODBC? Hi Robert, the behaviour was also reproducible with ODBC, cf. comment 6.
Robert has confirmed that the display problem is applicable, irrespective of the type of database. Chnaging title to reflect that.
Could reproduce it on OpenSUSE 15.3 64bit rpm Linux. Might be it is a duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=152538 which might be a duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=152381 Couldn't test it, because there are no daily builds available for LO 7.5 on https://dev-builds.libreoffice.org/daily/
Could you give a try with a build which includes this commit: https://cgit.freedesktop.org/libreoffice/core/commit/?id=0390479ccf454cd87997fe97d640caf9f8c45a13 ?
(In reply to Julien Nabet from comment #13) > Could you give a try with a build which includes this commit: > https://cgit.freedesktop.org/libreoffice/core/commit/ > ?id=0390479ccf454cd87997fe97d640caf9f8c45a13 > ? Hi Julien, Seems to be working OK in Version: 7.6.0.0.alpha0+ (AARCH64) / LibreOffice Community Build ID: ad387d5b984c6666906505d25685065f710ed55d CPU threads: 8; OS: Mac OS X 13.0.1; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: en-US Calc: threaded do we need to wait for the next 7.5 rc ?
(In reply to Alex Thurgood from comment #14) > ... > do we need to wait for the next 7.5 rc ? Yes, it seems there's no beta 2 according to https://wiki.documentfoundation.org/ReleasePlan/7.5. 7.5.0 RC1 should be released between 19/12 and 25/12 (still according to the quoted link).
Seems to be working OK now in Version: 7.5.1.2 (AARCH64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 8; OS: Mac OS X 13.2.1; UI render: Skia/Raster; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded