google spreadsheet - moveTo messing up cells outside the range -
im rearranging spreadsheet using google script. first sorting , moving rows within range end of sheet. everytime moveto function cells reference moved rows changed reflect new row numbers though cells outside range , should not modified. example if im moving cell b3 , have cell f4 =b3 when move b3 cell f4 changes whatever b3 now. tried locking =b$3 still didnt work. messes conditional formatting should in place entire column using "d2:e" , changes "d2:e109" or similar. clue whats going on? function onedit(){ var sheet = spreadsheetapp.getactivespreadsheet().getactivesheet(); var allowedsheet = 1; if(sheet.getindex() == allowedsheet) { var editedcell = sheet.getactivecell(); var sortby = [1, 3, 2]; var triggercol = [1,2,3,10,11,12]; var rangestart = "a"; var rangeend = "e"; var tablerange = "a2:e"; if(triggercol.indexof(editedcell.getcolumn()) > -1) { var range = sheet.getrange(tableran...