Articolo di Tcat Houser capoeditore di TRCBNews.com.
Probabilmente è da scommettere che da quando gli esseri umani sono Homo sapiens ci accingiamo a vedere dei cambiamenti rispetto a quelli che pensiamo essere i nostri binari. Come molte altre cose ci sono motivi sia per rallegrarsene che per sentire una sensazione di morte. Oggi andremo a guardare le tre suite per ufficio più diffuse: OpenOffice, LibreOffice, e Microsoft Office.
A meno che non siate uno studente di storia o, come me, un fossile umano, probabilmente non sapere che c’è stato un periodo in cui Microsoft era il capo dei ribelli. Le informazioni erano incatenate in silos, nascoste dietro pareti di vetro e mantenute da sommi sacerdoti. Ed il tutto era anche molto costoso. Un utente doveva andare da un sommo sacerdote e chiedere i suoi servizi.
Microsoft è stato il leader dei ribelli con un bassissimo costo per il suo sistema operativo e linguaggio di programmazione. È cresciuto fino a diventare un dittatore benevolo. Ma da qualche parte lungo la strada ha perso la parola, benevolo.
C’era una società indipendente nella Silicon Valley conosciuta come Sun Microsystems. Anche se hanno fatto i loro soldi con l’hardware con i loro sistemi Sparc, avevano una suite a basso costo concorrente della suite di Microsoft Office conosciuta come Star Office. In realtà non era così buona ma ne avrei comprato alcune copie a $ 50 ognuna perché anche già dalla fine del 1990 Microsoft stava già perdendo la sua benevolenza.
OpenOffice affonda le sue radici in StarOffice. Con il crollo di Sun Microsystems sono stati inghiottiti da Oracle. In una mossa politica l’azienda ha investito più tempo a preoccuparsi di quello che doveva fare con Java e secondariamente con Star Office/Open Office. Tuttavia, non lo ignorarono del tutto e cercarono di eliminare ogni leader del progetto che non era un dipendente di Oracle.
Questo causò un’ondata rivoluzionaria e LibreOffice venne alla luce. In quel punto nacque un bivio del codice.
La maggior parte delle distribuzioni Linux ha seguito LibreOffice. Certo, questo ha senso, in quanto OpenOffice era gestito e mantenuto esclusivamente dalla Oracle Corporation.
Nel corso degli anni la polvere si è posata un pò e l’animosità tra le due alternative a Microsoft Office è diminuita.
Quale scegliere?
Questa è una domanda molto difficile a cui rispondere, senza sapere di più sulla vostra situazione. Potrebbe infatti essere necessario utilizzare Microsoft Office.
E’ una questione di collaborazione
In realtà dipende dal vostro ambiente di lavoro. Se ciò che si sta facendo nella lavorazione e gestione della conoscenza è fatto al 100% sia da soli o all’interno di un unico gruppo, si potrebbe anche scegliere di utilizzare un martello e scalpello per fare una scultura da pietre di ardesia prima di cospargerle di inchiostro e poi passarci sopra della carta, e si potrebbe farla franca.
Ma se dovete inviare documenti e fogli di calcolo ad altre persone che possono essere o non essere in grado di cavarsela con l’utilizzo di una delle suite Open di Office è tutta un’altra cosa.
E’ una questione di complessità
Sia LibreOffice che OpenOffice resteranno attive nel prossimo futuro. Personalmente, io uso LibreOffice e Microsoft Office.
LibreOffice ha caratteristiche che io sia voglio e di cui ho bisogno, che non riesco a trovare in Microsoft Office. Alcune delle estensioni gratuite sono semplicemente incredibili. Tuttavia, vi è un settore in cui OpenOffice batte senza problemi LibreOffice. Questa è la compatibilità con Microsoft Office.
Siamo nel 2013 e la situazione è: LibreOffice è più agile e ha più offerte tra le funzioni. E questo va a scapito della compatibilità di ciò che viene prodotto con Microsoft Office. Questo è dove OpenOffice lascia nella polvere LibreOffice.
A causa delle mie collaborazioni ho anche bisogno di disporre di Microsoft Office. Un settore in cui Microsoft lascia i suoi concorrenti nella polvere è nell’area dei foglio di calcolo. Microsoft li ha uniti al suo SQL. Ci sono alcuni fogli di calcolo di terze parti che, anche non popolati con alcun dato non entrano in un floppydisk dell’ultima generazione.
Quando tutto ciò che hai è un martello, tutto sembra un chiodo
So che non sono in grado di cambiare la natura umana. La gente continuerà a cercare di usare un word processor quando un processore di documenti come LaTeX sarebbe una scelta migliore. Ho visto i lavoratori della conoscenza usare il completamento automatico per la gestione come una rubrica.
Io e te potremmo conoscere un modo migliore. Questo non significa che si arrivi ad essere un dittatore benevolo.
Se si è costretti a trattare con altre persone che utilizzano Microsoft Office per pigrizia o per necessità, la realtà è che OpenOffice è la vostra scelta migliore. Quanto più si sta producendo per usarlo con un invio di fax, oggetti pronti per la macchina fotografica o altro prodotti finiti più libertà si ha. In questo caso si sarà probabilmente più felici con LibreOffice.
Ecco come la vedo io e mi trovo di fronte a voi pronto a prendere i pomodori in faccia.
Popular Posts:
- None Found
What about Calligra Suite?
I have encountered PPTX files are opened better with LibreOffice 4 than OpenOffice, especially when smart art is used. So, with my personal experience, I think LibreOffice is better in compatibility than OpenOffice.
Can you please mention which MsOffice file formats are better supported by OpenOffice than LibreOffice?
Hey Deekshith, you pegged me to the wall, LOL. Here’s the deal. Only this weekend I did my first “slide show” since the 90’s, as a test for video output. I’m a PPT ID10T! And to answer your question, OO org runs rings around Libre Office in the DOC (X) world.
As I mentioned in the article, folks like to try to use DOC (x) as LaTeX or MS Publisher. 🙁 The harder they push that, the more it breaks between MS Office and the Open Source world.
I don’t know much about the XLS world except as part of my life another firm I work with found the Open Source stuff could not handle the weight a really heavy spreadsheets. I noodled out it the reason is MS Excel is bonded to MS SQL.
The reason I was playing with PPT is I’m re-visiting YouTube and Marketing. I was *so wrong* in my guesses from 2009. It DID work. It just took a few days short of forever to get there.
This certainly is not a Linux question so I won’t go into it more here. If you are wondering I put the data (and how I blew it) here. http://www.soliber.net/03/the-huge-youtube-mistake/
> OO org runs rings around Libre Office in the DOC (X) world.
I’d love to fix your bug(s) around DOC(X) – it’s something we invest a lot of effort into. Please can you mail me your documents privately (and in confidence) so they can be fixed. I strongly suspect some small feature causing the aggravation. And of course at LibreOffice we care passionately about improving interoperability – so this is a disappointing and unexpected outcome – indeed, as some commenters have mentioned they really appreciated the improvements we’ve made all over including the DOC(X) filters.
I look forward to your bug report ! 🙂 thanks.
Cool! Let’s take this off line! Tcat a t TR c B dot com
As I said recently, I blew a 20K a month gig teaching because my security profile created in the latest Libre Office would not open in whatever the AUE govt is using….
Jan you bring up an interesting question! I’ve been more focused on the desktop angle where the ‘heavy lifting’ commonly occurs. Calligra seems to be moving fast in the tablet space. 🙂
Where my crystal ball is foggy is:
Will the tablet space rely more on ‘Cloud’ or Remote Desktop calls OR/AND depend on local processing such as Calligra?
It is a Tough Call. Part of the reason for the lack of clarity is different strokes for different cultures. Example: the QR code has been part of regular life in Japan. In the EU, less so. In the USA its on the ketchup bottle and I sure don’t see anyone using their mobile camera to donate to charity (even with Heinz money) by clicking on the QR code.
I applaud the speed at which Calligra is progressing 🙂 What I don’t know yet is: Is it a solution in search of a problem?
That will depend on a culture by culture basis for the answer.
We’ll all have to stay tuned to find out :<
Meanwhile I'm researching more Qt applications. Check back here soon for that.
Tcat
Could you please give precise examples where OpenOffice produces better Microsoft Office files than LibreOffice?
Hi Snort!
In a short answer, no.
Longer answer. I am an independent consultant/researcher/writer. I work with a variety of firms, globally. Showing precise examples would be revealing data from firms I have a limited and specific role.
I can say from the larger view, the dust has settled. LibreOffice is the more nimble fox of research. OO.org moves more slowly and incorporates (later) LibreOffice features and does a better job on complex files. At the end of the day, some are just stuck with MS Office.
YMMV
:/
Tcat
Given LibreOffice has included extra support for DOCX and can actually write files in the latest Microsoft Office formats, I would have said you have your advice the wrong way round. Apache OpenOffice is for people who want to stick to a long-lived brand and don’t mind having loads of stuff missing; LibreOffice is for people who need to interoperate with “the real world” including reading MS VIsio and MS Publisher files.
There’s a refreshingly honest feature comparison with MS Office on the TDF wiki that may help; I’m not aware of a similar chart for Apache, maybe another reader knows?
Thank you, TC!
And we can add that MS Office now reads ODT files, right? Well sorta Yes, sorta no.
It comes down to complexity and specific functions.
The two things I’m sure of: This topic is changing and fast moving. The other is it is like shoes. Gotta find the right size and style for the job at hand. (Don’t go dancing in worker boots 😉
I’m not in charge of what versions of any of the Office Suites a firm uses. Some are back at MS 07. Others are cutting edge Libre. Some have no problems. Others it is hell on earth.
One of my main points was about having to collaborate file formats. It is *impossible* to say this or that works or doesn’t, to a specific task. If you see something I don’t or know of better research, I’m buying you a beer! 🙂
My thoughts are based on dealing with this digital mess since Star Office, and my daily work. I’m certainly open to learning more to bring some peace to the pile of bits!
While on the topic of OO.org and LibreO I have something for you that is too short for an article and still very useful.
http://extensions.libreoffice.org/extension-center/alternative-dialog-find-replace-for-writer/releases/1.3.2 and
http://extensions.openoffice.org/en/project/AltSearch http://extensions.openoffice.org/en/download/4114
Funny thing is I am using the OO.org one in LibreO V4.
I use it to replace a double space with XML markup in a batch file. That XML is required to make the Text To Speech (TTS) to create the files found on Google Play.
https://play.google.com/store/music/artist?id=Ai7m3ix62diqomzt4uftrn7y4ci
While I have both free and paid there, this is not a plug to buy my work as it is a very niche market focus (US Military – DoD folks in IT) … Still you may want to sample some of the free stuff to get the concept… The concept is to learn dull boring crap to pass an exam while you are doing something more fun and/or useful.
The key is repetition, which is why the voices are fast — you don’t ‘listen’, you play.
Doing the XML markup in a batch file using this extension saves gaggles of time.
Regarding file format compatibility with MS Office, I absolutely disagree with your judgement. I run here LibreOffice 4.0.1 and Apache OpenOffice 3.4.1. I get lots of MS Office files and almost always LibreOffice produces the better results in import and export, particularly with docx, pptx, xlsx. There are some few examples, where .doc were opened better in AOO, but these were very rare examples.
Hey Aldi: whom says: “I absolutely disagree with your judgement”
GREAT! I am Delighted to hear that! (True and really)
” I run here LibreOffice 4.0.1 and Apache OpenOffice 3.4.1. I get lots of MS Office files and almost always LibreOffice produces the better results in import and export, particularly with docx, pptx, xlsx.”
What I notice is you are speaking of state of the art, 2013. Cool.
that is not what the entire world runs under. :<
My comments and blog, I didn't do for trash talk. I'm not (yet) crazy. Some folks (companies) are still on MS Office 2000.
Your world may have rare examples.
I recently had my Security Preview for the AUE blow up in a DOCX file from Libre. Would not open on whatever the hell they are using. That is my world when I wrote the blog post, and it hasn't changed in my world since Star Office.
Yes, Libre is moving faster then anyone. And I blew my data to the AUE only 3 weeks ago for my visa entry for work in a DOCX file. Using the latest Libre.
The point is the rest of the world has to be as current as you or both are STUFFED.
One of the biggest differences I found a few years ago was between MicroSoft Access and OpenOffice Base. None of the queries, screens, or reports were transferable. I had to recreate all of that with different approaches to get similar results. What a pain that was. At least I was able to access that data I had.
Has that changed now? Are they more compatible? And what about LibreOffice? Which Is more compatible with Access now?
Thanks…
Dabu…
I am finally making the break from ms office (yes i know, years behind time). Your article told me exactly what I wanted to know, on a note perfect info/humour/waffle ratio. Thank you.
Libre office totally kills spreadsheet macros I’ve been using for two decades and it seems to be all about wrong data types in VB and passing data. It looks like they are so anxious for modern (=trendy) scripting that they are ignoring VBA. Clearly no QA in this area.
I’m removing it from my MacBook and will install OO after I lick my wounds and figure out what happened on an 8 year old m$ PC.
I think you did OO a disjustice in not mentioning it was no longer control by Oracle.
I can’t speak for LibreOffice, but OpenOffice is a total mess…at least the version I try to use on my MacBook. In just the last week I came across two ridiculous glitches: every color hex value I enter is interpreted as some shade of gray, and when I try to sort data it…well, doesn’t sort correctly. At all. The latter is a very basic spreadsheet function…if it doesn’t work, something is very wrong.
Thusly, I declare OpenOffice as an unfortunate piece of crap. I won’t even go into it’s issues with Office compatibility, which are largely Microsoft’s fault, but somewhat simply due to shoddy/lazy programming.
I find Google Docs is actually a more reliable solution than OpenOffice (and for collaboration, it is utterly awesome). I’ve yet to try LibreOffice.
I’ve used LibreOffice 3.5.7.2 for Ubuntu Linux, OpenOffice for Ubuntu Linux and MS Office 2000 for XP and work in a large bureaucracy where MS Office is the only supported office suite tool. In many repects none of these work now that MS Office 2007 and newer are in vogue. As TCat says, OpenOffice Writer converts better to MS Word 97 and DOCX. Neither Libre- or Open-office writer for Linux convert very well. Only the simplest text features will convert. Tables won’t convert. Both Libre and Open scramble table contents from Word documents and Libre and Open tables will not convert at all to a Word table. The comments in edit tracking won’t convert in either, though Libre-Office keeps them separate while OpenOffice will bunch every comment together and display them all at each comment entry. OpenOffice writer maintains more of the overall formating style, but never fully, so you can never count on a conversion either way to look the same as initially laid out. LibreOffice can’t handle inserted graphics of a Word doc or docx. LibreOffice will put the graphics in odd places and interfere with existing text such that the text disappears. Both LibreOffice and OpenOffice writer chokes on inserted elements like text boxes. LibreOffice won’t show all the content of the text boxes and sometimes not at all. And so on. In summary, if you are on a project where the wordprocessor files are being shared to create a final result, the exact same word processor needs to be used by the team. Since I am overshadowed by Word users, I am stuck either using Word or taking on all the writing / formating myself and while frustrating my colleagues that have to work with limited text formats for their edting (yes, MS has a monopoly now because of fear of change to taking up freeware once the bureaucracy has invested in the MS jugernaut). Since I moved to Linux to get away from IT bureaucrats and the MS control freaks, I have doomed myself to inefficiency (because i work in teams where everyone else uses MS).
RE: Spreadsheets. For the simple stuff, Libre, Open and MS convert one for one with each other. Introducing graphs and other add-ons introduces conversion problems.
RE: presentation. Used ppt and odp. Keep it simple and they convert well enough between them. Most issues are in the different font sets between systems. PPT has more features to wow people and distract the audience from the message.
RE: databases. Used Access and tried to use Open base and then convert to Access. Hopelessly complicated. gave up.
Reminder. This is all about the Ubuntu Linux versions verus the MS versions for XP.
So.
Office suites do just fine in their own worlds
I am a author and I wish not only that Libre Office was more compatible with Microsoft office but to add a feature that would save me a lot of grief. When I write a sentence that overlaps into the next line. If I want to change the context to a ” ” I want to do so without cutting out the word or sentence and pasting it 4 tabs over. Make it so I can click beside the word, even if it is at the beginning of the left side of the page without having a ” at the beginning to be able to shift over several spaces. I know this is nitpicking but it would really make my day.
I use LibreOffice because it comes with Ubuntu… but I should mention that by default it does not come with the Canadian English spell check dictionary. That is a ridiculous oversight, when Australian, British and American English dictionaries are installed by default. I now have to go through a complicated process of adding the en_CA extension, even though it is misleadingly listed in the options for Languages. Why don’t people realize that we are not British, we are not Australian, and we are not American?!
I have no idea if this is an issue with OpenOffice, but LibreOffice does the job well enough that I’m not going to bother uninstalling it and installing OO, just to discover that LO was indeed the better option.
Sorry, but this article is simply a joke. Better remove it, before people get hurt.
Once I had to make a quite complex Excel workbook with many sheets and a large data set (27K lines and 12+ fields each) that the worksheets had to analyize. A recalculation took 4-10s on a quad-core machine.
I could never make the formulas to collect info from all the data lines, 5 to 20 lines were always missing from the graphs and reports. But when I opened this monster in OpenOffice, we saw a miracle: everything was right. Back to Excle, and the lines were missing again.
Is OO or LO better than MS Office? I don’t think so. But they are free and technically they can match MSO. I think they both worth a try.
One huge advantage Libre has over Open in the fact that it can open works documents. Quite often when setting up a new PC we are asked to transfer works files over but cannot install their works as it was a preinstalled version.
Open office and even Microsoft Office to a large extent struggles with these .wks and .xlr files.
Whenever I receive an proprietary MS document I send it back and request an open format.
Thanks for the article. Funny and helpful!
I’m spreadsheet user since Lotus-123 (for DOS), Lotus Symphony (for DOS), Lotus-123 for Windows up to Lotus-123 2000, use MS Excel since the year 2001, and now I use Libre Office Calc (mostly), rarely MSExcel, and almost one full year didn’t touch OOo/AOO.
Back in the year 2009:
I can open/create/modify/save *.xlsx or *.xlsb files with Open Office org without any problem, as long as the files has no macro. The only problem is speed.
Libre Office not there yet.
This year 2013:
Libre office still has problem with MS Excel files. Only open *.xlsx, and can’t open *.xlsb file, but has better spreadsheet macro support.
I don’t know how ApacheOO handle *.xlsx/*.xlsb and spreadsheet macros.
Thank you for a well written article, very good reading. I liked it !
I have personal experience in some of the challenges LibreOffice has with Office, well actually it’s Office’s problem, since Office has a lack of will to read anything not genuine Office, but since a majority of users use Office, it’s back to you and it’s your problem….
So after reading this I might give Open Office a try. Nothing wrong with Libre Office but sending spreadsheet back and forth between Libreoffice/Office was a challenge. . . I never solved it. Followed all the good advice, but still had lines missing, and macros…… ohhh nooo!
Maybe you could add a chapter for the early editor’s as well. Remember as a student we had a BIG Prime whatever solution, and a fantastic editor that allowed us to edit all text in one sentence full page width…. remember the feeling of a major braketrough… yepp I am so old that I know what a 320K floppy is….. miss Dos 3.0 cheers
I have to disagree with the assessment that OpenOffice is compatible with Micro$oft Office than LibreOffice since the former can only open the newer .docx, .pptx, and .xlsx formats, while LibreOffice can both open and save to them. LibreOffice is also the only third party application I know of that can open Publisher files, if only in read-only form.