Can't copy paste to multiple cells

RevitArkitek's profile image RevitArkitek posted 5 years ago in General Permalink

I thought I was able to do this before, but if I copy a value from a cell and then highlight multiple rows and try to paste, only the last selected cell gets the value. Am I missing something obvious here? Should the highlighting only apply to cells instead of the entire row? Thanks.

Version 10.1.0.5464 (64 Bit) Win 10 1709

ansgar's profile image ansgar posted 5 years ago Permalink

You can use the right click menu in a grid, then click "Export grid rows" to set your preferred settings for copying rows. Let's say you use "SQL Inserts". Then, after clicking "Copy selected rows", you can paste the INSERTs into a query tab and execute them.

The grid itself does not support pasting multiple rows.

RevitArkitek's profile image RevitArkitek posted 5 years ago Permalink

Hi ansgar, Perhaps I wasn't clear. I'm not trying to copy rows, I'm trying to copy a cell value into multiple cells. In the attached image, I would like to copy the value "2019" into these cells that are currently "(NULL)" without copy/pasting into each and every cell. Thanks.

1 attachment(s):
  • 2019-03-11_8-51-39
ansgar's profile image ansgar posted 5 years ago Permalink

That would require the grid to support vertical selection, and probably more, which is currently not supported by HeidiSQL.

Please login to leave a reply, or register at first.