Bug #6569 Excel export dumps to single cell in spreadsheet
Submitted: 11 Nov 2004 5:49 Modified: 6 Dec 2004 8:47
Reporter: Mark McAulay Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.1 gamma OS:Windows (Windows XP Pro)
Assigned to: Michael G. Zinner CPU Architecture:Any

[11 Nov 2004 5:49] Mark McAulay 
Description:
When doing an Excel export of a result set in Query Browser, the entire data set goes into a single cell rather than in its proper rows and columns

How to repeat:
Try exporting a dataset to Excel

Suggested fix:
Lay it out in rows and columns.
[11 Nov 2004 14:52] Michael G. Zinner 
Are you using Excel XP or higher? Older Excel versions are not supported, since they don't understand the XML format.

This should be stated in the Save File Dialog.

You can use the CSV export as a workaround.
[11 Nov 2004 20:46] Mark McAulay 
Using Office 2000 Pro
[6 Dec 2004 4:32] Mark McAulay 
This issue can be closed, since this is a known limitation.