Issue 122810 - Tools-Options-OpenOffice-Security-Macro security crashes OpenOffice 4.0.0 under Vista
Summary: Tools-Options-OpenOffice-Security-Macro security crashes OpenOffice 4.0.0 und...
Status: CONFIRMED
Alias: None
Product: General
Classification: Code
Component: security (show other issues)
Version: 4.0.0
Hardware: PC Windows Vista
: P3 Normal with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: crash, regression
Depends on:
Blocks:
 
Reported: 2013-07-23 17:09 UTC by David Koch
Modified: 2014-02-28 13:10 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description David Koch 2013-07-23 17:09:11 UTC
When I attempted to lower the default security setting under Tools-Options-OpenOffice-Security-Macro security, I get the message: "Due to an unexpected error, OpenOffice crashed. . . ."  This occurred using the basic icon to open basic framework, and also from withing Text Document and Spreadsheet.  This occurred under Windows Vista OS, but NOT under Win7 (64 bit) where operation was correct.
Comment 1 vitriol 2013-07-23 17:47:20 UTC
Duplicate of Bug 115523 and possible user profile problem?
Comment 2 Ariel Constenla-Haile 2013-07-23 17:53:53 UTC
(In reply to vitriol from comment #1)
> Duplicate of Bug 115523 and possible user profile problem?

This one is from 2010. It is likely that code and other things have changed a lot.
Comment 3 Mauro Bigi 2013-07-26 15:24:09 UTC
Got exactly the same problem under Vista Business 32-bit, not under XP SP3 Pro.
What can I do next?
Comment 4 Ariel Constenla-Haile 2013-07-26 16:32:43 UTC
@David Koch
@mb@audiomatica.com

Is this a regression compared to 3.4.*?
Comment 5 chris 2013-07-27 07:20:45 UTC
I have the same problem. OS Windows 7 Prof. SP1 32 Bit.
Comment 6 Mauro Bigi 2013-07-27 07:58:12 UTC
Yes.
I had installed 3.4.* on the same Vista machine and it worked.
As I manage several workstations with several OSes and I need a
Calc spreadsheet with macro to run, I remember in the past versions
of OO a similar problem but I can't help exactly....

(In reply to Ariel Constenla-Haile from comment #4)
> @David Koch
> @mb@audiomatica.com
> 
> Is this a regression compared to 3.4.*?
Comment 7 Ariel Constenla-Haile 2013-07-27 08:28:10 UTC
Setting REGRESSION keyword
Comment 8 Mauro Bigi 2013-07-27 09:21:32 UTC
Is there any workaround?
I.e. is it possible to set the security level without
pressing that damned button and crashing OO? :-)

(In reply to Ariel Constenla-Haile from comment #7)
> Setting REGRESSION keyword
Comment 9 Ariel Constenla-Haile 2013-07-27 10:24:19 UTC
(In reply to Mauro Bigi from comment #8)
> Is there any workaround?
> I.e. is it possible to set the security level without
> pressing that damned button and crashing OO? :-)

You have to change the configuration registry.
Shutdown OpenOffice
Locate the file registrymodifications.xcu inside the user directory ( The user folder is located in Documents and Settings\<your
account>\AppData\Roaming\OpenOffice.org\3\. It is a hidden folder, you might
need to set the explorer to show hidden files.)

registrymodifications.xcu is a plain XML text, utf-8 encoded. You have to edit with a proper editor (NotePad might not work, NotePad++ is better).

Before making any changes, do a back-up.

Search in that file for MacroSecurityLevel. If you find it, change the value. If you don't find it, you have to add the configuration item:

<item oor:path="/org.openoffice.Office.Common/Security/Scripting">
  <prop oor:name="MacroSecurityLevel" oor:op="fuse">
     <value>0</value>
  </prop>
</item>

<value>0</value> has the value 0 in this case. You can change it to:

0 = Lower
1 = Medium
2 = High
3 = Very high
Comment 10 Mauro Bigi 2013-07-29 07:07:35 UTC
It worked perfectly in my Vista machine which is now running
my calc sheet properly. Thank you so much.

(In reply to Ariel Constenla-Haile from comment #9)
> (In reply to Mauro Bigi from comment #8)
> > Is there any workaround?
> > I.e. is it possible to set the security level without
> > pressing that damned button and crashing OO? :-)
> 
> You have to change the configuration registry.
> Shutdown OpenOffice
> Locate the file registrymodifications.xcu inside the user directory ( The
> user folder is located in Documents and Settings\<your
> account>\AppData\Roaming\OpenOffice.org\3\. It is a hidden folder, you might
> need to set the explorer to show hidden files.)
> 
> registrymodifications.xcu is a plain XML text, utf-8 encoded. You have to
> edit with a proper editor (NotePad might not work, NotePad++ is better).
> 
> Before making any changes, do a back-up.
> 
> Search in that file for MacroSecurityLevel. If you find it, change the
> value. If you don't find it, you have to add the configuration item:
> 
> <item oor:path="/org.openoffice.Office.Common/Security/Scripting">
>   <prop oor:name="MacroSecurityLevel" oor:op="fuse">
>      <value>0</value>
>   </prop>
> </item>
> 
> <value>0</value> has the value 0 in this case. You can change it to:
> 
> 0 = Lower
> 1 = Medium
> 2 = High
> 3 = Very high
Comment 11 chris 2013-07-29 07:18:32 UTC
(In reply to Ariel Constenla-Haile from comment #9)
> (In reply to Mauro Bigi from comment #8)
> > Is there any workaround?
> > I.e. is it possible to set the security level without
> > pressing that damned button and crashing OO? :-)
> 
> You have to change the configuration registry.
> Shutdown OpenOffice
> Locate the file registrymodifications.xcu inside the user directory ( The
> user folder is located in Documents and Settings\<your
> account>\AppData\Roaming\OpenOffice.org\3\. It is a hidden folder, you might
> need to set the explorer to show hidden files.)
> 
> registrymodifications.xcu is a plain XML text, utf-8 encoded. You have to
> edit with a proper editor (NotePad might not work, NotePad++ is better).
> 
> Before making any changes, do a back-up.
> 
> Search in that file for MacroSecurityLevel. If you find it, change the
> value. If you don't find it, you have to add the configuration item:
> 
> <item oor:path="/org.openoffice.Office.Common/Security/Scripting">
>   <prop oor:name="MacroSecurityLevel" oor:op="fuse">
>      <value>0</value>
>   </prop>
> </item>
> 
> <value>0</value> has the value 0 in this case. You can change it to:
> 
> 0 = Lower
> 1 = Medium
> 2 = High
> 3 = Very high

This Workaround works perfekt with Windows 7.
Thanks
Comment 12 Rob Weir 2013-07-29 18:00:04 UTC
Confirmed, but with a manual workaround
Comment 13 chris 2013-07-31 10:33:56 UTC
The crash occurs only if you have taken your settings from an older Version of AOO. If you delete the registrymodifications.xcu (You will lost your individual settings) in the profilfolder an restart AOO then you can change the macrosecuritylevel.
Comment 14 Andre 2014-02-28 13:10:11 UTC
Can anybody provide a registrymodifications.xcu that does crash OO?