Bug 104955 - Check boxes in Base forms replaced by a small picture
Summary: Check boxes in Base forms replaced by a small picture
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.3.0.0.beta2
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2016-12-28 10:26 UTC by ribotb
Modified: 2017-02-06 08:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Example of check boxes (7.89 KB, image/png)
2016-12-28 10:26 UTC, ribotb
Details
Form with tablecontrol and checkboxes (10.67 KB, application/vnd.oasis.opendocument.database)
2017-01-03 17:49 UTC, Robert Großkopf
Details
example1 and example2 (133.80 KB, application/zip)
2017-01-06 10:50 UTC, ribotb
Details
Screenshot showing checkbox control in form (39.71 KB, image/png)
2017-01-06 12:07 UTC, Alex Thurgood
Details
Screenshot showing normal checkboxes with 5162 and MyODBC connection (115.92 KB, image/png)
2017-01-06 16:21 UTC, Alex Thurgood
Details
Screenshot of form created in 5162 then opened in LO5400alpha (96.74 KB, image/png)
2017-01-06 16:33 UTC, Alex Thurgood
Details
example checkbox (LO524, LO530 with LO524 profile, LO530 with new profile (19.15 KB, application/zip)
2017-01-07 17:20 UTC, ribotb
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ribotb 2016-12-28 10:26:40 UTC
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
Comment 1 Buovjaga 2017-01-03 16:44:54 UTC
Can you attach an example file with checkboxes?

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.
Comment 2 Robert Großkopf 2017-01-03 17:49:46 UTC
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.
Comment 3 Buovjaga 2017-01-03 19:07:25 UTC
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
Comment 4 ribotb 2017-01-03 22:45:29 UTC
(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
Comment 5 Alex Thurgood 2017-01-05 15:52:23 UTC
Setting back to needinfo pending further information from OP
Comment 6 ribotb 2017-01-06 10:50:45 UTC
Created attachment 130194 [details]
example1 and example2
Comment 7 ribotb 2017-01-06 10:53:02 UTC
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!
Comment 8 Alex Thurgood 2017-01-06 12:05:22 UTC
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.
Comment 9 Alex Thurgood 2017-01-06 12:07:05 UTC
Created attachment 130198 [details]
Screenshot showing checkbox control in form
Comment 10 ribotb 2017-01-06 15:43:37 UTC
Alex, my problem occurs with databases odb created before version 5.3.0 (and ODBC connector).

Bernard
Comment 11 Alex Thurgood 2017-01-06 16:20:11 UTC
(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.
Comment 12 Alex Thurgood 2017-01-06 16:21:04 UTC
Created attachment 130208 [details]
Screenshot showing normal checkboxes with 5162 and MyODBC connection
Comment 13 Alex Thurgood 2017-01-06 16:32:12 UTC
Oops, sorry, created with LO 5152 then re-opened in LO 5400 dev alpha, see attached screenshot

Windows 32bit only problem ?
Comment 14 Alex Thurgood 2017-01-06 16:33:17 UTC
Created attachment 130209 [details]
Screenshot of form created in 5162 then opened in LO5400alpha
Comment 15 Alex Thurgood 2017-01-06 16:38:13 UTC

> 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 ?
Comment 16 ribotb 2017-01-06 22:30:04 UTC
(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).
Comment 17 ribotb 2017-01-07 17:20:37 UTC
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! :-))
Comment 18 ribotb 2017-01-08 09:03:32 UTC
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.
Comment 19 Alex Thurgood 2017-01-09 16:07:29 UTC
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
Comment 20 ribotb 2017-01-09 21:55:19 UTC
(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+ !?
Comment 21 Alex Thurgood 2017-01-23 12:44:03 UTC
*** Bug 105463 has been marked as a duplicate of this bug. ***
Comment 22 Alex Thurgood 2017-01-23 12:48:38 UTC
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.
Comment 23 Robert Großkopf 2017-01-23 14:48:30 UTC
(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.
Comment 24 Alex Thurgood 2017-01-24 09:59:03 UTC
(In reply to robert from comment #23)

Hi Robert,

OK, let's keep them separate then.
Comment 25 Alex Thurgood 2017-01-27 09:48:55 UTC
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
Comment 26 ribotb 2017-01-27 19:56:48 UTC
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
Comment 27 Alex Thurgood 2017-02-06 08:52:32 UTC
Per comment 26 WFM in 54 alpha