Ask Your Question

Which MS Office file formats have better compatibility with LibreOffice? [closed]

asked 2012-02-20 00:47:49 +0200

TJ Meneses gravatar image

updated 2015-08-28 17:41:25 +0200

Alex Kemp gravatar image

Wish all I can that ODF was the ubiquitous document format used in my university, it's not. MS Office dominates all office and student work. What I'd like to know is this; which format should I use when exporting my LO-created files to ensure the highest compatibility with, say MS Office 2007, and vice versa?

This is a catch-all kind of question. I expect that the answers might differ between applications e.g. Writer works best with 2007, but not Calc. The more comprehensive your answer to my question is, the more I'd appreciate it.

EDIT: Although I've selected an answer, I'd still like to know if there are certain cases (or certain features) where saving to the newer "open" OOXML formats provide better compatibility than .doc/.xls/.ppt.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-27 03:31:09.271572

4 Answers

Sort by » oldest newest most voted

answered 2012-03-06 13:00:13 +0200

updated 2012-04-13 20:55:33 +0200

In most cases saving Writer/Calc/Impress to Word/Excel/Powerpoint 97/2000/XP formats will yield the best results, keeping in mind features and formatting will differ.

edit flag offensive delete link more


Based on the parameters of my question, I suppose this was the answer I was really looking for. It's really tricky to know when it's better to use 2007/OOXML formats instead of the older non-X formats of '03. Thanks for the info.

TJ Meneses gravatar imageTJ Meneses ( 2012-03-10 16:44:03 +0200 )edit

answered 2012-03-10 17:11:58 +0200

ehansen gravatar image

Please note that Excel can not in any way handle .ods files coming from LibreOffice. By design Excel will deliberately destroy any .ods created by LO deleting all formulas, and replace them with their current value. The only .ods file Excel can work with are the ones created by Excel...

edit flag offensive delete link more

answered 2012-02-20 15:10:56 +0200

Mateusz gravatar image
edit flag offensive delete link more

answered 2013-03-22 07:23:37 +0200

ROSt52 gravatar image

IMHO as much as our devs try to create MSO compatible export and import filters, they never have a real chance because MS - to the best of my knowledge - is not following standard formats. Thus, for our devs this MSO compatibility remains a moving target. Will MS follow and agreed industry standard? What could be a reason for MS to follow or not follow this standard?

We as LibO users have only the chance to live with what LibO provides.

However, since I am using LibO (means abandoned MSO) I recognized that pdf-Files are in 99.9% of all file exchange needs the best solution. In the remaining cases I save in an MSO format to exchange files. In these few cases I take into account that I might loose a bit of formatting.

To give @TJ Meneses a partial answer: Don't worry too much about the best MSO format, use pdf-files and make the best out of the situation (trial and error) when you need to export or import MSO formats.

edit flag offensive delete link more


Hm, interesting points. I may try looking around for a corollary question I came up with after realizing that the original is too vague to be useful ("What would be the best format to collab between LO and MSO with?")

TJ Meneses gravatar imageTJ Meneses ( 2013-04-23 09:44:28 +0200 )edit

@TJMeneses - It would really be good to have a good reference question with answers or a link to the Help wiki but this must have good information and should be updated always.

ROSt52 gravatar imageROSt52 ( 2013-04-23 10:36:55 +0200 )edit

Question Tools


Asked: 2012-02-20 00:47:49 +0200

Seen: 12,258 times

Last updated: Mar 22 '13