[Solved] OpenOffice vs LibreOffice

Not sure where to post? Post here!

[Solved] OpenOffice vs LibreOffice

Postby Jennifer Murphy » Sun Aug 15, 2021 1:07 am

Are OpenOffice and LibreOffice two different products? How do they differ?

I'm brand new here. I don't have either. I am looking for a tool that can create fillable PDF forms from a MS Word or Excel file.

Thanks,

-j
Last edited by robleyd on Wed Aug 18, 2021 1:55 am, edited 2 times in total.
Reason: Add green tick
OpenOffice 4.1 on Windows 10
Jennifer Murphy
 
Posts: 2
Joined: Sun Aug 15, 2021 1:02 am

Re: OpenOffice vs LibreOffice

Postby RusselB » Sun Aug 15, 2021 5:28 am

Welcome to the Forums
OpenOffice and LibreOffice are two different products.
There are many differences between the two, but there are more similarities than differences.
I do not claim to know all of the differences, but even the ones I know of would take up more time to write than to try to answer question(s) regarding specific aspects of each.
LibreOffice has a higher compatibility with M$Office formats than OpenOffice does and LibreOffice also has a higher level of active development.
LibreOffice is a fork from the original OpenOffice, so they share a lot of the same code.

As to a Fillable PDF form, I'd recommend using a proper PDF program, like Adobe Creator.
I've never tried to make a PDF using either LibreOffice or OpenOffice, thus I cannot state if either one is even capable of creating a fillable PDF form.
Another user may be able to provide that information.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
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: 6459
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: OpenOffice vs LibreOffice

Postby Villeroy » Sun Aug 15, 2021 12:48 pm

https://en.wikipedia.org/wiki/LibreOffice
Long story short: https://www.libreoffice.org/discover/li ... penoffice/

LibreOffice was forked from OpenOffice 3.3 because OpenOffice was about to become homeless. OpenOffice 3.3 and LibreOffice 3.3 were identical products except from the blue/green branding. OpenOffice found a new home under the roof of the Apache foundation. SInce 2015 it has become clear that OpenOffice is dying under that roof because all relevant developers and other volunteers switched over to the more attractive project. OpenOffice releases tiny little updates once a year and recently it had to fix updates because they were broken because there are not even enough voluteers to test the entire product on each supported platform.

Contrary to that, LibreOffice can get on someones nerves because its quality management is not good enough for the pace of development and quite obviously, there is a group of people who constantly mess up the menues with never ending "good ideas".
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30156
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: OpenOffice vs LibreOffice

Postby Lupp » Sun Aug 15, 2021 4:08 pm

Jennifer Murphy wrote:Are OpenOffice and LibreOffice two different products? How do they differ?
I'm brand new here. I don't have either. I am looking for a tool that can create fillable PDF forms from a MS Word or Excel file.

If you need compatibility to MS sellware or rentware, and in specific if you also need to work with .OOXML formatted files, you should be better off with LibreOffice. LibO can even write such files. (NOT recommended, however!)

Concerning fillabel forms:
1. LibO can create them. I never tied With OOo, AOO.
2. The next step will be done by any brand of pdf software ( a "Reader"). You or your clients need to use one supporting the filling.
(I don't know if all of them do. LibO can't be used for the purpose.)
3. Forms are basically made to connect to a database. If you want to do so, you will need to know a lot more than you have asked for.

The attached example was made "on the fly" with LibO, and the fields were filled after the export to pdf using "Foxit Reader". You can open it with your reader, and most likely change the fields. No connection to a DB contained.

Your question mainly is about export to pdf. You should consider to add something like "(concerning export to pdf-forms)"
The other aspects were already covered by answers above.
Attachments
fillable.pdf
(30.41 KiB) Downloaded 87 times
On Windows 10: LibreOffice 7.2 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 3135
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: OpenOffice vs LibreOffice

Postby sveld » Mon Aug 16, 2021 8:43 am

LibreOffice is really good maintained, with also a lot of enhancements is the compatibility with Microsoft documents (docx, etc). For creating fillable PDF that should not matter and you could use the OpenDocument format (odt, etc) as well, whatever you prefer. There are also a lot of new features in the area of creating, editing and exporting PDF’s in LibreOffice.

A good start for creating fillable PDF’s would be https://www.linuxuprising.com/2019/02/h ... h.html?m=1, doesn’t matter if you use like Windows, MacOS or Linux as the workflow is much the same. Maybe some of the 3th party tooling to view/edit/test may be different as you prefer or available on your platform of choise.
OpenOffice 4.1.10 on Win10, LibreOffice 7.1.4.2 on Win10/Linux, Collabora Office on IOS and Android, Collabora Office Online with Nextcloud
sveld
 
Posts: 11
Joined: Sat Dec 07, 2019 8:33 am
Location: The Netherlands

Re: OpenOffice vs LibreOffice

Postby Villeroy » Mon Aug 16, 2021 11:53 am

A widely unknown feature is the ability to submit forms to http servers.
Create the form.
Add a button with action=submit
Specify the URL where to submit the form.
Test with an ad-hoc html server on localhost:
Code: Select all   Expand viewCollapse view
$ python3 -m http.server 8082
127.0.0.1 - - [16/Aug/2021 11:46:19] code 501, message Unsupported method ('OPTIONS')
127.0.0.1 - - [16/Aug/2021 11:46:19] "OPTIONS /index.html?CheckBox=&TextBox=foo&Push+Button+1=Push+Button HTTP/1.1" 501 -
127.0.0.1 - - [16/Aug/2021 11:46:19] code 404, message File not found
127.0.0.1 - - [16/Aug/2021 11:46:19] "HEAD /index.html?CheckBox=&TextBox=foo&Push+Button+1=Push+Button HTTP/1.1" 404 -

The ad-hoc server does not support OPTIONS and the page can not be found because there is none. However, the URL with parameters arrives.
TextBox=foo
CheckBox= means that the box was checked. If it is unchecked, the CheckBox parameter is missing.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 30156
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: OpenOffice vs LibreOffice

Postby Jennifer Murphy » Wed Aug 18, 2021 1:29 am

I was able to get what I wanted with Google Sheets. Thanks for the suggestions.
OpenOffice 4.1 on Windows 10
Jennifer Murphy
 
Posts: 2
Joined: Sun Aug 15, 2021 1:02 am

Re: [Solved] OpenOffice vs LibreOffice

Postby Lupp » Thu Aug 19, 2021 12:48 pm

Once having taken the bait, you probably won't get off the hook.
Some having built services on google maps (being free as a bait) didn't when it was no longer free for them. (One relevant case I was afflicted by.)
On Windows 10: LibreOffice 7.2 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 3135
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany


Return to Beginners

Who is online

Users browsing this forum: No registered users and 4 guests