Ask Your Question
0

Unable to open spreadsheet saved in Calc as Microsoft XML [closed]

asked 2013-08-27 16:21:45 +0200

RobertShelton gravatar image

updated 2015-11-07 11:01:55 +0200

Alex Kemp gravatar image

I created a new spreadsheet in Calc w about 6 tabs and a half dozen columns per sheet - a skeleton basically. On Save, I got the options to save in LO or Microsoft XML format. As colleagues would have to use MS Excel, I selected MS XML format. When I open the file in either Excel 2010 or LO 4.1, I get an XML import dialogue and the resulting "spreadsheet" has one tab with a bunch of XML in it. Why is LO 4.1 saving as a format that it cannot read - and that Excel also cannot read?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-07 11:02:07.138256

1 Answer

Sort by » oldest newest most voted
0

answered 2013-08-27 21:13:21 +0200

David gravatar image

I've got LibO 4.0.4.2 on this machine. The options I get for Excel are as follows:

Calc save dialog

My hunch is that you've saved to "Microsoft Excel 2003 XML" which has an .xml filetype. Could you confirm the full file name of your exported file? If you save it with the "Microsoft Excel 2007/2010 XML" option resulting in a .xlsx filetype, I think you'll be good to go. (Hopefully! ;)

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-08-27 16:21:45 +0200

Seen: 1,144 times

Last updated: Aug 27 '13