Created attachment 129980 [details] Example of check boxes Hi, The check box is available (we can check it) but it is replaced by a small picture, the same if the box is checked or not. Inconvenient: we do not know the status of the check box. Bernard
Can you attach an example file with checkboxes? Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
Created attachment 130119 [details] Form with tablecontrol and checkboxes I have added an example, but couldn't confirm a buggy behavior. Have tested with OpenSUSE 42.1 64bit rpm Linux and KDE. The icon, that could be seen on the first screenshot, is the default-icon, if the original icon couldn't be found. Have seen such an icon before in the report-builder.
Works fine on Win 10 Version: 5.4.0.0.alpha0+ Build ID: 7ed40deee74a9869b7da073ad473241187420ff8 CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2016-12-30_23:18:54 Locale: fi-FI (fi_FI); Calc: group
(In reply to Buovjaga from comment #1) > Can you attach an example file with checkboxes? > > Set to NEEDINFO. > Change back to UNCONFIRMED after you have provided the document. Hi, I note that bug occurs with MariaDB/Odbc databases, not with embedded HSQLDB databases I'm looking for an explanation. Bernard
Setting back to needinfo pending further information from OP
Created attachment 130194 [details] example1 and example2
I don't understand, in the same form the problem can't appear on all the check boxes (example1 in attachment). First, I thought the problem was caused by the format of the field in the table: 'tinyint', but the problem can occurs also with format 'BIT' (example2 in attachment). Bernard PS : attachment in comment#6 above, sorry!
No repro with Version: 5.4.0.0.alpha0+ Build ID: e34cf2adc385d1b04e36e1fdb80cfaced1b7dee5 CPU Threads: 2; OS Version: Mac OS X 10.12.2; UI Render: default; Locale: fr-FR (fr_FR.UTF-8); Calc: group using a JDBC 5.1.39 connector to LAN mysql instance. 1) Set up a test table : CREATE TABLE chkbox ( id int(10) unsigned NOT NULL AUTO_INCREMENT, acompte decimal(10,0) DEFAULT NULL, recap tinyint(4) DEFAULT NULL, top tinyint(4) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 2) enter some sample data in table chkbox 3) create a form using wizard accepting defaults (grid), save the form. 4) open form in Form Design mode, and swap the columns recap and top for Checkbox controls, then save the form. 5) Open form in data entry mode. Screenshot enclosed.
Created attachment 130198 [details] Screenshot showing checkbox control in form
Alex, my problem occurs with databases odb created before version 5.3.0 (and ODBC connector). Bernard
(In reply to ribotb from comment #10) Hi Bernard, > Alex, my problem occurs with databases odb created before version 5.3.0 (and > ODBC connector). > > Bernard I tested LO 5162 for OSX with a MyODBC connector and a new ODB file created with that version to the same LAN instance of the mysql server as for the jdbc connection, and still can not reproduce. Enclosing screenshot.
Created attachment 130208 [details] Screenshot showing normal checkboxes with 5162 and MyODBC connection
Oops, sorry, created with LO 5152 then re-opened in LO 5400 dev alpha, see attached screenshot Windows 32bit only problem ?
Created attachment 130209 [details] Screenshot of form created in 5162 then opened in LO5400alpha
> Oops, sorry, created with LO 5152 then re-opened in LO 5400 dev alpha, see > attached screenshot > > Windows 32bit only problem ? @Bernard : was the earlier version of LO used to create the ODB file 32bit or 64bit ?
(In reply to Alex Thurgood from comment #15) > > @Bernard : was the earlier version of LO used to create the ODB file 32bit > or 64bit ? My databases were created 2 or 3 years ago on Win/x86, but I forgot the version number of LO (perhaps first versions 4).
Created attachment 130246 [details] example checkbox (LO524, LO530 with LO524 profile, LO530 with new profile News : Until now, in LO 5.3.0, I used an exact copy of the LO 5.2.4 profile. If I run LO 5.3.0 with a new profile, the check boxes wich appeared wirg a small picture (see my examples) are no longer displaued in the form! But, in edit mode these check boxes are present in the form, but without their normal appearence (a botder around a white background)! Not easy to find in the form! :-))
The problem occurs when using style: 'flat' in check box control. It's Ok with style: '3D'. With style: 'flat' - with new profile, check boxes are not displayed. - with my old profile, checkboxes are displayed with a small picture.
Sorry, still no repro with new profile and after having converted the tick box controls to Flat Version: 5.4.0.0.alpha0+ Build ID: b66b1e896c177df3c5de5d33037416152fc8a381 CPU Threads: 2; OS Version: Mac OS X 10.12.2; UI Render: default; Locale: fr-FR (fr_FR.UTF-8); Calc: group
(In reply to ribotb from comment #18) > The problem occurs when using style: 'flat' in check box control. It's Ok > with style: '3D'. > With style: 'flat' > - with new profile, check boxes are not displayed. > - with my old profile, checkboxes are displayed with a small picture. Not reproduced with version: 5.4.0.0.alpha0+ !?
*** Bug 105463 has been marked as a duplicate of this bug. ***
Although the problem doesn't seem to manifest itself in master, it would be good to get this fixed before final 5.3 release, hence increased priority and importance.
(In reply to Alex Thurgood from comment #21) > *** Bug 105463 has been marked as a duplicate of this bug. *** Don't think this bug 105463 is a duplicate. Original bugreport here about checkboxes in a tablecontrol in a form. I could never reproduce this on my system - could be because there seems to be a checkbox 3d and checkbox flat available in a tablecontrol, but no difference when I open the form for input new values. Seems this doesn't work any more since LO 4.0. The other report is about standalone-checkboxes. This I could confirm with LO 5.3.0.2, but not, for example, with LO 5.4.0.0.alpha0+ Time: 2017-01-19_23:59:27. So I can't confirm this bug, but the other! All tested with OpenSUSE 42.1, 64bit rpm Linux.
(In reply to robert from comment #23) Hi Robert, OK, let's keep them separate then.
No repro with existing profile and Version: 5.3.0.2 Build ID: 5ad7b2889021c491af62f7930a4b1cb631392f16 CPU Threads: 2; OS Version: Mac OS X 10.12.2; UI Render: default; Layout Engine: new; Locale: fr-FR (fr_FR.UTF-8); Calc: group using MyODBC connection to a LAN host
Hi; It seems that I am the only one in the LO community with this problem with LO 5.3.0. I have modified all check boxes in my forms (3D) with LO 5.2.to use now LO 5.3.0. As this problem does not appear in version 5.4, so I propose that this bug be closed. Bernard
Per comment 26 WFM in 54 alpha