OpenOffice 3

[Robert L. Inglis]

Recommend updating OpenOffice to ver-3. I compiled the suite using a modification of existing OO-2 instructions, see attachments. I could not use the existing Xulrunner-1.9.1.7 installation due to it being "too-new" and had to use Mozilla-1.7.5 built in the OO3 source tree. I also used JDK-6u17. I could not use any system "Mozilla" ldap and had to install openldap.

[DJ Lucas]

I'm curious, do you use ThunderBird? If so, what is the result of trying to do a mail merge, or envelope, or such? The third and fourth paragraphs at ​http://blog.worldlabel.com/2009/creating-an-invoicing-system-with-openofficeorg.html discuss how to setup the address source. If not, there is still hope, go-oo is usually my first stop for patches, but it'll be quite a while before *I* get to it. Any help that the community can provide will be much appreciated.

[Robert L. Inglis]

Replying to dj@…:

I'm curious, do you use ThunderBird? If so, what is the result of trying to do a mail merge, or envelope, or such? The third and fourth paragraphs at ​http://blog.worldlabel.com/2009/creating-an-invoicing-system-with-openofficeorg.html discuss how to setup the address source. If not, there is still hope, go-oo is usually my first stop for patches, but it'll be quite a while before *I* get to it. Any help that the community can provide will be much appreciated.

Yes I use Thunderbird but never tried to do a mail-merge in OO. My main objective here was to get OO3 to compile successfully and installed. I needed a word-processor and spreadsheet program and I prefer not to build Gnome (can never get it to work well--unlike KDE).

[DJ Lucas]

Replying to ringlis:

Yes I use Thunderbird but never tried to do a mail-merge in OO. My main objective here was to get OO3 to compile successfully and installed. I needed a word-processor and spreadsheet program and I prefer not to build Gnome (can never get it to work well--unlike KDE).

Well if you have the time to try a simple envelope or something to that effect, that would be great, but if not, no biggie. The updated instructions that you've provided are much appreciated and should get somebody far enough along to try it out and get it updated. On the Gnome front, the number of packages will be reduced considerably come 2.30/3.0, *presumably* making things much easier, but I doubt that is relevant to a KDE fan! ;-)

[Robert L. Inglis]

Replying to dj@…:

Replying to ringlis:

Yes I use Thunderbird but never tried to do a mail-merge in OO. My main objective here was to get OO3 to compile successfully and installed. I needed a word-processor and spreadsheet program and I prefer not to build Gnome (can never get it to work well--unlike KDE).

Well if you have the time to try a simple envelope or something to that effect, that would be great, but if not, no biggie. The updated instructions that you've provided are much appreciated and should get somebody far enough along to try it out and get it updated. On the Gnome front, the number of packages will be reduced considerably come 2.30/3.0, *presumably* making things much easier, but I doubt that is relevant to a KDE fan! ;-)

Used both in the past (KDE/Gnome) always preferred KDE. KDE4 looks nice but also looks like a possible dependency hair-ball. I read that Gnome 3 was due out this year. I might have to take a look at it.

On this LFS-SVN build I'm trying out Xfce-4.6.1 with Slim as graphical login manager. Xfce4 seems alot more functional than I remember.

[Robert L. Inglis]

Replying to ringlis:

Recommend updating OpenOffice to ver-3. I compiled the suite using a modification of existing OO-2 instructions, see attachments. I could not use the existing Xulrunner-1.9.1.7 installation due to it being "too-new" and had to use Mozilla-1.7.5 built in the OO3 source tree. I also used JDK-6u17. I could not use any system "Mozilla" ldap and had to install openldap.

Noticed a nice bug today. It seems the spell checker was not catching any intentionally misspelled words. Nor was it prompting me for corrections using F7. So I did a quick "google" on it, seems this is not uncommon. I downloaded the dictionary for EN_US and proceeded to install it. OpenOffice prompted me with this dictionary is already installed do you wish to overwrite, I did. Now the spell checker functions.

So time to figure out why it didn't see my original dictionary. I found the oxt files in (for my install) /opt/OpenOffice-3.1.1/share/extension/install/(choose your dictionary). Even though I configured for en_US (dict-en) and (dict-en) en_GB, OpenOffice also built dict-fr and dict-es. Whats odd about this is you have to "browse" for your dictionary and install it. Soffice > Tools > Extension Manager > Add.. > Browse to your extension, and install. I assume this added configuration would not be necessary if you ran the installer (which we disable).

The downloaded en_us.oxt shows up in ~/.openoffice.org/3/user/uno_packages/../../ and not in the openoffice-3.1.1/share/extension so the installer overwrite was only within my local config.

Just something to add to the Notes section for this package instructions.

[DJ Lucas]

