Chapter 21 · 21.11
Odt and ods or docx and xlsx: which format works best for collaboration?
If you are coming from LibreOffice or the old Nextcloud Office, you probably have an archive full of odt and ods files. Your colleagues and clients often use Word and Excel, with docx and xlsx. Euro-Office opens both types. But which format should you choose when you collaborate, and when is it wise to convert?
Example: a tennis club has always created its membership list and newsletter in LibreOffice (ods and odt). The committee now works together in a WebOké Nextcloud.
How it works in your WebOké Nextcloud
When you click an odt, ods or odp file, Euro-Office opens it straight away for editing. The file keeps its name and format: Ledenlijst.ods stays Ledenlijst.ods.

We tested this in the demo with a membership list (ods) and a newsletter (odt): we added a line, saved and reopened the file. Both stayed in their own format, the new text was there, dates stayed dates and the column widths stayed almost the same.
Why the format still matters
Euro-Office is built around the Microsoft Office formats (docx, xlsx, pptx). That is why an odt or ods file is converted when you open it and converted back when you save it. With simple documents you won't notice this. With files that contain a lot of special formatting, something may change during that conversion, such as the position of an image, a custom style or a special formula. The more complex the file, the greater the chance.
Which format should you choose?
| Situation | Advice |
|---|---|
| You work with people who use Word or Excel | docx and xlsx |
| Everyone works in your WebOké Nextcloud with Euro-Office | docx and xlsx: that is the format Euro-Office uses internally |
| A simple list or letter from your old archive that you update now and then | Keep it as odt or ods, and quickly check the result after editing |
| You have to deliver odt or ods (for example to a government body or for an archive) | Work in docx or xlsx and download as odt or ods at the end (see Download as docx, xlsx, pptx, odt or pdf) |
| A complex ods or odt file with lots of formatting or macros from LibreOffice | Edit it in LibreOffice on your computer and use Euro-Office for reading |
Converting a file to docx or xlsx
- Open the odt or ods file in your WebOké Nextcloud.
- Click File and choose Save Copy As. Choose DOCX or XLSX and the folder in your Nextcloud.
- Open the copy, check the formatting and work in the copy from now on. Move the old file to an Archive folder, so nobody accidentally works in the wrong file.
Pitfalls
- Two versions side by side. After converting, you have Ledenlijst.ods and Ledenlijst.xlsx. Agree which one is the real one and move the other to the archive.
- Formatting lost after editing? Restore the previous version from the version history (see Version History: restoring an older version), then edit the file in LibreOffice or convert it to docx or xlsx first.
- Fonts. If a document from LibreOffice looks different, it is often because of a font that Euro-Office doesn't have. See Fonts look different.
- Macros from LibreOffice (Basic) don't work in Euro-Office. Euro-Office uses macros in JavaScript (see An Excel file with VBA macros: what now? and Een VBA-macro zelf omzetten naar JavaScript: de vertaaltabel).
