Bug 165312 - Events for columns doesnt work
Summary: Events for columns doesnt work
Status: RESOLVED DUPLICATE of bug 89917
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
24.8.4.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-02-18 09:43 UTC by info
Modified: 2025-12-17 12:53 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Personaltermintabelle mit Makros, die automatisch neue Termine vergeben (21.36 KB, application/vnd.sun.xml.base)
2025-02-19 09:21 UTC, info
Details

Note You need to log in before you can comment on or make changes to this bug.
Description info 2025-02-18 09:43:45 UTC
Description:
If I assign a macro to a table column in a base form using an event (e.g. when the mouse is clicked), the macro is not triggered. It works for the "Table" control, but not for columns.

Steps to Reproduce:
1. Assign a makro to an event (column of a table), for example "at mouseklick"
2. Save the formular, start it, click at the column with the makro assigned
3. nothing happens

Actual Results:
the event is not triggert, the makro does not start

Expected Results:
the event triggers the makro, the makro starts after clicking at the column


Reproducible: Always


User Profile Reset: No

Additional Info:
the event triggers the makro, the makro starts after clicking at the column
Comment 1 Robert Großkopf 2025-02-18 14:40:29 UTC
Load up an example for testing. I'm using events like "on Focus" without any problem in columns of a table control.
Comment 2 info 2025-02-19 09:21:12 UTC
Created attachment 199305 [details]
Personaltermintabelle mit Makros, die automatisch neue Termine vergeben

Im Formular "Personaltermine" ist im Formular "Übersicht" in der Tabelle "Tabellen-Steuerelement 1" in der Spalte "Führungszeugnis" dem Ereignis "Maustaste gedrückt" das Makro "TerminFuehrungszeugnis" zugewiesen. (Das Makro vergibt einen neuen Termin, indem es einen SQL-Befehl erstellt und ausführt)

Man kann klicken wie man will, das Makro wird nicht ausgeführt.

Dasselbe Makro ist auch der Schaltfläche "neu FZ" über der Spalte zugeordnet. Hier klappt es prima.
Comment 3 Robert Großkopf 2025-02-19 11:30:11 UTC
There won't be happen any event when a table control isn't editable. This is bug 89917. If you assign a macro to events of the second (editable) table this events will happen.
First the cursor will be set in the field and second the event will be executed (doubleclick).

Think this is a duplicate of
https://bugs.documentfoundation.org/show_bug.cgi?id=89917
Comment 4 Alex Thurgood 2025-05-05 10:21:07 UTC
I'm not really sure what is supposed to happen where in this report, but when I entered a new record with a date in the lower grid control, and then clicked on a different tuple, the upper control grid was updated with that new date.

Is this what is supposed to happen ?

If so, I can't reproduce the buggy behaviour on

Version: 25.2.2.2 (AARCH64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 8; OS: macOS 15.4.1; UI render: Skia/Metal; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
Comment 5 Buovjaga 2025-12-17 11:22:53 UTC
(In reply to Alex Thurgood from comment #4)
> I'm not really sure what is supposed to happen where in this report, but
> when I entered a new record with a date in the lower grid control, and then
> clicked on a different tuple, the upper control grid was updated with that
> new date.
> 
> Is this what is supposed to happen ?
> 
> If so, I can't reproduce the buggy behaviour on

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the information.
Comment 6 info 2025-12-17 12:41:24 UTC
It seems so, that the bug has been fixed in the meantime. Thank you.
Comment 7 info 2025-12-17 12:52:32 UTC
Ah no, it is not solved. What Robert Großkopf sais is still right. The makro which is assigned to the button "neu FZ" works. But not clicking at the column. The makro is also assigned to the column "Führungszeugnis" in the table "Tabellen-Steuerelement 1", but that has no effekt. Neither clicking at the head of the column, nor clicking at a cell.
Comment 8 Buovjaga 2025-12-17 12:53:30 UTC
Then let's close as duplicate of the older one.

*** This bug has been marked as a duplicate of bug 89917 ***