multiple cell paste

Say I have 10 records in table grid, and see column with blank values. Want to update all from blank to 'some value'.

To lazy to write query so I would mark those cells of that column (not entire rows)
and paste the thing into them.

If it can be done on single cell it could be done on multiple cells.

Note: can be done with search/replace,but then I do have to update filter, limit columns dispay, ...


All extra time consuming work.

sample: have to insert lat & lon, picking them manualy from
wiki. Ok, not optimized table struct, but it is temporary.

Honestly, for 10 rows, you can very quickly use Ctrl+V on each of that cell plus arrow down. For hundreds of cells, you would anyway write a query, normally.

Point beeing , many times I have like 10 cells to update with same contence, then, another 20 cells with another contence ....
Nothundreds.

"Ctrl+V on each of that cell plus arrow"

Not good idea. If you stroke that one, one time to many, the good data are lost.

Click on cell, shift+click on another, select all in between, like in OO, MS spreedshet ....

As soon as you select some other row, the pending UPDATE for your current changes is sent to the server. So you don't even have the technical chance to select other rows while editing one row. Any clue how to solve that with or without shortcuts, in a way which does not break the normal workflow of editing single cells?

I see the problem, but

1.click cell (even many clicks to set it editable)
2.click another cell (that is, shift+click for new functionality) (I dont think any update goes to server, as I did not edit anything --> yes checked that)


So I think this is doable...

There is a prob however.

You alread have shift +Click so we can mark rows for export.

That (selecting whole rows)should be then mybe done only if selecting acros 2 + columns, else only one column.

Or more nice, like in excel/OO calc, where you have numbered rows, and selecting there, where numbers are, selects entire row.

see: