How-to copy column headers

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
cavalier3
Posts: 11
Joined: Thu 19 Apr 2012 00:39

How-to copy column headers

Post by cavalier3 » Thu 24 May 2012 20:50

On the features page it says: "Copying data with column headers for quick pasting to spreadsheet"

Is there an option to enable this? When I copy/paste the default behavior is data without column headers.

alexa

Re: How-to copy column headers

Post by alexa » Fri 25 May 2012 08:58

You would need to right-click in Data Editor and select 'Copy With Header' in the popup menu.

cavalier3
Posts: 11
Joined: Thu 19 Apr 2012 00:39

Re: How-to copy column headers

Post by cavalier3 » Fri 25 May 2012 18:35

Hi Alexa, is there no keyboard shortcut for this? If not, I'd like to respectfully submit a request!

alexa

Re: How-to copy column headers

Post by alexa » Mon 28 May 2012 15:01

You can define your own shortcut for this command as follows:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Keyboard' branch.
3. Type 'DataView.CopyWithHeader' in the 'Show Commands Containing' field.
4. Find and select the 'DataView.CopyWithHeader' item in the list below.
5. Select 'Data View' from the 'Use new shortcut in' dropdown list.
6. Set the focus in the 'Press shortcut keys' field.
7. Press the key combination you want to assign to the command. This combination will appear in the 'Press shortcut keys' field.
8. Click the 'Assign' button next to this field.
9. Click 'OK'.

cavalier3
Posts: 11
Joined: Thu 19 Apr 2012 00:39

Re: How-to copy column headers

Post by cavalier3 » Tue 29 May 2012 17:25

Wow, great tip Alexa! Did not know these customizations were available but they are awesome.

cavalier3
Posts: 11
Joined: Thu 19 Apr 2012 00:39

Re: How-to copy column headers

Post by cavalier3 » Wed 30 May 2012 22:19

Hi Alexa, one more follow-up question. I created the shortcut as CTRL-C-S but it seems to be affecting the default copy functionality. Now when I click an individual field it does not copy - did I set this up wrong?

alexa

Re: How-to copy column headers

Post by alexa » Tue 05 Jun 2012 13:15

You should use another key combination for the default copy functionality then. Let's say, CTRL+INS or any other which you can define manually.

Post Reply