Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function myFunction() {
- var r=SpreadsheetApp.getActiveSheet().getDataRange();
- var rws=r.getNumRows();
- var cls=r.getNumColumns();
- var i,j,a,find,repl;
- find="n";
- repl=" ";
- for (i=1;i<=rws;i++) {
- for (j=1;j<=cls;j++) {
- a=r.getCell(i, j).getValue();
- if (r.getCell(i,j).getFormula()) {continue;}
- try {
- a=a.replace(find,repl);
- r.getCell(i, j).setValue(a);
- }
- catch (err) {continue;}
- }
- }
- }
- function myFunction() {
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheet = ss.getActiveSheet();
- var maxRows = sheet.getMaxRows();
- //Logger.log(maxRows);
- for (var i=2; i<=maxRows;)
- {
- sheet.insertRowAfter(i);
- range = 'A'+ i.toString() + ':Z' + (i+1).toString();
- sheet.getRange(range).mergeVertically();
- //sheet.setRowHeight(i+1, 1);
- i += 2;
- }
- }
Add Comment
Please, Sign In to add comment