Bug 100634 - macro syntax error causes infinite loop and cant close file
Summary: macro syntax error causes infinite loop and cant close file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL: https://msdn.microsoft.com/en-us/libr...
Keywords: filter:xls
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
Reported: 2016-06-27 06:05 UTC by Tim Chambers
Modified: 2021-04-18 03:47 UTC (History)
2 users (show)

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

file won't open successfully with calc (823.76 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2016-06-27 06:05 UTC, Tim Chambers

Note You need to log in before you can comment on or make changes to this bug.
Description Tim Chambers 2016-06-27 06:05:02 UTC
Created attachment 125934 [details]
file won't open successfully with calc

Attempting to open this macro enabled file results in the following error:

BASIC syntax error.
If not allowed outside a procedure.

error will not close and instance of Libre Office needed to be killed externally (using task manager)

The file opens successfully in Microsoft office 2013.
Comment 1 Julien Nabet 2016-06-27 19:34:22 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.
It seems LO doesn't accept this kind of instruction (directive):
#If Win64 And VBA7 Then
Comment 2 Julien Nabet 2016-06-27 19:57:15 UTC
If you remove the directives (and so have to decide to keep 32 or 64 bits parts), it seems ok (at least no more popups).
Of course, it's just a workaround.
Comment 3 QA Administrators 2017-09-01 11:15:22 UTC Comment hidden (obsolete)
Comment 4 Tim Chambers 2017-09-04 02:03:04 UTC
Tested on WIn 10, Calv version

Enabling macros and opening the document gives the following error popup window which won't go away (click OK and it just pops up again)

BASIC syntax error.
Unexpected symbol: ???.

Still have to kill the program from task manager
Comment 5 QA Administrators 2018-09-05 02:54:30 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2021-04-18 03:47:50 UTC Comment hidden (spam)