distal-attribute
distal-attribute
distal-attribute
distal-attribute

multiple cell paste

User, date Message
Written by BubikolRamios
8 months ago
Category: Feature discussion
327 posts since Thu, 14 Jan 10
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.
Written by BubikolRamios
8 months ago
327 posts since Thu, 14 Jan 10
Note: can be done with search/replace,but then I do have to update filter, limit columns dispay, ...


All extra time consuming work.
Written by BubikolRamios
8 months ago
327 posts since Thu, 14 Jan 10
sample: have to insert lat & lon, picking them manualy from
wiki. Ok, not optimized table struct, but it is temporary.
Written by ansgar
8 months ago
4962 posts since Fri, 07 Apr 06
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.
Written by BubikolRamios
8 months ago
327 posts since Thu, 14 Jan 10
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.
Written by BubikolRamios
8 months ago
327 posts since Thu, 14 Jan 10
Click on cell, shift+click on another, select all in between, like in OO, MS spreedshet ....
Written by ansgar
8 months ago
4962 posts since Fri, 07 Apr 06
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?
Written by BubikolRamios
8 months ago
327 posts since Thu, 14 Jan 10
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...




Written by BubikolRamios
8 months ago
327 posts since Thu, 14 Jan 10
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:

 

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