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:Microsoft Windows (Win NT)
Assigned to: Bugs System CPU Architecture:Any

[28 Feb 2004 14:10] [ name withheld ]
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.
[12 Jan 2005 18:26] Jorge del Conde
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/