I want to get the strings in a range Range(12,3,1,4), then strip the last characters of the strings, put the last characters into an array sol[], the rest I put in another array abcd[]. I then put the values ​​of these arrays into the ranges Range(1,3,1,4) and Range(2,3,1,4). I wrote the following code to try:

function getStringDSabcs(){
  var sol = [];
  var abcd = [];
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sh = ss.getSheetByName("tests");

  const numbers2D = sh.getRange(12,3,1,4).getValues();

  const numbers1D = numbers2D.reduce((acc, row) => {
  return acc.concat(row);
}, []);
console.log(numbers1D); // [1, 2, 3, 4, 5, 6, 7, 8, 9]

numbers1D.forEach(function(number) {
  console.log(number); // In ra từng số trong mảng
  var lastChar = number.charAt(number.length - 1); 
  var firstPart = number.substring(0, number.length - 1); 
  console.log("Phần đầu mỗi chuỗi là: "+firstPart+" và phần cuối là: "+lastChar);
  sol.push(lastChar);
  abcd.push(firstPart);
  console.log(sol); 
  console.log(abcd);

});
}

This function works very well.
Now I add the rest

sh.getRange(1,3,1,4).setValues(abcd);
sh.getRange(2,3,1,4).setValues(sol);

Tức là mã của tôi là

function getStringDSabcs(){
  var sol = [];
  var abcd = [];
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sh = ss.getSheetByName("tests");

  const numbers2D = sh.getRange(12,3,1,4).getValues();

  const numbers1D = numbers2D.reduce((acc, row) => {
  return acc.concat(row);
}, []);
console.log(numbers1D); // [1, 2, 3, 4, 5, 6, 7, 8, 9]

numbers1D.forEach(function(number) {
  console.log(number); // In ra từng số trong mảng
  var lastChar = number.charAt(number.length - 1); 
  var firstPart = number.substring(0, number.length - 1); 
  console.log("Phần đầu mỗi chuỗi là: "+firstPart+" và phần cuối là: "+lastChar);
  sol.push(lastChar);
  abcd.push(firstPart);
  console.log(sol); 
  console.log(abcd);
sh.getRange(1,3,1,4).setValues(abcd);
sh.getRange(2,3,1,4).setValues(sol);

});
}

This new function doesn’t work: The execution log still says it started and finished, but the start and end are only 1 second apart. Also console.log and return values ​​are not present.
I have checked the code very carefully but don’t know where the error occurred.

I saw somewhere an article about Function does not run when calling SpreadsheetApp.getActiveSpreadsheet().getRange();. Can anyone help me with this problem? Thank you.