Can't put macro in Form's Error Occurred event

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.
Post Reply
panoss
Posts: 23
Joined: Tue Apr 16, 2013 11:52 am

Can't put macro in Form's Error Occurred event

Post by panoss »

I'm trying to assign a macro in Error Occurred event of a form:
eo1.jpeg


BUT I can't! It automatically gets assigned to 'When receiving focus' event:
eo2.jpeg
It's probably a bug. Is there any way to work it around?
LibreOffice 4.0.0.2 on puppy linux
RPG
Volunteer
Posts: 2250
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Can't put macro in Form's Error Occurred event

Post by RPG »

Hello
panoss wrote:It's probably a bug. Is there any way to work it around?
When you assume it is a bug then use a newer version. When you just start with macros then use a stable version and that is 3.5.7

Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
panoss
Posts: 23
Joined: Tue Apr 16, 2013 11:52 am

Re: Can't put macro in Form's Error Occurred event

Post by panoss »

RPG wrote:Hello
panoss wrote:It's probably a bug. Is there any way to work it around?
When you assume it is a bug then use a newer version. When you just start with macros then use a stable version and that is 3.5.7

Romke
Hello, thanks for answering.
I'm using version 4.0.0.2 and it is stable, that's why I chose it. Isn't it stable?
LibreOffice 4.0.0.2 on puppy linux
User avatar
Hagar Delest
Moderator
Posts: 32667
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Can't put macro in Form's Error Occurred event

Post by Hagar Delest »

New versions of LO are not really stable. They even tell it on their website.
Try with a former version as advised. If the problem is fixed, then it was indeed a regression (that you can report).
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
panoss
Posts: 23
Joined: Tue Apr 16, 2013 11:52 am

Re: Can't put macro in Form's Error Occurred event

Post by panoss »

RPG wrote:Hello
panoss wrote:It's probably a bug. Is there any way to work it around?
When you assume it is a bug then use a newer version. When you just start with macros then use a stable version and that is 3.5.7

Romke
How about 3.6.6?
(I have puppy linux, and I' m using a downloader and installer, which, from stable versions, has only 3.6.6 and 4.0.0.2)

Edit: ok, I have and 3.5.7 as an option. From the puppy installer :lol: .
LibreOffice 4.0.0.2 on puppy linux
panoss
Posts: 23
Joined: Tue Apr 16, 2013 11:52 am

Re: Can't put macro in Form's Error Occurred event

Post by panoss »

I tried 3.5.7 but it has a problem, it gives me an error when I start a database:
'The connection to the data source 'my_mdb' could not be established.
The driver class 'org.hsqldb.jdbcDriver' could not be loaded. etc etc '

(I also tried 3.6.6, doesn't have such a problem)

Edit: I installed libhsqldb-java and 3.5.7 works ok.
LibreOffice 4.0.0.2 on puppy linux
panoss
Posts: 23
Joined: Tue Apr 16, 2013 11:52 am

Re: Can't put macro in Form's Error Occurred event

Post by panoss »

Problem, all versions have the same problem. :shock:
I tried 3.5.7 , 3.6.6 and of course 4.0.0.2 and they all do the same, they don't let me assign a macro to 'Error occurred' event!
LibreOffice 4.0.0.2 on puppy linux
RPG
Volunteer
Posts: 2250
Joined: Tue Apr 14, 2009 7:15 pm
Location: Netherlands

Re: Can't put macro in Form's Error Occurred event

Post by RPG »

Hello

Bind event not to gridcontrol but to form.

Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
B Marcelly
Volunteer
Posts: 1160
Joined: Mon Oct 08, 2007 1:26 am
Location: France, Paris area

Re: Can't put macro in Form's Error Occurred event

Post by B Marcelly »

When clicking "Error occurred" button at right, dialog Assign action appears.
But there is no event "Error occurred" there. So the first event "When receiving focus' is selected by default.
This is obviously a bug of LibreOffice (I have LibreOffice 3.6.4.3).
This problem does not occur in Apache OpenOffice 3.4.1.
Bernard

OpenOffice.org 1.1.5 / Apache OpenOffice 4.1.1 / LibreOffice 5.0.5
MS-Windows 7 Home SP1
papijo
Posts: 90
Joined: Sat Nov 08, 2014 5:46 pm
Location: Brittany, West of France

Re: Can't put macro in Form's Error Occurred event

Post by papijo »

B Marcelly wrote:When clicking "Error occurred" button at right, dialog Assign action appears.
But there is no event "Error occurred" there. So the first event "When receiving focus' is selected by default.
This is obviously a bug of LibreOffice (I have LibreOffice 3.6.4.3).
This problem does not occur in Apache OpenOffice 3.4.1.
I confirm that this bug still occurs in LibreOffice 4.3.3.2. One workaround is to insert the macro for event "Error occurred" using Apache Open Office, save your base and open it with LibreOffice. It works!
LO: LibreOffice 6.4.0.3 (x64) on Windows 10 64bits. Split database HSQL 2.3.4.
Post Reply