Don't forget to review Go-oo version as they use a GPL license as opposed to Sun's required SCA.

[willimm]

Replying to dj@…:

Don't forget to review Go-oo version as they use a GPL license as opposed to Sun's required SCA.

Partly not true. The source code is licensed under a LGPLv3 licence, but if you want to contribute, you have to sign the SCA. Then again, Go-oo has it's own fair share of problems:

​http://boycottnovell.com/2008/10/12/microsoft-novell-hijack-openoffice/

[willimm]

Oh, and a new version: 3.2.

[Robert L. Inglis]

Just finished OO-3.2.0 compile - install. About 3hrs with dmake -P8 on AMD Phemon II 955.

Had to download OOo_3.2.0_src_testautomation and include it in the build. The first dmake stopped asking for this. I did not see any configure option to remove this dependency.

Openoffice 3.2.0 now uses Seamonkey-1.1.14 vs Mozilla-1.7.5.

Had to remove --with-system-neon due to make error with undefined reference to XML Parser Close. Re-ran configure - bootstrap - source and dmake. Compiled w/o error this round.

Otherwise essentially the same build as OO 3.1.1. Same install directories /opt/openoffice<ver>/{openoffice.org,openoffice.org3}.

This time it did install the dictionary's. I did not have a previous ~/.openoffice.org but once again it built fr, es, along with en. After reading the OO wiki it seems the --with-lang configure option is omitted to build en only or --with-lang="en" or "en, fr, etc", for multiple language support.

Compiled source size 4.9G.

Have fun

[Nathan Coulson]

I ran into this problem w/ OpenOffice 3.2.1, when using DB 4.8. Looking at configure, this most likely affects older problems as well

checking whether db is at least 4.1... ./configure: line 14866: test: : integer expression expected configure: error: no. you need at least db 4.1

It has problems detecting db versions above 4.7, This is discussed at ​http://www.mail-archive.com/allbugs@openoffice.org/msg450020.html (albet, an older version of configure then I was looking at)

configure, on line 14822, has the following to find the minor version of db (I am using db 4.8)

for v in seq 1 7; do

When I changed it to

for v in `seq 1 9'; do

it was able to continue

using my fabulous knowledge of sed (which I am sure can be improved upon) 'sed -i "s/seq 1 7/seq 1 9/" configure' allows it to continue past configure.

[Nathan Coulson]

Replying to conathan:

I ran into this problem w/ OpenOffice 3.2.1, when using DB 4.8. Looking at configure, this most likely affects older problems as well

checking whether db is at least 4.1... ./configure: line 14866: test: : integer expression expected configure: error: no. you need at least db 4.1

It has problems detecting db versions above 4.7, This is discussed at ​http://www.mail-archive.com/allbugs@openoffice.org/msg450020.html (albet, an older version of configure then I was looking at)

configure, on line 14822, has the following to find the minor version of db (I am using db 4.8)

for v in seq 1 7; do

When I changed it to

for v in `seq 1 9'; do

it was able to continue

using my fabulous knowledge of sed (which I am sure can be improved upon) 'sed -i "s/seq 1 7/seq 1 9/" configure' allows it to continue past configure.

I reported this upstream at ​http://www.openoffice.org/issues/show_bug.cgi?id=112206

[DJ Lucas]

Updated to OpenOffice-3.2.1 in r8605. Have not verified the post-install configuration WRT spell-checking.

[DJ Lucas]

Looks like all that is needed is to reselect from language options inside one of the programs. To do this, clear the "(Default) - English (USA)" and explicitly select "English (USA)"....or other. However, only en, de, and fr (classic) are installed by default (the ones with hyphenation and thesaurus. You'll need to install any additional dictionaries by copying them to from the source tree.

cp -v dictionaries/unxlngi6.pro/bin/dict-*.oxt \
    /opt/openoffice-3.2.1/share/extension/install/

Same thing for other extensions in the following directories:

cp -v sdext/unxlngi6.pro/bin/*.oxt \
    reportbuilder/unxlngi6.pro/bin/report-builder.oxt \
    swext/unxlngi6.pro/bin/wiki-publisher.oxt \
    /opt/openoffice-3.2.1/share/extension/install/

I'm trying to think of a nicer way to add this because the above will exit non-zero if one of the extensions were not built, but I'm not adding five additional code blocks to the instructions.

Finally, re-add all extensions as shared:

for i in /opt/openoffice-3.2.1/share/extension/install/*.oxt
do
    /opt/openoffice-3.2.1/program/unopkg add --shared --verbose $i
done

I used a loop here because it will bomb on the ones that are already installed, it will also require a yes key-press for the extensions that aren't dictionaries. Could probably pipe from yes.

[DJ Lucas]

Fixed in r8606.

[bdubbs@…]

Milestone renamed