@apple_enthusiast it would be nice if iWork used ODF as it’s really not productivity software if its formats are not compatible with the rest of the world no matter what OS and software one is using particularly when ODF is now the ISO recognized format.
That would be nice. That said, Pages exports to RTF and Numbers exports to CSV. These are standard interchange formats.
CSV only exports data, not formulas. I don’t really consider it a proper spreadsheet interchange format.
@reddig33 tried export tests and too much is “lost in translation”, not as much lost exporting to docx but still not a complete translation. Using LibreOffice and Collabora with ODF and collaborating with MSO users will have to do as there are no problems there. iWork sadly isn’t all that useful as long as it remains closed.