Code
function messageSetValueIncludeNewLine() {
const Spread = SpreadsheetApp.getActiveSpreadsheet();
const Sheet = Spread.getSheetByName('sheet-name');
const by_value = Sheet.getRange(vertical_position, horizontal_position);
const past_range = Sheet.getRange(vertical_position, horizontal_position);
const message = '<hello>' + String.fromCharCode(10) + by_value.getValue();
past_range.setValue(message);
}
what intention ?
This code will help you want to display a message containing a line break based on a particular cell.
This code will help you if you want to display a message containing a line break based on a particular cell.