Unlike most other types of Apps Scripts, custom functions never ask users to authorize access to personal data. Consequently, they can only call services that do not have access to personal data, specifically the following:
Supported services Notes Cache Works, but not particularly useful in custom functions HTML Can generate HTML, but cannot display it (rarely useful) JDBC Language Lock Works, but not particularly useful in custom functions Maps Can calculate directions, but not display maps Properties Spreadsheet Read only (can use most get*()methods, but notset*()).
Cannot open other spreadsheets (SpreadsheetApp.openById()
orSpreadsheetApp.openByUrl()).URL Fetch Utilities XML
Можно ли себя называть миддлом, если твой код говно?
как писать поддерживаемый код?
Анализ всех гаджетов с помощью тестера показал, что нажатие кнопки замыкает контакт микрофона и «землю» (1 и 2 на схеме)
=MAX(ARRAYFORMULA(LEN(SPLIT(JOIN("",FILTER(--(A:A = "cat"),A:A<>"")),"0"))))
=MAX(ARRAYFORMULA(LEN(SPLIT(JOIN("",FILTER(--(A:A = "dog"),A:A<>"")),"0"))))
function MAX_THE_SAME(input, search) {
if (!input) return "Нет данных";
if (!(input instanceof Array)) return "Выбрана одна ячейка";
var current;
var count = 0;
var max = 0;
for(var x=0; x<input[0].length; x++) {
current = null;
for(var y=0; y<input.length; y++) {
var val = input[y][x];
if (!val && val !== 0 || search && val!=search) {
current = null;
continue;
}
val = val.toString();
if (current !== val) {
current = val;
count = 0;
}
count++;
if (max < count) max = count;
}
}
return max;
}=MAX_THE_SAME(A:A)=MAX_THE_SAME(A:A;"dog")
