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)

???

Thanks
OpenOffice 4.0 on MacOS 10.8
tdhg566
 
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".
OOo 3.3.0 and Apache OOo 3.4.1/4.1.1, on Ms Windows 7/8 and Mac OS-X.
User avatar
keme
Volunteer
 
Posts: 1823
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 21 guests