Can not import XLS file from OSX Numbers app

Discuss the spreadsheet application

Can not import XLS file from OSX Numbers app

Postby tdhg566 » Tue Aug 13, 2013 4:55 pm

Using OpenOffice 4.0 on both OSX and W7. OO4 will not properly import a Numbers application created XLS document. Fonts are garbage. Same XLS file WILL import properly with LibreOffice and MS Excel. XLS files moving other direction (FROM MS Excel, LibreOffice and OpenOffice) import fine in OSX Numbers application. It's ONLY XLS files saved or exported from OSX Numbers application that do not open in OO4.

Thoughts?? Filter settings? Font choice (tried many UTF choices)


OpenOffice 4.0 on MacOS 10.8
Posts: 1
Joined: Tue Aug 13, 2013 4:40 pm

Re: Can not import XLS file from OSX Numbers app

Postby keme » Wed Aug 14, 2013 10:11 am

It may be that the file is exported from Numbers as a plaintext XML file, instead of the "packaged XML" that constitutes a proper Excel file. That has been the cause with several XLS files from other sources. Try to change the filename extension (aka "file type") to ".xml".

I suspect that AOO selects import filter from extension, while the other applications you mention are more "content sensitive".
Apache OO 3.4.1/4.1.2/4.1.3, on Ms Windows 7/10 and Mac OS-X 10.8.5 and 10.11.
LibreOffice on Mepis Antix MX 14
User avatar
Posts: 2830
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Return to Calc

Who is online

Users browsing this forum: No registered users and 41 guests