Bug 89917 - EDITING: Event in a tablecontrol never happens if datasource isn't editable
Summary: EDITING: Event in a tablecontrol never happens if datasource isn't editable
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-03-09 16:50 UTC by Robert Großkopf
Modified: 2024-11-07 07:05 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Open the forms and click with a mouse on the fields - events in non-editable tabelcontrol never happen. (30.02 KB, application/vnd.oasis.opendocument.database)
2015-03-09 16:50 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2015-03-09 16:50:07 UTC
Created attachment 113999 [details]
Open the forms and click with a mouse on the fields - events in non-editable tabelcontrol never happen.

In the attached database are three form.
Every field in every form is connected to an event of the mouse (onmouseover, onmouseclick ...)

1. Open Kontakte_Query_not_editable_Fields.
Move the mouse over the fields, click on the fileds. On every field the makro is executed and a msgbox appears "Event happened".

2. Open Kontakte_Query_not_editable_Tablecontrol.
Move the mouse over the fields, click on the fileds. No event happens, but the same events are linked to the fields as in the first form.

3. Open Kontakte_Table_editable_Tablecontrol.
Move the mouse over the fields, click on the fileds. Events only happen if the content of the field is selected. Could be this is a bug with the same reason. You must click on a field and then the event of this field would happen by the next click ore moving or something else.

The bug appears in all LO-versions I could test (First: LO 4.0.2.2). Couldn't test the first 3.3, because it wouldn't start a form without a very old Java.

My System: OpenSUSE 13.2, 64bit rpm Linux.
Comment 1 Alex Thurgood 2015-03-10 17:32:10 UTC
Confirming behaviour with LO master 

Version: 4.5.0.0.alpha0+
Build ID: 34d6ec2c6e6618beacac881ec28ab527b25558d1
Locale: fr_

OSX 10.10.2

and the form Kontakte_Query_not_editable_Tablecontrol

In form Kontakte_Table_editable_Tablecontrol
I see the Web field fires the event every time whereas the other two fields require two clicks to fire the event.
Comment 2 Robert Großkopf 2015-03-10 17:58:58 UTC
(In reply to Alex Thurgood from comment #1)
> 
> In form Kontakte_Table_editable_Tablecontrol
> I see the Web field fires the event every time whereas the other two fields
> require two clicks to fire the event.

One hint: This fields shows the event "Onmouseover". If I move the mouse over the fields and no filed in this column is marked the event never happens here. Try it, when the form is started ...

Regards

Robert
Comment 3 Alex Thurgood 2015-03-10 18:11:13 UTC
(In reply to robert from comment #2)


> 
> One hint: This fields shows the event "Onmouseover". If I move the mouse
> over the fields and no filed in this column is marked the event never
> happens here. Try it, when the form is started ...
> 



Agreed.
Comment 4 Julien Nabet 2015-03-19 20:52:38 UTC
On pc Debian x86-64 with master sources updated yesterday, here the results I got:
1) Kontakte_Query_not_editable_Fields
Just move mouse over E_Mail field triggers the popup
For the 2 other fields (Name and Web), I must click them

2) Kontakte_Query_not_editable_Tablecontrol
Mouse over or click it doesn't trigger anything

3) Kontakte_Table_editable_Tablecontrol
No effect when mouse over
it triggers a popup only when clicking web column
Weird thing, if you click on first row/first col just when entering, it triggers the popup, then never again.

Nothing special (warn/error) on console
Comment 5 Julien Nabet 2015-03-19 21:01:50 UTC
Just to understand, how do you link a field with a macro?
I tried right click on Field and found nothing
Comment 6 Julien Nabet 2015-03-19 21:03:10 UTC
Sorry, I just found I had to ungroup each element.
Comment 7 Julien Nabet 2015-03-19 21:16:33 UTC
I tested again after having taken a look to mouse events on forms.

For first form, everything seems ok.
For third form, the mouse move triggers the popup only on the cell which has the focus.

Taking a look to the second form, it seems that we don't only need the focus but also the cursor on the cell.
Comment 8 Julien Nabet 2015-03-19 21:18:59 UTC
Sorry, re reading all this, I just repeated slightly differently what Robert indicated in 3. of his description
(sometimes I should be less lazy and REALLY read the whole description :-))
Comment 9 Robert Großkopf 2016-03-05 10:12:25 UTC
Bug appears also in the first available LO-version (LO 3.3.0.4, OpenSUSE 42.1 64bit rpm Linux). So I set this bug as "Inherited From OOo".
Comment 10 QA Administrators 2017-03-06 15:56:56 UTC Comment hidden (obsolete)
Comment 11 Robert Großkopf 2017-03-08 18:53:00 UTC
Bug still exists with LO 5.3.1.1, OpenSUSE 42.1 Leap, 64bit rpm Linux.
Comment 12 QA Administrators 2018-03-09 03:46:18 UTC Comment hidden (obsolete)
Comment 13 Robert Großkopf 2018-03-09 07:22:18 UTC
Bug still exists with LO 6.0.2.1, OpenSUSE 42.3 Leap, 64bit rpm Linux.
Comment 14 QA Administrators 2019-03-10 03:21:00 UTC Comment hidden (obsolete)
Comment 15 Robert Großkopf 2019-03-10 07:39:41 UTC
Bug still exists on LO 6.2.1.2, OpenSUSE 15, 64bit rpm Linux
Comment 16 QA Administrators 2021-03-10 04:04:46 UTC Comment hidden (obsolete)
Comment 17 Robert Großkopf 2021-03-10 10:46:54 UTC
Bug still exists with LO 7.1.1.2, OpenSUSE 15.2, 64bit rpm Linux.
Comment 18 QA Administrators 2024-11-07 03:15:06 UTC Comment hidden (obsolete)
Comment 19 Robert Großkopf 2024-11-07 07:05:28 UTC
Bug is still the same in  WHERE "ID" IN 
Version: 24.8.3.1 (X86_64) / LibreOffice Community
Build ID: 65412f067af443213e726c93f137ccc85c9a1e06
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded