Is it possible to to focus on multiple cells with KeyTable, and copy their data?

Is it possible to to focus on multiple cells with KeyTable, and copy their data?

hm123hm123 Posts: 84Questions: 27Answers: 1

Description of problem:

Currently keytable only works on one cell at a time.

With other spreadsheet programs (excel, google sheets, openoffice, etc.), it is possible to focus on multiple cells, by either:

  1. shift + clicking the cells (can also drag select)
    This covers a range of cells from where the click starts and ends. This can also be done diagonally, not just up and down columns, or across rows.

  2. ctrl + clicking the cells (only works across the same column, or same row, not diagonally)
    On excel, this has the same effect as shift + clicking, as in it covers the range of cells from where the click starts and ends, regardless of the non selected cells in between, it is as if they are all selected.
    On google sheets, the result is more desirable, where ctrl + clicking only selects the individual cells wanted, not everything in between. Allowing you to cherry pick exactly what you need.

The significance of this is when copying via ctrl+c after a keytable focus / spreadsheet selection. The cell data can then be copied to clipboard via the keyboard, without having to toggle colvis or modify the copyHtml5 button settings. You just select the cells you want and get the plain text copied in a keystroke. Currently this only works for one cell at a time in dataTables with keyTable. How could it be done for multiple cells?

Answers

  • allanallan Posts: 63,075Questions: 1Answers: 10,384 Site admin

    Hi,

    As you say, KeyTable works with a single cell at a time. At the moment, it is not possible to select multiple cells for copying of data when using the free DataTables software.

    It might be possible create an Auto fill action to copy the selected data, but that would need to be in consecutive cells.

    Allan

Sign In or Register to comment.