Guest User

Untitled

a guest
Jan 18th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.03 KB | None | 0 0
  1. function myFunction() {
  2.  
  3. var r=SpreadsheetApp.getActiveSheet().getDataRange();
  4. var rws=r.getNumRows();
  5. var cls=r.getNumColumns();
  6. var i,j,a,find,repl;
  7. find="n";
  8. repl=" ";
  9. for (i=1;i<=rws;i++) {
  10. for (j=1;j<=cls;j++) {
  11. a=r.getCell(i, j).getValue();
  12. if (r.getCell(i,j).getFormula()) {continue;}
  13. try {
  14. a=a.replace(find,repl);
  15. r.getCell(i, j).setValue(a);
  16. }
  17. catch (err) {continue;}
  18. }
  19. }
  20. }
  21.  
  22. function myFunction() {
  23. var ss = SpreadsheetApp.getActiveSpreadsheet();
  24. var sheet = ss.getActiveSheet();
  25. var maxRows = sheet.getMaxRows();
  26. //Logger.log(maxRows);
  27. for (var i=2; i<=maxRows;)
  28. {
  29. sheet.insertRowAfter(i);
  30. range = 'A'+ i.toString() + ':Z' + (i+1).toString();
  31. sheet.getRange(range).mergeVertically();
  32. //sheet.setRowHeight(i+1, 1);
  33. i += 2;
  34. }
  35. }
Add Comment
Please, Sign In to add comment