Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 244917 - app-office/openoffice-3.0.0 - macro security dialog missing
Summary: app-office/openoffice-3.0.0 - macro security dialog missing
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: High normal (vote)
Assignee: Gentoo Office Team
URL:
Whiteboard:
Keywords:
: 364069 (view as bug list)
Depends on:
Blocks:
 
Reported: 2008-10-29 20:01 UTC by Joseph
Modified: 2011-07-06 22:18 UTC (History)
4 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments
openoffice-3.0 build part-1 (xaa,1.91 MB, text/plain)
2008-10-30 14:06 UTC, Joseph
Details
openoffice-3.0 build part-2 (xab,1.91 MB, text/plain)
2008-10-30 14:07 UTC, Joseph
Details
openoffice-3.0 build part-3 (xac,1.91 MB, text/plain)
2008-10-30 14:08 UTC, Joseph
Details
openoffice-3.0 build part-4 (xad,1.91 MB, text/plain)
2008-10-30 14:08 UTC, Joseph
Details
openoffice-3.0 build part-5 (xae,1.91 MB, text/plain)
2008-10-30 14:09 UTC, Joseph
Details
openoffice-3.0 build part-6 (xaf,724.37 KB, text/plain)
2008-10-30 14:09 UTC, Joseph
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Joseph 2008-10-29 20:01:18 UTC
In Gentoo compiled OpenOffice menu:
Tools - Options - OpenOffice.org - Security - Macro Security 

Dialog is missing.


Reproducible: Always




emerge --info
Portage 2.1.4.5 (default/linux/amd64/2008.0/desktop, gcc-4.1.2, glibc-2.6.1-r0, 2.6.25-gentoo-r7 x86_64)
=================================================================
System uname: 2.6.25-gentoo-r7 x86_64 Intel(R) Core(TM)2 Quad CPU Q9550 @ 2.83GHz
Timestamp of tree: Tue, 28 Oct 2008 20:04:01 +0000
app-shells/bash:     3.2_p33
dev-java/java-config: 1.3.7, 2.1.6
dev-lang/python:     2.5.2-r7
sys-apps/baselayout: 1.12.11.1
sys-apps/sandbox:    1.2.18.1-r2
sys-devel/autoconf:  2.13, 2.61-r2
sys-devel/automake:  1.5, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.1-r1
sys-devel/binutils:  2.18-r3
sys-devel/gcc-config: 1.4.0-r4
sys-devel/libtool:   1.5.26
virtual/os-headers:  2.6.23-r3
ACCEPT_KEYWORDS="amd64"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=nocona -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/lib/fax /usr/share/config /var/lib/hsqldb /var/spool/fax/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c /etc/udev/rules.d"
CXXFLAGS="-march=nocona -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="ccache distlocks metadata-transfer parallel-fetch sandbox sfperms strict unmerge-orphans userfetch"
GENTOO_MIRRORS="ftp://ftp.gtlib.gatech.edu/pub/gentoo http://linux.rz.ruhr-uni-bochum.de/download/gentoo-mirror"
LDFLAGS="-Wl,-O1"
LINGUAS="en"
MAKEOPTS="-j6 -l8"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/portage/local/layman/voip /usr/portage/local/layman/sipx"
SYNC="rsync://10.0.0.101/gentoo-portage"
USE="X acl acpi alsa amd64 apache2 berkdb bluetooth branding bzip2 cairo cdr cgi cli cracklib crypt cups dbus dri dvd dvdr dvdread eds emboss encode esd evo fam firefox foomaticdb fortran gdbm gif gimp gimpprint gpm gstreamer gtk hal iconv ipv6 isdnlog java jpeg kde kerberos ldap libnotify mad midi mikmod mmx mp3 mpeg mudflap multilib mysql ncurses nls nptl nptlonly ogg opengl openmp pam pcre pdf perl png ppds pppd python qt3 qt3support quicktime readline reflection scanner sdl session spell spl sse sse2 ssl startup-notification svg sysfs tcpd tetex tiff truetype type1 unicode usb vorbis xml xorg xv zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en" USERLAND="GNU" VIDEO_CARDS="nv vesa"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 1 Wormo (RETIRED) gentoo-dev 2008-10-29 23:30:17 UTC
"Gentoo compiled OpenOffice" -- do you mean openoffice-3.0.0 compiled on your own system, or openoffice-bin-3.0.0?
Comment 2 Joseph 2008-10-30 00:01:24 UTC
openoffice-bin-3.0.0 works OK, problem is with compiled version (openoffice-3.0.0 compiled on my own system).

I have a macro, in my spreadsheet and can not enable it by going to:
Tools - Options - OpenOffice.org - Security - Macro Security (nothing pops-up).

I found a work around, one need to edit file
...ooo3/user/registry/data/org/openoffice/Office/Common.xcu

try to find this section in it and change value, if you are missing all section then insert it:

<node oor:name="Security">
  <node oor:name="Scripting">
   <prop oor:name="MacroSecurityLevel" oor:type="xs:int">
    <value>1</value>
   </prop>
  </node>
</node>

The selection from Tools-options ... still doesn't work but I can run my macro. 
Comment 3 Wormo (RETIRED) gentoo-dev 2008-10-30 01:16:45 UTC
Interesting that it works in openoffice-bin but not locally compiled openoffice... how about attaching the log from when you built openoffice, in case there are any hints of non-fatal build errors that could cause this problem?
Comment 4 Joseph 2008-10-30 01:38:54 UTC
OpenOffice-3.0.0 compiled OK here is the emerge log:

