pasteFnct

/*
✅ Канал о Таблицах: https://t.me/google_sheets
✅ Чат: https://t.me/google_spreadsheets_chat
✅ Оглавление канала: https://goo.gl/HdS2qn
*/

function pasteFnct(e) {
  const value = e.value;
  if (value.slice(0, 2) == '_=') {
    const fnct = value.substring(2, value.length);
    const ss = e.source;
    const active_cell = e.range;
    const sh_active = ss.getActiveSheet();
    const sh_temp = ss.getSheetByName('temp') || ss.insertSheet('temp');
    sh_temp.getRange("a1").setFormula(fnct);
    SpreadsheetApp.flush();
    const values = sh_temp.getRange(1, 1, sh_temp.getLastRow(), sh_temp.getLastColumn()).getValues();
    sh_temp.clear();
    active_cell.setNote(fnct).offset(0, 0, values.length, values[0].length).setValues(values);
  }
};