openoffice-ximian-1.1.0 [now osbolete]

dmarner · Posted: Sun Oct 19, 2003 2:17 am Post subject:

Has anyone solved the Excel import problem? It's kind of a show stopper for me. For those trying to narrow it down, I am seeing it when importing spreadsheets created in Excel 2002 (XP) into the openoffice-ximian-1.1.0-r2.

I built with minimal optimizations. My locale is POSIX, so I concur that this is probably not a locale related problem.

BTW, my build failed until I upgraded from blackdown-jdk-1.3.1 to blackdown-jdk-1.4.1. This failure happens after a few hours of building, and several other people have mentioned the same issue. I suggest that Suka edits the message at the top of this thread to mention that... It would same some people some time!

Edit: Forgot to say-- thanks for the ebuild!

alwyn · Tux's lil' helper Joined: 21 May 2003 Posts: 140

jack_mort · Apprentice Joined: 30 Jan 2003 Posts: 167

Nylle · Posted: Sun Oct 19, 2003 5:45 pm Post subject:

dmarner · Posted: Sun Oct 19, 2003 10:23 pm Post subject:

The Excel import problem goes away if you build with -O1 or -fno-strict-aliasing. (-O1 implies -fno-strict-aliasing, but I used both.)

This is apparently a known but somewhat unpredictable problem with the base OpenOffice.org. See http://www.openoffice.org/issues/show_bug.cgi?id=21325 this bug report for more info.

I suggest that -fno-strict-aliasing be added the ebuild.

Landonis · n00b Joined: 02 May 2003 Posts: 19 Location: Wales, UK

Firstly - thank you to suka and Nylle for the great ebuild and binary

Secondly - I thought I would mention this in case anyone else got the same problem with 'setup failed' upon running ooffice.
After looking through /usr/bin/ooffice for the setup failed error I could see it ran /opt/OpenOffice/program/setup. Upon running this I got a much more informative message about not being able to find libssl.o.0.9.7 and libcrypto.o.0.9.7 - a quick kludge with a symlink to the current libssl.o and libcrypto.o and it was all working. (After all.. REAL programmers do not update.. we kludge it until it can be released as an update.)

After the lightbulb came on in my head :oops:

it seemed that openssl was out of date (I had 0.9.6 when openoffice 1.1.0 seems to want 0.9.7) and this did not turn up as normal with emerge. A quick 'emerge openssl' and everything is great again!
_________________
Four be the things I am wiser to know:
Idleness, sorrow, a friend, and a foe.

Koon · Retired Dev Joined: 10 Dec 2002 Posts: 518

xlyz · Veteran Joined: 27 Oct 2002 Posts: 1470 Location: Italy

Koon · Retired Dev Joined: 10 Dec 2002 Posts: 518

Lovechild · Posted: Mon Oct 20, 2003 9:56 am Post subject:

I have another one for you:

xlyz · Veteran Joined: 27 Oct 2002 Posts: 1470 Location: Italy

Karny · Posted: Mon Oct 20, 2003 12:20 pm Post subject:

Ok, so gcc 3.3.1 is the problem... what does this mean?

Do I need to downgrade my gcc? Or is this something that can be fixed via a patch?
_________________


Jabber: Karny@jabber.org

masterpe · n00b Joined: 16 Oct 2003 Posts: 4

That findutils patch helped me out

.

Suka: Would it be possible to get your ebuild accepted into the main portage tree?

Stu L Tissimus · Posted: Mon Oct 20, 2003 3:44 pm Post subject:

Out of memory on that system? My laptop did it fine, and it has 128 MB RAM from 1998 and 256 swap... o_O
_________________
old outdated sig

xlyz · Veteran Joined: 27 Oct 2002 Posts: 1470 Location: Italy

masterpe · n00b Joined: 16 Oct 2003 Posts: 4

well, the code that SirJoltaLot posted earlier:

Nadhor · n00b Joined: 03 Feb 2003 Posts: 58 Location: Germany

Is it possible to also include localized help into the openoffice-ximian ebuild, like described here:
http://tools.openoffice.org/dev_docs/build_linux.html#BuildingLocalised ?

projectphoenix · n00b Joined: 20 Oct 2003 Posts: 5 Location: Germany, Bonn

Hm,
I have no success compiling this "beast". First I ran into the xargs error, but the findutils patch solved this problem. But now I have the following problem:

Karny · Posted: Tue Oct 21, 2003 8:02 am Post subject:

K, just to let you know... finally got r2 to build.

Copy & paste in oocalc seems to work, haven't tested Excel import yet tho.

SirJoltalot's finutils patch did the trick with my xargs issues and using the following:

Portage 2.0.49-r13 (default-x86-1.4, gcc-3.3.1, glibc-2.3.2-r6, 2.4.23-pre6aa3)
=================================================================
System uname: 2.4.23-pre6aa3 i686 Intel(R) Pentium(R) 4 CPU 2.66GHz
Gentoo Base System version 1.4.3.11
ACCEPT_KEYWORDS="x86 ~x86"
CFLAGS="-march=pentium4 -O2 -pipe -fomit-frame-pointer -fno-strict-aliasing"
CXXFLAGS="-march=pentium4 -O2 -pipe -fomit-frame-pointer -fno-strict-aliasing"
DISTDIR="/usr/portage/distfiles"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTDIR_OVERLAY="/usr/local/portage"
USE="oss apm avi crypt encode foomaticdb libg++ mad mikmod ncurses nls pdflib xml2 xmms xv zlib gdbm berkdb slang readline arts bonobo svga tcltk java guile mysql sdl gpm tcpd pam libwww ssl perl python imlib oggvorbis qt kde motif gtk2 gtkhtml samba tiff usb xine cdr cups esd gif gnome gtk jpeg mpeg png quicktime spell truetype X x86 opengl -nptl"

Thanks to everyone for all the tips!
_________________


Jabber: Karny@jabber.org

Koon · Retired Dev Joined: 10 Dec 2002 Posts: 518

ecatmur · Posted: Tue Oct 21, 2003 7:20 pm Post subject:

Thanks everyone! I now have a beautiful oOo working fine, after downgrading gcc to 3.2 and applying the findutils patch.
Also - somewhat puzzling - I ran into the java problem even though I've only ever had blackdown-jdk-1.4.1 installed. However, running java-config set-system-vm=blackdown-jdk-1.4.1 seemed to fix it and it compiled OK after that.

teilo · Posted: Tue Oct 21, 2003 9:56 pm Post subject:

This is just a hint for those of you on gcc 3.3.1.

You can have both 3.2.3 and 3.3.1 installed, if you edit the 3.3.1 ebuild, and change the following lines:

Lovechild · Posted: Wed Oct 22, 2003 10:02 am Post subject:

it seems OOo dislikes sun-j2sdk, sigh - after I spend hours compiling it... it's just unfair.

suka · Developer Joined: 22 Apr 2002 Posts: 383

Just a note for all the people who had to alter findutils to get openoffice to compile: There is now an update for findutils in portage which aims to solve the problem