Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

function onOpen() {


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

  SpreadsheetApp.getUi()


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

    .createMenu("✌️")


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

    .addItem("вставить функцию, заменить на значения", "myFunction")


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

    .addToUi();


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

}


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183




Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

function myFunction() {


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

  var step = 20;


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

  var n = 0;


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

  var active_range = SpreadsheetApp.getActiveRange();


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

  var sheet = active_range.getSheet();


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

  var active_range_values = active_range.getValues();


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

  var formulas = active_range_values.map(t => [`=transpose(importxml("${t[0]}";"${t[1]}"))`]);


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183




Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

  while (formulas.length) {


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

    var partFormulas = formulas.splice(0, step);


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

    var new_range = active_range.offset(n, 2, partFormulas.length, partFormulas[0].length);


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

    n += partFormulas.length;


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

    new_range.setValues(partFormulas);


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

    new_range = new_range.offset(0, 0, partFormulas.length, sheet.getLastColumn() - new_range.getColumn());


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

    new_range.setValues(new_range.getValues());


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

  }


Warning:  Undefined variable $perm in /var/www/vhosts/tiny-paste.com/httpdocs/template/ver_full.php on line 183

}