Copy Values and Formulas Between Spreadsheets
A question on StackOverflow made me realize that there seems to be no method to copy values and formulas between ranges in different spreadsheets. Using setValues() just transfers values, including the final result of formulas. On the other hand, using setFormulas() just transfers formulas, leaving blank cells that don’t have formulas. If the ranges are […]
Copy Values and Formulas Between Spreadsheets Read More »