You must enable macro execution when loading the file to see the problem. Running the macro once by hand does not show the problem; the problem is that libre-office runs the macro thousands and thousands of times whether you like it or not when macros are enabled.
RESULTS:
A message box "a MYFUNC called X times.." appears. Click OK every time it appears.
Wait at least 30 seconds! You should see at least hundreds of calls...
Run "top" in a terminal window; soffice.bin is consuming lots of CPU while the spreadsheet is "idle"
(it stops only when the macro pops up the "called X times" dialog every so often)
Reproduced using Libre Office 3.3.2 (Ubuntu package 1:3.3.2-1ubuntu5)
You must enable macro execution when loading the file to see the problem. Running the macro once by hand does not show the problem; the problem is that libre-office runs the macro thousands and thousands of times whether you like it or not when macros are enabled.
TO REPRODUCE:
localc -nologo Options- >Security- >MacroSecurity. ..
Tools->
Set "Medium" (Confirmation required)
Click OK, OK, File->Exit.
cd ~/Desktop && wget https:/ /bugs.launchpad .net/ubuntu/ +source/ openoffice. org/+bug/ 586599/ +attachment/ 1407325/ +files/ ooCPUbug. ods && localc -nologo ooCPUbug.ods
Answer "Enable Macros" when prompted
RESULTS:
A message box "a MYFUNC called X times.." appears. Click OK every time it appears.
Wait at least 30 seconds! You should see at least hundreds of calls...
Run "top" in a terminal window; soffice.bin is consuming lots of CPU while the spreadsheet is "idle"
(it stops only when the macro pops up the "called X times" dialog every so often)
Reproduced using Libre Office 3.3.2 (Ubuntu package 1:3.3.2-1ubuntu5)