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/

Page generated in 0.048 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.