Excel Friendly Copy/Paste
One thing that would be very helpful for me and my coworkers would be an easy way to copy/paste between HeidiSQL and Excel. The only way to copy data from HeidiSQL to Excel currently is HTML (it doesn't recognize CSV on the clipboard), so I have to remove the formatting and the footer from the HTML data each time I paste. Conversely, there doesn't seem to be any way to paste data on the clipboard back into a table in HeidiSQL either without exporting to a CSV.
In my own applications, I paste data on the clipboard destined for Excel in TSV (Tab Separated Values) format, which it pastes very readily. Likewise, when copying data in Excel to the clipboard, the plain text version of the clipboard contains TSV data as well.
It certainly isn't practical to include the power of Excel in HeidiSQL, but it would certainly be nice to use a lot of its power in editing and manipulating database data. Being able to copy/paste TSV data would be a greatly appreciated feature.
One other thought on copy/paste... currently if you highlight multiple table cells and press Control+C (or right-click and select Copy), it only copies data from a single cell rather than the entire selected range. Would it make sense to copy everything that is highlighted, since the user has taken the time to create a selection before selecting the Copy option? One could define the default data format in the program options.
Just a thought.
Please login to leave a reply, or register at first.