SOLVED: libre office and macro security

jancici · Last edited by jancici on Mon Apr 18, 2011 11:37 am; edited 1 time in total

I am not able to change security setting of macro in LibreOffice.

here is thread which did help me with openoffice https://forums.gentoo.org/viewtopic-t-598196-highlight-openoffice+macro.html
but I am not able to find that file when using libreoffice

has anybody solution for this?
I am using macros in spreadsheets, so at this moment I am not able to use libreoffice.

thanks for help / tips

jancici · Posted: Fri Apr 15, 2011 12:00 pm Post subject:

I also enable "enable experimental features" in general tab of Option
not helping to change macro security

onyxnz · n00b Joined: 18 Apr 2011 Posts: 2

Solution...because I came across this bug in Sabayon too:

sudo chmod 777 lib/libreoffice/basis-link/share/registry/main.xcd
geany lib/libreoffice/basis-link/share/registry/main.xcd
(or use whatever text editor you have eg: gedit, kate)
find MacroSecurityLevel using the find feature
change the macro security value to whatever you like following that;
<value>0</value>
0=lowest, 3=highest, 2=default.
save file
sudo chmod 444 lib/libreoffice/basis-link/share/registry/main.xcd

Try out your ODF document with macros.

jancici · Posted: Mon Apr 18, 2011 11:37 am Post subject:

thanks,
it is working now

onyxnz · n00b Joined: 18 Apr 2011 Posts: 2

Great. I have started a Bug Report here: https://bugs.gentoo.org/show_bug.cgi?id=364069

Let's see if we can get this fixed, eh?

sphakka · Tux's lil' helper Joined: 24 Jun 2003 Posts: 79

Grigory Bondarenko · n00b Joined: 27 Apr 2016 Posts: 1

I have LO 5.1 on Ubuntu 12.04 without graphical interface (on server). Tried to change parameter MacroSecurityLevel (<value>_</value>) in main.xcd but it didn't help (Security Level in LO was not change).