>>> emerge (1 of 1) app-office/openoffice-3.0.0 to /
=== (1 of 1) Cleaning (aapp-office/openoffice-3.0.0::/usr/portage/app-office/openoffice/openoffice-3.0.0.ebuild)
=== (1 of 1) Compiling/Merging (app-office/openoffice-3.0.0::/usr/portage/app-office/openoffice/openoffice-3.0.0.ebuild)
>>> AUTOCLEAN: app-office/openoffice
=== Unmerging... (app-office/openoffice-2.4.1)
>>> unmerge success: app-office/openoffice-2.4.1
=== (1 of 1) Post-Build Cleaning (app-office/openoffice-3.0.0::/usr/portage/app-office/openoffice/openoffice-3.0.0.ebuild)
::: completed emerge (1 of 1) app-office/openoffice-3.0.0 to /
*** Finished. Cleaning up...
*** exiting successfully.
*** terminating.

but I'm not the only one the noticed it, here is a link to the forum, showing that other folks have the same problem:
http://forums.gentoo.org/viewtopic-t-598196-highlight-openoffice+macro.html

In addition to that, the problem with grid line is still present in Gengoo-compiled-OpenOffice as I reported earlier (binary version doesn't have this problem):
http://bugs.gentoo.org/show_bug.cgi?id=219351

I did not file but with OpenOffice as this is not their problem, it is local problem with Gentoo compiled version.  

Maye the solution is to ditch the Gentoo compiled version and go with binary only.  Binary version works OK and we have enough Bugs in Gentoo.

Comment 5 Wormo (RETIRED) gentoo-dev 2008-10-30 05:00:41 UTC
Actually I was hoping for the full build log found in $PORT_LOGDIR/app-office:openoffice-3.0.0.*.log (where often PORT_LOGDIR=/var/log/portage), since emerge.log doesn't have any details in it. Do you have that available? I didn't see anybody post any detailed build logs in the forum thread.
Comment 6 Joseph 2008-10-30 14:06:12 UTC
Created attachment 170307 [details]
openoffice-3.0 build part-1

Here are the attachment, it is a large file so I had to split into 6-pieces
Comment 7 Joseph 2008-10-30 14:07:29 UTC
Created attachment 170308 [details]
openoffice-3.0 build part-2
Comment 8 Joseph 2008-10-30 14:08:13 UTC
Created attachment 170309 [details]
openoffice-3.0 build part-3
Comment 9 Joseph 2008-10-30 14:08:50 UTC
Created attachment 170311 [details]
openoffice-3.0 build part-4
Comment 10 Joseph 2008-10-30 14:09:25 UTC
Created attachment 170313 [details]
openoffice-3.0 build part-5
Comment 11 Joseph 2008-10-30 14:09:45 UTC
Created attachment 170315 [details]
openoffice-3.0 build part-6
Comment 12 Alexandre Ghisoli 2008-11-18 14:44:06 UTC
I'm facing to the same issue.

And thanks for Comment #2, it saves my day !
Comment 13 Mons Meggela 2009-04-03 15:17:28 UTC
+1
I also have this issue on v 3.0.0.

Since it doesn't seem to be a problem on the -bin version, could it be just a missing use flag?  If so, which one?
Comment 14 Joseph 2009-04-03 17:45:39 UTC
Not I've compiled version 3.0
Build 3.0.0.3.6
and "Security" option is there; so I think we can mark it as solved.
Comment 15 Joseph 2009-04-20 04:29:16 UTC
I just recompiled OpenOffice on Build: Build 3.0.0.3.6
and still the same problem.  
MiroSecurity button is there but clicking on it does nothing and I can not run my macro. 
Comment 16 Jakub Klawiter 2009-05-15 07:59:22 UTC
I have same problem here both for openoffice-3.0.0 and 3.0.1
Comment 17 Jakub Klawiter 2009-05-15 09:54:53 UTC
my workaround is:

# quickpkg openoffice
# emerge -aC openoffice
# emerge -av openoffice-bin
change the macro security settings
# emerge -aC openoffice-bin
# emerge -avk openoffice

Maybe it is somewhere in USE flags? 
I have openoffice build with:
cups dbus eds gnome gstreamer gtk ldap linguas_en linguas_pl opengl pam

-binfilter -debug -elibc_FreeBSD -java -kde -mono -nsplugin -odk -templates

maybe it is because i have java turned off. Can anyone check it (compiling OO.o here takes 5h+ of time). I'll try to compile with java support today night. 
Comment 18 Yar Odin 2009-05-15 14:19:11 UTC
Your problem at nsplugin flag, when oo compiled without it - macro dialogue disappeared.
It deals with cert  works throught mozilla stuff.
Comment 19 Andreas Proschofsky (RETIRED) gentoo-dev 2009-11-25 12:41:33 UTC
Works for me just fine nowadays, dialog is there. Closing. Please reopen if you tried to rebuild with the nsplugin use flag and still get the problem
Comment 20 Andreas Proschofsky (RETIRED) gentoo-dev 2011-07-06 22:18:38 UTC
*** Bug 364069 has been marked as a duplicate of this bug. ***