[Solved] LibreOffice - OpenOffice - Which one to use?

Not sure where to post? Post here!

[Solved] LibreOffice - OpenOffice - Which one to use?

Postby pizzipie » Sat Jul 18, 2015 11:21 pm

Hi,

Using Ubuntu for years. Now I'm using v. 14.04.

I quite happily used OpenOffice a number of years ago. Then, to my disappointment, OpenOffice was gone and LibreOffice popped up,. Now I see from trying to use Base with LibreOffice I am directed to the Apache OpenOffice site. I don't care which application I use, but I want to use Base to access my MySql Databases and to write reports. I have openoffice-tar/Apache_OpenOffice_4.1.1_Linux_x86-64_install-deb_en-US.tar.gz downloaded and ready to install. I am a little afraid to try this as I've got LibreOffice operating and am able to use Base with the report function. These programs seem tricky to get running correctly.

Any advantage to switch back to OpenOffice? Does the Oracle Report Writer extension work in LibreOffice?

I would appreciate any help in enlightening me.

R
Last edited by Hagar Delest on Sat Jul 25, 2015 6:57 pm, edited 1 time in total.
Reason: tagged solved
LibreOffice Version: 5.0.5.2 - Using Ubuntu 14.04 - MySql and PHP
pizzipie
 
Posts: 39
Joined: Sat Sep 13, 2008 2:28 am

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby RoryOF » Sun Jul 19, 2015 12:52 am

If LibreOffice is installed and working I doubt there is anything to be gained by changing to OpenOffice. Because of the common code base the
functionality is largely the same and you should be able to apply OO methods to LibO with minimal or no changes.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29454
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby pizzipie » Sun Jul 19, 2015 1:26 am

Thanks RoryOF,

So should I use Oracle Report Writer extension in LibO?

R
LibreOffice Version: 5.0.5.2 - Using Ubuntu 14.04 - MySql and PHP
pizzipie
 
Posts: 39
Joined: Sat Sep 13, 2008 2:28 am

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby RoryOF » Sun Jul 19, 2015 8:17 am

I don't use databases, so someone with experience will have to answer that specific point.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29454
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby Villeroy » Sun Jul 19, 2015 2:21 pm

Recent versions of LibreOffice include the report builder as built-in component. It is not a removeable add-on anymore. Old style reports are still opened but there is no way to create them. I rarely use the report builder (too complicated for my needs). I prefer quick reports and pivot tables on spreadsheets: [Tutorial] Using registered datasources in Calc.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27111
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby Villeroy » Sun Jul 19, 2015 2:45 pm

If you want to have use both programs on a Linux system, the LibreOffice from the Ubuntu repository and OpenOffice, you need to install OpenOffice with the --force-overwrite switch. It will replace the symlink /usr/bin/soffice pointing to the LO executable with a symlink that points to the OpenOffice executable. Of course you can change the symlink manually but without using the switch, there is a conflict and OpenOffice won't be installed.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27111
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby RoryOF » Sun Jul 19, 2015 2:52 pm

To be frank, I think one is probably as good as the other, at least until one starts doing very complex things (if one ever does), when one might be preferable for convenience for that complexity. I think the OP should use his installed LibreOffice until it doesn't do what he wants. Time then to consider whether to change.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29454
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby Villeroy » Sun Jul 19, 2015 4:14 pm

RoryOF wrote:To be frank, I think one is probably as good as the other, at least until one starts doing very complex things (if one ever does), when one might be preferable for convenience for that complexity. I think the OP should use his installed LibreOffice until it doesn't do what he wants. Time then to consider whether to change.

+1

LO tries harder to support foreign file formats. The results are not always satisfying. Too many new LO features are not well thought and/or badly implemented. On the other hand Apache OpenOffice seems to be stable in terms of no longer pushed forward.
The one and only matter of importance full ODF support.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27111
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby pizzipie » Thu Jul 23, 2015 7:20 pm

Thank you Villeroy,

I may be having a brain fart but; The one and only matter of importance full ODF support. what is ODF.

Do you think Apache OpenOffice will stay around now? It seems to have more support, or am I wrong?

R
LibreOffice Version: 5.0.5.2 - Using Ubuntu 14.04 - MySql and PHP
pizzipie
 
Posts: 39
Joined: Sat Sep 13, 2008 2:28 am

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby RoryOF » Thu Jul 23, 2015 7:31 pm

OpenOffice will stay around, I think. Hopefully the division between OO and LibO will be healed in the future.

