So copying cells with CTRL-C in HOT does this by default where if I copy a range of cells and paste it into excel, it will paste into the same range cells (ie: copy a row of 5 cells, I paste in Excel and get a row of 5 cells). How can I do this in HOT using a button that will get whatever the user has selected and do the same for Excel?
EDIT: I found and realized that you can access the CopyPaste plugin so I do what is already being done for CTRL-C, so I don’t have to reinvent the wheel. Problem is that my hotInstance.copyPaste does not have the copy(), paste(), or cut() functions, just the remaining ones, and hotInstance.getPlugin(‘CopyPaste’) returns undefined. Any ideas why?
Thank you. On Version 1.10.1
EDIT 2: No matter what I do, how many newlines or line break I add to my string before using document.execCommand(‘copy’), I can’t get a selection of cell data on different rows to appear on different rows on Excel the way CTRL-C can. What is Handsontable doing different?