Trouble Converting ODS files to XLS

New convert to Mac from Windows. I have a lot of ODS spreadsheets created with OpenOffice. I'd like to move to use Numbers for spreadsheets, but I can't convert the ODS files to XLS without problems.


This screenshot shows a problem, namely that a simple date field doesn't convert properly. What you're seeing here is the spreadsheet opened in OO on the left. On the right, is the file in Numbers. That is, I saved the spreadsheet in XLS format from OO then opened it in Numbers. The dates didn't transfer.

User uploaded file

Any idea how to fix that? I'd rather not have to use OO on the Mac.

iMac, macOS High Sierra (10.13.6), 21.5

Posted on Aug 4, 2018 8:42 AM

Reply

Similar questions

4 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Trouble Converting ODS files to XLS

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.