title: google sheets scritp : create a loop to open each sheet, select all and copy/paste only value without formulas. thank you
body: <p>I have a big google sheet file with +- 420 sheets
  So I have to give my colleague without formulas and if it is possible not to do it manually, it will be great for me.</p>
  <p>I would like to have a script to open the sheet, select all ( ctrl+a) , copy and paste without formulas ( ctrl+shift+v)
  close the sheet and next.</p>
  <p>So I need to make a script with a loop to solve this problem and all the operations.</p>
  <p>I have already found a script to have all the sheets in a list.</p>
  <pre><code>  function sheetnames() { 
    var out = new Array()
    var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
    for (var i=0 ; i&lt;sheets.length ; i++) out.push( [ sheets[i].getName() ] )
    return out  
  }
  </code></pre>
  <p>that is ok.</p>
  <p>and the screenshot is the list of sheets in my file.
  It is in the sheet &quot;for_script&quot; in the file &quot;Entrainements 2021 2022&quot;</p>
  <p><a href="https://i.stack.imgur.com/ENXDT.png" rel="nofollow noreferrer">list of sheets</a></p>
  <p>thank you so musch for you help.
  Jérôme challe</p>