Opening and editing Microsoft Office files in Euro-Office
Using Word, Excel and PowerPoint with Euro-Office: which formats work, how to exchange files with Microsoft Office users, and how to avoid problems with layout.
One of the questions that comes up most often before a change is whether Word and Excel files can still be opened at all. The short answer is yes. Euro-Office reads and writes the widespread Microsoft formats and adds the open OpenDocument format to them.
What matters day to day is the exchange with partners who stay on Microsoft Office. With a few ground rules about file formats and formatting, that works reliably.
Which formats Euro-Office supports
Euro-Office works with both worlds of formats: the Microsoft ones and the vendor-neutral OpenDocument standard.
- Microsoft (OOXML): .docx, .xlsx, .pptx, for opening and saving.
- Older Microsoft formats: .doc, .xls, .ppt, readable as a rule.
- OpenDocument (ODF): .odt, .ods, .odp, the open and vendor-neutral standard.
- PDF export for the final version that goes out unchangeable.
ODF against OOXML: what is the difference?
OOXML is the Microsoft format (.docx and its siblings), ODF the open, ISO-standardised counterpart that many public administrations prefer. Both store the same things: text, tables, formulas, pictures.
The practical rule of thumb: work internally in ODF, which is open, readable in the long run and ties you to no licence, and save in the matching OOXML format for exchanges with Microsoft Office users. That keeps both sides compatible.
Exchanging files with Microsoft Office users
So that everything arrives as expected at the other end, save documents that go to Microsoft Office users deliberately as .docx, .xlsx or .pptx. For final documents, such as quotations or contracts going out for review, PDF is often the safer choice because the layout is fixed.
Avoiding the usual questions about formatting
Small differences nearly always appear in the same places. Once you know them, they are easy to get around:
- Fonts: if a font is missing on the receiving system it gets substituted and the layout shifts. Use standard fonts or the ones that ship with the suite.
- Complex tables and pivots: check the awkward cases on a sample basis before you send them.
- Tracked changes and comments: these usually survive, but test before an exchange.
- Very elaborate PowerPoint animations: these can differ. For presentations, consider saving as PDF.
A note in passing: keeping documents for legal purposes
Whether it is a .docx or an .odt, documents that have to be kept for legal reasons need an archive on top of the editing. The Aktenplatz DMS files your office documents to the GoBD standard, the German tax authorities’ rules for books and records in digital form, with versions and full-text search to find them again.