Can't put macro in Form's Error Occurred event
Can't put macro in Form's Error Occurred event
I'm trying to assign a macro in Error Occurred event of a form:
BUT I can't! It automatically gets assigned to 'When receiving focus' event: It's probably a bug. Is there any way to work it around?
BUT I can't! It automatically gets assigned to 'When receiving focus' event: It's probably a bug. Is there any way to work it around?
LibreOffice 4.0.0.2 on puppy linux
Re: Can't put macro in Form's Error Occurred event
Hello
Romke
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.7panoss wrote:It's probably a bug. Is there any way to work it around?
Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
Re: Can't put macro in Form's Error Occurred event
Hello, thanks for answering.RPG wrote:Hello
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.7panoss wrote:It's probably a bug. Is there any way to work it around?
Romke
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
- 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
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).
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
Re: Can't put macro in Form's Error Occurred event
How about 3.6.6?RPG wrote:Hello
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.7panoss wrote:It's probably a bug. Is there any way to work it around?
Romke
(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 .
LibreOffice 4.0.0.2 on puppy linux
Re: Can't put macro in Form's Error Occurred event
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.
'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
Re: Can't put macro in Form's Error Occurred event
Problem, all versions have the same problem.
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!
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
Re: Can't put macro in Form's Error Occurred event
Hello
Bind event not to gridcontrol but to form.
Romke
Bind event not to gridcontrol but to form.
Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
-
- 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
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.
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
OpenOffice.org 1.1.5 / Apache OpenOffice 4.1.1 / LibreOffice 5.0.5
MS-Windows 7 Home SP1
Re: Can't put macro in Form's Error Occurred event
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!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.
LO: LibreOffice 6.4.0.3 (x64) on Windows 10 64bits. Split database HSQL 2.3.4.