Get formula not only values

140 views
Skip to first unread message

Denis Dal Soler

unread,
Sep 12, 2022, 4:20:43 AM9/12/22
to Google Apps Script Community
Hey guys
Can I get not only the values from a sheet but the formula too?
Now I use
Riga = MGestioneEV.getDataRange().offset(posizione,0,1,159).getValues() 
but this delete all the formulas in the MGestioneEV range
Thanks
Denis

Tanaike

unread,
Sep 12, 2022, 4:40:46 AM9/12/22
to Google Apps Script Community
How about using getFormulas() instead of getValues()? https://developers.google.com/apps-script/reference/spreadsheet/range#getformulas
Reply all
Reply to author
Forward
0 new messages