[Solved] LibreOffice crashes executing macro

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.

[Solved] LibreOffice crashes executing macro

Postby Schorpioen » Sat Jun 22, 2013 6:10 pm

Hello,

I tried to create a database with LibreOffice. It contains some macros. When starting the database I am first prompted to enable the macros. Then I get a contact form, containing several buttons. Most buttons activate macros that print a report. These reports are based on queries. I have created the database for someone who only uses Windows 8.

Now here is my problem:

I have created and tested the database in Windows Vista. Sometimes everything goes well, and sometimes not. The reason is not clear, because sometimes there is nothing changed and the next time it goes wrong again. I tried LibreOffice 4.03, 4.04 and 3.6, all versions with both JRE 1.6.0_22 and 1.7.0_25. One time everything works, sometimes the database crashes, after clicking a button to print a report. When using LO 3.6 and 4.0.3 the database seems to freeze (not responding) so I have to close LO and start again, each time with the message that the database must be restored. After this recovery than it will work again, even without something been changed. When LO 4.0.4 I get a window to restore the database immediately after clicking the same button. Then I start again to restore. After that I reopen the database and after clicking the same button I get the same window to restore the database.

When tested under Linux, I have had no crashes yet. Mageia with LO 4.0.3 and openSUSE with LO 3.6.

I really want it to work in Windows too.

Thanks in advance, Willem
Last edited by Hagar Delest on Thu Jun 27, 2013 8:39 am, edited 1 time in total.
Reason: tagged [Solved].
Schorpioen
 
Posts: 6
Joined: Wed Apr 16, 2008 11:07 am

Re: LibreOffice crashes executing macro

Postby Villeroy » Sat Jun 22, 2013 7:18 pm

LO is the most experimental office suite.
Base is the worst database front-end ever.
The report builder depends on Java and a 3rd party software named "Pentaho".
Java on Windows depends on several runtime libraries from coming from MS and Oracle (black spy vs. white spy).
There are no two equal Windows systems on this planet and the same system behaves differently after every reboot (did you turn off all virus scanning? are you really sure there is no malware?)

To this delicate software stack you add your own code written in a rotten lingo called "StarBasic" calling an API that makes a grown man cry.

What do you expect? What is all that macro madness good for? Can't you open and print a report manually?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27246
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LibreOffice crashes executing macro

Postby Schorpioen » Sun Jun 23, 2013 11:56 am

I'm not an IT-er. My knowledge was acquired bij self study. So, I am a novice, speaking in terms of making databases.
I use LO because I see no reason to spend money on a program that I need 2 or 3 times a year. Why LO then ? Because I read that OOo is not supported anymore.
The person I made the database for, is in his late forties and I think he saw a computer for the first time 2 weeks ago on his brand new pc. He only has seen Windows 8 and gets lost already. It's not an option to install Linux on his computer. This is the reason why I implemented some macros : for him it is easier to click a button than to click 3 or 4 times to print a report. For me it's better to work with macros and buttons because he can't do accidently any damage to the database.
So, yes, I can open and print a report manually, but he can't.
My system is protected very well, I suppose. I have the same result under Windows on several computers, including someone elses computers.
Under Linux, no crashes yet.
Schorpioen
 
Posts: 6
Joined: Wed Apr 16, 2008 11:07 am

Re: LibreOffice crashes executing macro

Postby RoryOF » Sun Jun 23, 2013 12:12 pm

Schorpioen wrote:<snip> Why LO then ? Because I read that OOo is not supported anymore.
<snip>


This is incorrect - OpenOffice is actively supported and actively under development. This Forum is served by Apache (OpenOffice) servers; it supports all OpenOffice derivatives, including LibreOffice. Apache OpenOffice v4.0 is in final test and release is expected shortly; it will be announced on this forum and elsewhere.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29608
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: LibreOffice crashes executing macro

Postby Schorpioen » Sun Jun 23, 2013 7:57 pm

RoryOF : I tested now with Apache OpenOffice, and I had no problems. Thanks for the hint.

Villeroy : I got an answer form Bugzilla and it seems the report-builder doesn't work in LO 4.0.4. It will be fixed in Version LO 4.0.5. Thanks for the input.
Schorpioen
 
Posts: 6
Joined: Wed Apr 16, 2008 11:07 am

Re: [Solved] LibreOffice crashes executing macro

Postby Hagar Delest » Thu Jun 27, 2013 8:40 am

Again FUD from the LibO team...
:roll:
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28561
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: LibreOffice crashes executing macro

Postby Villeroy » Thu Jun 27, 2013 10:41 am

Schorpioen wrote:RoryOF : I tested now with Apache OpenOffice, and I had no problems. Thanks for the hint.

Villeroy : I got an answer form Bugzilla and it seems the report-builder doesn't work in LO 4.0.4. It will be fixed in Version LO 4.0.5. Thanks for the input.

So it has nothing to do with your macro. The whole thing crashes when you open the report, right?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27246
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] LibreOffice crashes executing macro

Postby Schorpioen » Sat Jun 29, 2013 10:35 am

Villeroy wrote:So it has nothing to do with your macro. The whole thing crashes when you open the report, right?

That's wright. The bug is triggered by opening a report, any report. Not by the macro.
I installed the daily build versien of LO 4.1 (2013-06-27) and the problem still exists. If the problem still exists in the new upgrade, I will return to OOo.
Schorpioen
 
Posts: 6
Joined: Wed Apr 16, 2008 11:07 am


Return to LibreOffice

Who is online

Users browsing this forum: No registered users and 1 guest