MySQL Bugs: #5648: Exporting City table of World database to Excel format causes errors in Excel

Bug #5648	Exporting City table of World database to Excel format causes errors in Excel
Submitted:	19 Sep 2004 2:15	Modified:	5 Nov 2004 11:12
Reporter:	Mike Hillyer	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.0.7	OS:	Windows (Windows XP SP2)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
If you export the City table of the World database to Excel format Excel will complain about it, when it finally loads into Excel, the entire table is loaded into ONE cell. 

How to repeat:
Export the City table of the World database. Open it in Excel.

Suggested fix:
Split cells and rows out.

You need at least Excel XP or 2003 to open the Excel XML file. We now have updated the filetype description to reflect that limitation.