Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.

click to hide/show revision 2
No.2 Revision

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.