title: Can we call the function "Show formulas" in Google app script for Spreadsheet
body: <p>I am currently working on a script for a google spreadsheet. This script compares two sheets together and applies changes based on the differences between these sheets. First, I take the data from the sheets and put them in an <strong>array</strong> then i compare them and apply the changes before pasting them on their original sheets.</p>
  
  <p>My problem is that there are <strong>formulas that fill the some cells</strong> of my sheets. However, when I run my script, it only reads the data that appears in the cells and so the formulas are deleted once the script is finished. However I'd like to keep these formulas on my sheets ..</p>
  
  <p>To solve the problem I <em>"show formulas" (Ctrl + `)</em> before launching the script, so the script reads the formulas instead of the cells' value. </p>
  
  <p>I would like to call this function <em>"Show Formulas" (Ctrl + `)</em> from my google script, is it possible? If yes, how?</p>
  
  <p>Thank you in advance,</p>
  
  <p>Victor</p>