Nahrazeni mezer za pevne ve spreadhseetu

replaceSpaces.js

var ss = SpreadsheetApp.getActiveSpreadsheet();
var space = String.fromCharCode(32);
var nonBreakingSpace = String.fromCharCode(160);
//var nonBreakingSpace = "_";  // pro test

//hlavni funkce. Provede nahrazeni ve vsech bunkach
function replaceActiveSheet(){
  var sheet = ss.getActiveSheet()
  var range =sheet.getDataRange();
  var values = range.getValues()
  
  for(var r=0;r<values.length;r++){
    for(var c=0;c<values[0].length;c++){
      if( values[r][c] != "") {
        values[r][c] = replaceSpacesInString(values[r][c])
      }
    }
  }
  range.setValues(values);
}


//nahrazeni v jednom stringu
function replaceSpacesInString(text) {
  var chars = [ "a", "A", "i", "I", "s", "S", "z", "Z", "v", "V", "k", "K", "o", "O", "u", "U"];
  for(var i=0;i<chars.length;i++){
    var char=chars[i]
    text = text.replace(space + char + space, space + char + nonBreakingSpace );
  };
  
  return text;
}