MySQL Bugs: #3007: Copy results to clipboard in a spreadsheet-friendly format

Bug #3007	Copy results to clipboard in a spreadsheet-friendly format
Submitted:	28 Feb 2004 14:10	Modified:	12 Jan 2005 18:26
Reporter:	[ name withheld ]	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQLCC	Severity:	S3 (Non-critical)
Version:	0.9.4	OS:	Windows (Win NT)
Assigned to:	Jorge del Conde	CPU Architecture:	Any

Description:
Copy results to clipboard in a spreadsheet-friendly format.

How to repeat:
If you copy all or part of a result set to the clipboard, and then paste into a spreadsheet (OpenOffice.Org in my case), the data is pasted as lines of text in the same form as that produced my the "mysql" console client. For example:

+---------+--------+
| VatCode | Rate   |
+---------+--------+
|       0 |      0 |
|       1 |   13.5 |
|       2 |     21 |
|       3 |   12.5 |
+---------+--------+

Suggested fix:
If the data was copied in a tab-separated form, it would load properly into a spreadsheet.

Thank you for your interest in the MySQL graphical administration tools.
We recommend that you use our MySQL Administrator and MySQL Query
Browser.  The MySQLGUI and MySQL Command Center legacy products are
deprecated, and we are no longer maintaining those projects.

For more information on MySQL Administrator, see:
http://www.mysql.com/products/administrator/