After saving a Calc spreadsheet as Microsoft Office XLSX (2007/2010), Microsoft Office users get an error stating the Converter failed to open the file.
There were no other error messages
After further testing, we have found that if there are any hidden columns (or rows) in the Calc spreadsheet, the converter fails...as soon as we unhide those columns (or rows), Excel is able to open the file without issue...
If excel fails to open is this a LibreOffice bug?
Could you attach a sample document that produces the problem when saved as xlsx file? That would be very helpful to verify this bug.
Created attachment 84389 [details]
XLSX file with hidden columns...
Here is an attachment of a file created in Libre Office, that will not open in Microsoft Excel 2003.
I cannot reproduce this problem.
The example file opens fine in Excel 2010 and LO 4.2 master on OS X 10.8.4.
@Help Desk: if you are using Excel 2003 I think xlsx 2010 files will not open. But that is expected.
Try saving the LO calc file to xls instead of the newer xlsx file format. That should work.
So this is NOTOURBUG if M$ isn't able to supply users with compatible file formats. They do of course want to sell their newer M$ Office version. ;)