ODF format means Open Document Format and is hopefully the format towards which many government departments and International organisations are moving. Although Microsoft claims to support these formats, its versions of the formats are very idiosyncratic and may not conform to the standard.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29454
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby pizzipie » Fri Jul 24, 2015 1:06 am

[SOLVED] :D

Thank you RoryOf and all others.

Guess I'll stick with LO for now.

R
LibreOffice Version: 5.0.5.2 - Using Ubuntu 14.04 - MySql and PHP
pizzipie
 
Posts: 39
Joined: Sat Sep 13, 2008 2:28 am

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby esperantisto » Fri Jul 24, 2015 8:48 am

RoryOF wrote:To be frank, I think one is probably as good as the other…


No. Apache OpenOffice is much more stable, especially when handling large files (both text and spreadsheets). I need to process a bunch of files that have lots of linked pictures inside and LO immediately crashes when trying to load such a file while AOO does not. In LO Calc, I can’t properly set a language for cell text: it seems to set, but the spellcheck still underlines everything as mistakes (no matter what language). No problem with AOO Calc. LO seems to have a broken StarBasic engine, and some extensions do not work (notably, Template Changer, a very useful Writer extension).

In short, when stability is critical, I use AOO. Actually, I use AOO for everything except the cases when I need better compatibility of text documents with M$ Office Word (in fact, the compatibility is better with LO only for page numbering, other things are largely equally good or equally bad in both AOO and LO).
AOO 4.2.0 / LibO 5.x/6.x / Win 7 / openSUSE Linux 11.3 (32-bit) / 13.2 (64-bit)
esperantisto
Volunteer
 
Posts: 489
Joined: Mon Oct 08, 2007 1:31 am

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby RoryOF » Fri Jul 24, 2015 9:27 am

I was thinking in terms of use of the suites by an inexperienced user, at the level such a user might require.

I only use OpenOffice; my main use is for writing and editing - in the latter case some very large files. It is extremely stable, but that may reflect the stability of my operating system. I have looked (briefly) at LibreOffice but disliked some changes in the appearance of the editing screens. Reports are also that LibO is slightly less stable than OO, so I have no incentive to change. MS Office compatibility does not concern me as I handle any printing myself.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29454
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: LibreOffice - OpenOffice - Confused as to which one to

Postby pizzipie » Fri Jul 24, 2015 11:09 pm

Thanks, esperantisto and RoryOF,

I thought I was done with this but... You've got me thinking again (always dangerous).

I use OO and/or LO for all my spreadsheets and document writing. My present interest is in accessing MySql for the purpose of writing reports.

I don't know why, but my gut feeling is that it might be best if I went with OO using Base and with the Oracle Report Writer extension.

I started with Star Office so have some experience with all three of these applications. I am far far from an expert but have managed to get them all running at one time or another.

SOOOO! Give me a push in one direction or the other.

Thanks,

R
LibreOffice Version: 5.0.5.2 - Using Ubuntu 14.04 - MySql and PHP
pizzipie
 
Posts: 39
Joined: Sat Sep 13, 2008 2:28 am

Re: [Solved] LibreOffice - OpenOffice - Which one to use?

Postby pizzipie » Sat Jul 25, 2015 11:11 pm

Well I jumped in and almost drowned!!!

Purged LibreOffice installed OpenOffice. Open Office crashes every other minute so I purged it and back to LibreOffice.

I'm going to post results and questions inanother forum on that.

So thanks all, R
LibreOffice Version: 5.0.5.2 - Using Ubuntu 14.04 - MySql and PHP
pizzipie
 
Posts: 39
Joined: Sat Sep 13, 2008 2:28 am

Re: [Solved] LibreOffice - OpenOffice - Which one to use?

Postby pizzipie » Sun Jul 26, 2015 3:25 am

Last reply, I promise.

Couldn't get report writer, in the Ubuntu version of LO, to use design mode. Dumped it and downloaded LibreOffice 4.4.4.3 and CHEERS, It all works.

I'm done, staying with current installation of LO.

BYE!!!

R
LibreOffice Version: 5.0.5.2 - Using Ubuntu 14.04 - MySql and PHP
pizzipie
 
Posts: 39
Joined: Sat Sep 13, 2008 2:28 am

Re: [Solved] LibreOffice - OpenOffice - Which one to use?

Postby RusselB » Sun Jul 26, 2015 5:28 am

I'd like to recommend that you update your forum signature to reflect which office product and which version you are using.
You can do this by clicking on the User Control Panel link located near the top left of the page.
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5406
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Beginners

Who is online

Users browsing this forum: No registered users and 3 guests