search

little-brother / sqlite-gui

Lightweight SQLite editor for Windows
GNU General Public License v2.0
1.07k stars 51 forks source link

Option to paste a cell into multiple ones (Feature request) #151

Open SilvioGrosso opened 6 months ago

SilvioGrosso commented 6 months ago

Hello @little-brother

In all truth, I don't know whether it is already possible to do so... :blush:

It would be useful to copy a cell and paste into multiple ones (of the same column, for instance).

At present, when you open a table (double-click on its name) it looks like you can only copy a cell and paste it into another single cell Also copying multiples cells is not allowed.

My best regards!

little-brother commented 6 months ago

Do I understand correctly that you need the next feature: you select multiple cells, then press Ctrl + V and all cells filled by value from a clipboard?

At this time code for grids don't support multiple selected cells. Only one. To support multiselect the code should be rewritten. It's possible, but I don't think it may come soon.

P.S. My idea for multiple selected cells was to show one of sum, avg, min or max for selected cells like a DBeaver do it.

SilvioGrosso commented 6 months ago

Hello!

Do I understand correctly that you need the next feature: you select multiple cells, then press Ctrl + V and all cells filled by value from a clipboard?

Yep. Suppose I copy a cell (e.g. A2) and I want to paste it into A3 or A4 etc. In short, the same you do with Excel where you could paste a cell into multiple cells (usually into the same column).

P.S. My idea for multiple selected cells was to show one of sum, avg, min or max for selected cells like a DBeaver do it.

Yep. This is also possible with Db Browser for SQLite.When you select multple cells (containing numbers) in a column, at the very bottom of the window, in the status bar, you visualize their sum, min, max, average and count.It is the same feature you get with Excel or Calc... It is indeed very useful :-)

SilvioGrosso commented 6 months ago

With LibreOffice Calc and Excel you can also customize these options (right, bottom bar) in order to only visualize the ones you prefer the most. This might be also useful in order to not put too many information in the bottom status bus in case it is already quite cluttered (e.g. with the available SQLITE extensions).

For instance with Calc:

image