Script to copy only the result of a cell with embedded formula

Asked Sep 19 '20 at 12:30

Active Sep 19 '20 at 23:10

Viewed 41 times

function copyCell() {
  var thisBook = SpreadsheetApp.getActive();
  var thisSheet = thisBook.getSheetByName('Filt_N');
  thisSheet.getRange(1, 1).getvalue();
}

I want to make a button that will copy the value of a single cell without pasting anywhere. I do not know how to continue this script.

Any help would be appreciated. Thanks!

edited Sep 19 '20 at 20:28

TheMaster

45,448
6
62
85

asked Sep 19 '20 at 12:30

AU CH

1

What do you want to do this copied content? Related: https://stackoverflow.com/a/57682572/ – TheMaster Sep 19 '20 at 20:26
just to copy the value to window clipboard. Is this possible? – AU CH Sep 20 '20 at 09:52
Yes. See the link above. But you would need 2 button clicks. One to open the modal dialog and another to copy to clipboard. – TheMaster Sep 20 '20 at 10:14

Script to copy only the result of a cell with embedded formula

0 Answers0