I am a beginner and need to write a simple script to paste special values in Google Sheets. I tried the below script, but it's not working.

function livedata_Function() {
    var spreadsheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Live_Data");
    spreadsheet.getRange('L3:T1378').copyTo(spreadsheet.getRange("K3"), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);

Your code seems fine. Perhaps the cells in the target range already have some formats that get automatically applied to the data that you paste as values only?

  • Nope. Values not getting pasted at all. – RP-2020 Jul 19 at 3:23
  • Consider sharing a publicly editable sample spreadsheet with realistic-looking data. – doubleunary Jul 19 at 13:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.