Ask Your Question
2

Current compatibility between LibreOffice and MS Office?

asked 2018-03-19 11:49:59 +0200

simonbeber gravatar image

updated 2018-10-13 18:54:13 +0200

EasyTrieve gravatar image

I previously had OpenOffice but found compatibility issues between that and MS Office. Does LibreOffice allow opening docs/xl, etc, to be opened in MS Office and vice versa?

I want to be sure that MS Office docs, etc, can be opened in LibreOffice and that LibreOffice docs, etc, can be opened in MS Office.

edit retag flag offensive close merge delete

5 Answers

Sort by » oldest newest most voted
3

answered 2018-03-19 21:50:06 +0200

Regina gravatar image

If you use the latest version of MS Office, then MS Office is able to use ODF1.2. LibreOffice uses a lot of extensions, in case you save to "ODF 1.2 extended". MS Office does not know these extensions. So in case you have to switch between MS Office and LibreOffice and use ODF formats in both applications, then always save to "ODF 1.2" in LibreOffice.

Many of these extension are implemented to get a better interoperability with MS Office. Therefore you might get better results working in docx, xslx and pptx. But that depends on what the documents actually contain.

In switching between MS Office and LibreOffice you have to keep in mind, that there are principle differences between the file formats, that prevent a direct converting and need workarounds: E.g. Word has tables, which can float, so that text can be on the side of the table. That is not possible in LibreOffice. Therefore on import the table is put into a frame. But a frame cannot split about several pages. Or another example: LibreOffice Writer has the ability to vary the vertical position of an image anchored as character, that is not possible in Word. There are a lot of such subtle differences, that you always need to examine the converting result to be sure, that it meets your demands.

In case some special feature does not convert as expected, you should ask.

edit flag offensive delete link more
3

answered 2018-03-19 12:17:42 +0200

David gravatar image

updated 2018-03-19 12:20:21 +0200

My experience is that using files on both MS Office and LibreOffice is at least as compatible between using MS Office files on different versions of MS Office! For simple documents, spreadsheets, and presentations, the compatibility is quite high with MSO and LibO, in fact. The more complex the file, then the higher chance of getting some glitches. This is inevitable.

Here are my main "personal rules" when I'm using files shared between LibO and MSO:

  • Writer:

    • DOC is better than DOCX;
    • expect some oddities with footnote anchors and footnote formatting;
    • don't be too ambitious in the use of tables.
  • Calc: I don't use this much (other AskLibO users may want to offer some thoughts), but in my limited experience, Excel and Calc share my fairly simple spreadsheets just fine.

  • Impress: If I want to use an Impress presentation with Powerpoint (or vice versa), I always use PPT format rather than PPTX, and keep the transitions/animations very simple. Long ago, you could get some surprises in how backgrounds are handled, but this is less frequent now.

On the whole, as long as you keep your expectations in check, and avoid over-complication of documents, then sharing files between the two Office suites is fairly successful, and very convenient. YMMV.

edit flag offensive delete link more
2

answered 2018-03-19 12:08:22 +0200

ajlittoz gravatar image

updated 2018-10-13 18:57:39 +0200

EasyTrieve gravatar image

Compatibility issues are a never ending story which will not be solved in any foreseeable future.

That said, LO can open M$ Office files .yyy(x) and M$ Office can open at least .odt (Writer) file. I can't tell for .ods (Calc) because I have no Office suite here.

However, don't expect 100% compatibility because underlying concepts are different. In Calc/Excel, you may stumble on functions with different names or differing argument semantics. Last, if your files include macros, expect failure rather than success in the average case.

Collaborative work between both suites works best for basic files which don't try to exercise bleeding edge features of the application(s). Also, always store the file native on the platform (i.e. .odx with LO, MS format with Office). Eventually export in the addressee format when sending the file but there will be approximations in the translation process. In this case, attach a version of the file in original format or PDF as a reference.

And it's always best to backup your work to a new folder or the like before proceeding into deeper waters.

edit flag offensive delete link more
2

answered 2018-03-19 13:15:23 +0200

gabix gravatar image

David, I use your good answer as a template for mine, OK?

For simple documents, the compatibility is quite high with MSO and LibO. Under ‘simple’, I mean first of all documents containing no embedded objects (for example, an Excel table embedded into a PowerPoint presentation makes it rather complex and problems are inevitable).

My experience:

  • Writer:

    • DOC is normally better than DOCX, however, DOCX is less problematic with page formatting;
    • use styles as much as possible (also, convert direct formatting to styles as much as possible);
    • cell contents rotation in text tables is a problem (not supported by Writer and there is no good way to convert, say, a mere 3-line text in a cell rotated by 90° into something that would look good in Writer).
  • Calc: simple spreadsheets are just fine, but for large and complex files I would recommend Apache OpenOffice (it performs even more stable than Excel). That's for very tables. As for charts, I have never seen an Excel file containing them that would look fine in Calc and had to re-create them (same for Writer, inter alia).

  • Impress: the worst degree of compatibility: if a presentation is, well, fancy (lots of objects, color transitions etc.), severe distortions are always present in my experience.

  • Math: Math formulas in a Writer document will appear distorted if exported to Word, however, opening them and closing (even without any editing) makes them look fine. Don't know why.

And general advise: never do ongoing work in foreign file formats, use only ODF in LibreOffice. Only after you have finished it, export to something else.

edit flag offensive delete link more

Comments

Yep, some good advice here. Glad you found the "template" useful! :D

David gravatar imageDavid ( 2018-03-19 14:49:21 +0200 )edit
0

answered 2018-03-19 12:54:45 +0200

simonbeber gravatar image

Many thanks for your answers and advice on username. My docs and spreadsheets are not complex or macro driven so my question has been suitably answered.

edit flag offensive delete link more

Comments

Please click on the check marks at the left of each answer that helped you, so that others will know.

ve3oat gravatar imageve3oat ( 2018-10-13 22:45:05 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-03-19 11:49:59 +0200

Seen: 6,290 times

Last updated: Oct 13