Bug 93623 - Provide graceful recovery from Excel VBA Basic Runtime Error which causes endless execution loop and message box display
Summary: Provide graceful recovery from Excel VBA Basic Runtime Error which causes end...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
5.0.0.5 release
Hardware: x86-64 (AMD64) macOS (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2015-08-24 14:07 UTC by Nico
Modified: 2021-05-02 19:53 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Screenshot Behaviour LO 4.4.5.2 (38.06 KB, image/png)
2015-08-24 14:07 UTC, Nico
Details
Screenshot Behavior LO 5.0.0.5 (34.85 KB, image/png)
2015-08-24 14:08 UTC, Nico
Details
xls-document that generates the behavior (132.50 KB, application/vnd.ms-excel)
2015-08-24 14:42 UTC, Nico
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nico 2015-08-24 14:07:09 UTC
Created attachment 118120 [details]
Screenshot Behaviour LO 4.4.5.2

Notice: I have looked at similar reports like #48634, but mostly they have been resolved for user specific or marked invalid.

What I want to put forward is that if on opening an Excel sheet with VBA makro, and if the Makro generates a runtime error, I have not found how to stop the makro. The runtime error popup blocks further usage of LibreOffice. LibreOffice has to be force quit.

This is for LO 4.4.5.2 and 5.0.0.5, hence this behavior has so far not been addressed.

Thanks for listening.
Comment 1 Nico 2015-08-24 14:08:04 UTC
Created attachment 118121 [details]
Screenshot Behavior LO 5.0.0.5
Comment 2 Alex Thurgood 2015-08-24 14:38:57 UTC
There are no blockers, per QA policy.
Comment 3 Alex Thurgood 2015-08-24 14:40:11 UTC
@Nico: please provide a test Excel document containing a macro where this can be reproduced reliably.
Comment 4 Nico 2015-08-24 14:42:55 UTC
Created attachment 118124 [details]
xls-document that generates the behavior
Comment 5 Nico 2015-08-24 14:44:18 UTC
Dear Alex,

you can find more xls-documents with complex makros here:

http://www.parmentier.de/steuer/steuer.htm?steuer01.htm

Thanks.
Comment 6 Nico 2015-08-24 14:49:08 UTC
Dear @Alex,

maybe "Blocker" is defined as non existent per QA-policy. But in this case I disagree because of the following:

If the user opens a document that causes the application to remain in an endless state without providing means to escape that state then this is a blocker from the user perspective.

But I am going to be careful in the future and not use this setting for the importance-popup.


Thanks for listening.
Comment 7 Alex Thurgood 2015-08-24 15:05:07 UTC
@Nico: thank you for the attached document, I can confirm the behaviour.

Version: 5.1.0.0.alpha1+
Build ID: ad1f0d1f1a195a00cf2ec2848745fdc6186bfbb1
Locale: fr-FR (fr.UTF-8)

OSX 10.10.5
Comment 8 Nico 2015-08-24 15:10:20 UTC
@Alex.

Good.

For information on my config:

MBP 17" Early 2008
OS X 10.5.5 (14F27)

LibreOffice Version: 5.0.0.5
Build-ID: 1b1a90865e348b492231e1c451437d7a15bb262b
Gebietsschema: de-DE (de.UTF-8)