B
Size: a a a
B
KS
EN
KS
KS
EN
function dataToHtmlTable_(data){
return JSON.stringify(data, null, " ")
.replace(/^\[/g, "<table>")
.replace(/\]$/g, "</table>")
.replace(/^\s\s\[$/mg, "<tr>")
.replace(/^\s\s\],{0,1}$/mg, "</tr>")
.replace(/^\s{4}"{0,1}(.*?)"{0,1},{0,1}$/mg, "<td>$1</td>");}KS
function dataToHtmlTable_(data){
return JSON.stringify(data, null, " ")
.replace(/^\[/g, "<table>")
.replace(/\]$/g, "</table>")
.replace(/^\s\s\[$/mg, "<tr>")
.replace(/^\s\s\],{0,1}$/mg, "</tr>")
.replace(/^\s{4}"{0,1}(.*?)"{0,1},{0,1}$/mg, "<td>$1</td>");}EN
var message = dataToHtmlTable_(datarange)KS
А

АВ
АВ
AI
NOT(ISBLANK(H:H)) или H:H<>''EN
EN
O
function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet()
var sheet = ss.getActiveSheet()
var range = "a1:a10"
var data = sheet.getRange(range).getValues()
var dataColour = sheet.getRange(range).getBackgrounds()
var array = []
var newArr = []
var newArrColour = []
for(var i = 0; i<data.length; i++){
array = array.concat([[dataColour[i], data[i]]])
}
var sortArray = sort(array)
for(i = 0; i<sortArray.length; i++){
newArr = newArr.concat([sortArray[i][1]])
newArrColour = newArrColour.concat([sortArray[i][0]])
}
range = "c1:c10"
sheet.getRange(range).clear()
sheet.getRange(range).setValues(newArr)
sheet.getRange(range).setBackgrounds(newArrColour)
}
function sort(arr) {
arr = arr.sort(function(a, b) {return (a[0] < b[0]) ? -1 : (a[0] > b[0]) ? 1 : 0 });
return arr
}EN
O