Bug 113552 - Cannot enter data on Base forms
Summary: Cannot enter data on Base forms
Status: CLOSED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.4.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-10-31 11:15 UTC by tim
Modified: 2018-05-11 08:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description tim 2017-10-31 11:15:23 UTC
Description:
I updated to ubuntu 17.10, libreoffice 5.4.2.2.  All OK, except on Base, where I cannot enter any data in any field.  Nothing is displayed at all.  Writer etc are all fine.,  

Steps to Reproduce:
1. Open any of my base forms
2. Try to enter data


Actual Results:  
Nothing is displayed

Expected Results:
Something displayed


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.102 Safari/537.36 Vivaldi/1.93.955.48
Comment 1 tim 2017-10-31 11:21:58 UTC
I decided to try installing libreoffice-gtk3, thinking this could be a gnome update issue.

I can now enter data - good.  But all my forms are now maximised as per #112590, which is 'less than ideal' (putting it rather mildly).
Comment 2 raal 2017-11-01 06:45:48 UTC
I can not confirm with Version: 6.0.0.0.alpha0+
Build ID: afeff9102c2935139de4efd40fd2286dce396706
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-09-17_23:32:41

Please, could you test with newer version? Setting bug as needinfo, set as unconfirmed again if problem still occurs in newer version. Thank you.


http://dev-builds.libreoffice.org/daily/master/
Comment 3 tim 2017-11-01 08:21:21 UTC
I now notice that my full version info wasn't in my first post. Suffice to say that I had not loaded the libreoffice-gtk2 or gtk3 packages, and was therefore running the x11 version.

I see you ran the gtk2 version, and that works. I'm not surprised.

Can I suggest you also briefly try without libreoffice-gtk2?  I'm reasonably sure it's the change to ubuntu 17.10 moving to gnome that has caused the issue, and hence could be regarded as an ubuntu problem.

I can't try version 6 yet, but will try to do so later.  However I've no reason to think things will be any different.

If you find that without the gtk2 module the problem surfaces again, then the solution for any user is simply to install the gtk2/3 module, and put up with the other issues that may raise.
Comment 4 tim 2017-11-01 09:12:52 UTC
I have installed 6.0.0.0 but it always runs as gtk2.  I don't know how to run it as x11.  I tried ./soffice --display x11 but that doesn't work.

Is there a module I should remove before installation, or some other command line parameter I could use?
Comment 5 raal 2017-11-01 18:09:20 UTC
(In reply to tim from comment #4)
> I have installed 6.0.0.0 but it always runs as gtk2.  I don't know how to
> run it as x11.  I tried ./soffice --display x11 but that doesn't work.
> 
> Is there a module I should remove before installation, or some other command
> line parameter I could use?

tested with x11 and can not confirm the bug. VCL: x11;
You can use parameter SAL_USE_VCLPLUGIN=gen
for example ~$ SAL_USE_VCLPLUGIN=gen ~/lodev/libreoffice/instdir/program/soffice
Comment 6 tim 2017-11-01 20:43:59 UTC
I need to be specific on this, so please bear with me.  You may well decide it isn't a bug. This is what I found.

If libreoffice-gtk2 and libreoffice-gtk3 are not installed, the version I normally use shows as:

Version: 5.4.2.2
Build ID: 1:5.4.2~rc2-0ubuntu0.17.10.1~lo1
CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: x11; 
Locale: en-GB (en_GB.UTF-8); Calc: group

With complex databases using a mysql/mariadb back end I cannot enter any data, even into tables (not just on forms).  However, with simple built-in (HSQLDB) databases it works.



I installed libreoffice-gtk3:

Version: 5.4.2.2
Build ID: 1:5.4.2~rc2-0ubuntu0.17.10.1~lo1
CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); Calc: group

and it now all works.


I run the same version, with libreoffice-gtk3 still installed, but using SAL_USE_VCLPLUGIN=gen soffice:

Version: 5.4.2.2
Build ID: 1:5.4.2~rc2-0ubuntu0.17.10.1~lo1
CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: x11; 
Locale: en-GB (en_GB.UTF-8); Calc: group

And it still works. Puzzling.


If I run 6.0.0.0 with or without SAL_USE_VCLPLUGIN=gen it also works.  I don't have the option to remove libreoffice-gtk3 completely from this version so can't compare with 5.4.2.2.


The moral of this seems to be that I have to have libreoffice-gtk3 (or gtk2, but I haven't tested that) installed to use Base as a front end to Mysql/mariadb, and live with bug #112590 until it's fixed.

More of 'a feature' than a bug I guess.
Comment 7 QA Administrators 2018-05-02 15:46:57 UTC Comment hidden (obsolete)
Comment 8 tim 2018-05-10 12:34:10 UTC
Hi,

I hadn't tested this for some time.  Suffice to say that the problem seems to have been fixed or gone away :)

I'm now on Version: 6.0.4.2
Build ID: 1:6.0.4~rc2-0ubuntu0.17.10.1
CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: x11; 
Locale: en-GB (en_GB.UTF-8); Calc: group

I can enter data in tables, or on forms, connected to mysql/mariadb databases with no problem.

My problems with gtk-2 and with gtk-3 (even worse) for form sizes (bug #112590) still exist, but I can use the x11 version to avoid this.

Thanks to all who keep up the good work at LibreOffice.

I haven't updated the status.  I'll leave it you do to decide if it's resolved/not-a-bug or whatever.
Comment 9 Alex Thurgood 2018-05-11 08:10:09 UTC
Per comment 8, closing as WFM.