Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const RESTRICTEDROWS = new Set([1, 2]);
- function areEqual(r1, r2) {
- // Func for checking equality of two ranges
- return r1.getDataSourceUrl() === r2.getDataSourceUrl()
- }
- function onEdit(e) {
- if (e.value == undefined || RESTRICTEDROWS.has(e.range.getRow()) ) {
- // If the event is not EDITING for the value of cell then exit
- return;
- }
- // Initial range
- const range = e.range;
- // Current sheet for working
- const ss = range.getSheet();
- // Total amount of all columns
- const MAXCOLUMNS = ss.getMaxColumns();
- const STARTINGROW = 2;
- // Index of the initial row
- var idx_init_row = range.getRow();
- // Initial row
- var initRange = ss.getRange(idx_init_row, 1, 1, MAXCOLUMNS);
- Logger.log(initRange.getA1Notation());
- // Copy of values from the initial row
- const values = initRange.getValues();
- // Cell of first row for column of initial range
- var top_cell_range = ss.getRange(1, range.getColumn());
- // Delete the initial row
- ss.deleteRow(idx_init_row);
- // Insert row before starting row;
- ss.insertRowBefore(STARTINGROW);
- // First row
- var targetRange = ss.getRange(STARTINGROW, 1, 1, MAXCOLUMNS);
- Logger.log(targetRange.getA1Notation());
- // Setting values for the first row
- targetRange.setValues(values);
- }
Advertisement
Add Comment
Please, Sign In to add comment