MCPcopy Create free account

hub / github.com/Max-Makhrov/GoogleSheets / functions

Functions186 in github.com/Max-Makhrov/GoogleSheets

↓ 6 callersFunctioncheckColDv
(col, cols, delim)
sheets/onEdit.js:154
↓ 3 callersFunctionaddValuesToArray
(arr1, arr2)
data/2dArray.js:563
↓ 3 callersFunctiongetEmails
(users)
drive/DriveApp.js:81
↓ 3 callersFunctiongetNode
(node, row)
data/Filter2dArrays.js:488
↓ 3 callersFunctiongetToken
(token, row)
data/Filter2dArrays.js:439
↓ 3 callersFunctionr
()
data/Array_Polyfills.js:92
↓ 3 callersFunctionreplaceAll
(str, find, replace)
data/Strings.js:51
↓ 3 callersFunctiontranspose
(a)
data/2dArray.js:29
↓ 3 callersFunctionunpivot
(head1, data1, head2, data2, labels)
data/2dArray.js:125
↓ 2 callersFunctionaddTask
(keyTask, keyData, numRow, numCols, data)
sheets/Tasker.js:103
↓ 2 callersFunctionbyteCount
(str)
data/Strings.js:34
↓ 2 callersFunctionchunkString
* Splits string into equal parts. * * @param {string} str The string to chunk. * @param {number} length The length of parts. * @return Array - str
data/Strings.js:9
↓ 2 callersFunctionchunkStringParts
(str, parts)
data/Strings.js:18
↓ 2 callersFunctionconvertArrayToObject
(arr, keyColumns)
data/2dArray.js:823
↓ 2 callersFunctioncreateSheetIfNotExists
(ss, name)
sheets/Sheets.js:254
↓ 2 callersFunctionextrectColumnsByIdsFill
(data, columns)
data/2dArray.js:400
↓ 2 callersFunctionextrectColumnsFromTableData
(data, columns)
data/2dArray.js:256
↓ 2 callersFunctionfillRight2d
(arr)
data/2dArray.js:672
↓ 2 callersFunctionfilter2dArray
(array, formula)
data/Filter2dArrays.js:89
↓ 2 callersFunctionget2ArraysEquals
(arr1, arr2)
data/Arrays.js:33
↓ 2 callersFunctionget2DArrayDifference
(ids, array, idIndex)
data/2dArray.js:898
↓ 2 callersFunctiongetEditObject
* Test function for onEdit. Passes an event object to simulate an edit to * a cell in a spreadsheet. * * Check for updates: https://stackoverflow.c
sheets/onEdit.js:10
↓ 2 callersFunctiongetFilled2DArray
(value, w, h)
data/Arrays.js:249
↓ 2 callersFunctiongetFormulizer
(formula)
data/Filter2dArrays.js:238
↓ 2 callersFunctiongetPropertyAsArray
(key)
other/PropertuesService.js:138
↓ 2 callersFunctiongetSheetById
(fileId, sheetId)
sheets/Sheets.js:199
↓ 2 callersFunctiongetSheetsInfo_
(fileId)
sheets/Sheets.js:153
↓ 2 callersFunctiongetSubTaskA1Ranges
(oSubTaskRows)
sheets/Tasker.js:422
↓ 2 callersFunctiongetTableDescription
(file, rHeaders)
data/DataTypes.js:93
↓ 2 callersFunctionisCallable
(fn)
data/Array_Polyfills.js:9
↓ 2 callersFunctionjoin2Arrays_
(index, arr1, arr2)
data/2dArray.js:1013
↓ 2 callersFunctionrunFunctionByName
(name)
sheets/Importer.js:237
↓ 2 callersFunctiontimingDecorator
(f, timer)
other/TimeTests.js:16
↓ 1 callersFunctionadd
(arg1, arg2)
data/Filter2dArrays.js:643
↓ 1 callersFunctionaddColumnsToArray
(arr1, arr2)
data/2dArray.js:530
↓ 1 callersFunctionarrayIntersection
()
data/Arrays.js:145
↓ 1 callersFunctionbuildFormula
(cell, formula)
sheets/Formulas.js:155
↓ 1 callersFunctioncheckEqual
(arg1, arg2)
data/Filter2dArrays.js:640
↓ 1 callersFunctioncheckLess
(arg1, arg2)
data/Filter2dArrays.js:638
↓ 1 callersFunctioncheckLessEqual
(arg1, arg2)
data/Filter2dArrays.js:639
↓ 1 callersFunctioncheckMore
(arg1, arg2)
data/Filter2dArrays.js:636
↓ 1 callersFunctioncheckMoreEqual
(arg1, arg2)
data/Filter2dArrays.js:637
↓ 1 callersFunctioncheckTriggerExists
(nameFunction, triggerSourceType)
sheets/Triggers.js:32
↓ 1 callersFunctioncombine2DArrays
(arrays)
data/2dArray.js:199
↓ 1 callersFunctiondeleteEmptyCellsSheet_
(sheet)
sheets/Sheets.js:278
↓ 1 callersFunctionextrectColumnsByIds
(data, columns)
data/2dArray.js:336
↓ 1 callersFunctionfill
(arr, value)
data/2dArray.js:611
↓ 1 callersFunctionfillRight
(arr)
data/2dArray.js:641
↓ 1 callersFunctionfilterArraysByKeyArray
(key, value, arrays)
data/Arrays.js:109
↓ 1 callersFunctionfilterByCols
(columns)
data/2dArray.js:348
↓ 1 callersFunctionfilterLab
(formula)
data/Filter2dArrays.js:95
↓ 1 callersFunctionflatten_
* @param {Object} obj * * @returns {Object}
utils/tabulize.js:39
↓ 1 callersFunctionget1DArray
(arr)
data/2dArray.js:78
↓ 1 callersFunctionget2DArrayColumn
(array, indx)
data/2dArray.js:467
↓ 1 callersFunctiongetDataType
(value)
data/DataTypes.js:222
↓ 1 callersFunctiongetDataTypes
(data)
data/DataTypes.js:183
↓ 1 callersFunctiongetFieldTypes
(FieldTypes, colIds)
sheets/Importer.js:723
↓ 1 callersFunctiongetFileName
(id)
drive/DriveApp.js:115
↓ 1 callersFunctiongetFolders
(object)
drive/DriveApp.js:122
↓ 1 callersFunctiongetFormulaTokenizer
()
data/Filter2dArrays.js:327
↓ 1 callersFunctiongetFormulas
* Get 2d array with results like this: * row column formula * 1 1 = B1 + C1 * 2 1 = B2 + C2 * 3 1
sheets/Formulas.js:20
↓ 1 callersFunctiongetFormulasSheets
(sheets)
sheets/Formulas.js:37
↓ 1 callersFunctiongetFormulasSheets_
(data, strSheet, i)
sheets/Formulas.js:60
↓ 1 callersFunctiongetFormulas_
(data, skipHeaders)
sheets/Formulas.js:85
↓ 1 callersFunctiongetIsland
()
sheets/Importer.js:758
↓ 1 callersFunctiongetLine
(array)
data/2dArray.js:878
↓ 1 callersFunctiongetRandomArray
(n)
data/Arrays.js:193
↓ 1 callersFunctiongetRandomArrayOfIntegers
(n, min, max)
data/Arrays.js:218
↓ 1 callersFunctiongetRangeValuesMapR1C1
(range, values)
sheets/Ranges.js:58
↓ 1 callersFunctiongetSheetsInfo
(ids)
sheets/Sheets.js:102
↓ 1 callersFunctiongetSubTask
(oSubTask)
sheets/Tasker.js:317
↓ 1 callersFunctiongetSubTaskRows
(oSubTask)
sheets/Tasker.js:351
↓ 1 callersFunctiongetTaskMaker
(oTasks)
sheets/Tasker.js:264
↓ 1 callersFunctionisTriggerHere_
(functionName, eventType, triggerSource)
sheets/Triggers.js:63
↓ 1 callersFunctionjoinArrays_
(index, arrays)
data/2dArray.js:976
↓ 1 callersFunctionleftJoinArrays
(arr1, arr2, columns1, columns2)
data/2dArray.js:736
↓ 1 callersFunctionlistFilesInFolder
(id, sheetName)
drive/DriveApp.js:36
↓ 1 callersFunctionmakeDvFromList
(range, list, note)
sheets/DataValidation.js:1
↓ 1 callersFunctionmakeTasksFunctions
(func, sheet, ranges, data, key)
sheets/Tasker.js:224
↓ 1 callersFunctionmerge2dArrays
(arrFrom, arrTo, numIdColTo, fieldTypes, columns)
sheets/Importer.js:641
↓ 1 callersFunctionmultiply
(arg1, arg2)
data/Filter2dArrays.js:644
↓ 1 callersFunctionsameValueZero
(x, y)
data/Array_Polyfills.js:285
↓ 1 callersFunctionsetPropertyFromNamedRange
(SS, strRange, key)
other/PropertuesService.js:87
↓ 1 callersFunctionsetUserProperty
(value, key)
other/PropertuesService.js:96
↓ 1 callersFunctiontoInteger
(value)
data/Array_Polyfills.js:12
↓ 1 callersFunctiontoLength
(value)
data/Array_Polyfills.js:19
↓ 1 callersFunctionunpivotTable
(file, strHead1, strHead2Start, strLabels)
sheets/UnpivotTable.js:77
↓ 1 callersFunctionwriteDataIntoSheet
(file, sheet, data, rowStart, colStart)
sheets/Sheets.js:40
↓ 1 callersFunctionwriteSettings
()
other/PropertuesService.js:30
FunctionFormulizer
()
data/Filter2dArrays.js:423
FunctionIsland
(From, To)
sheets/Importer.js:790
FunctionObjectOnEdit
(e)
sheets/onEdit.js:39
FunctionPaster
(idsFrom, idsTo)
sheets/Importer.js:751
FunctionTESTGetFormulasSheets
()
sheets/Formulas.js:29
FunctionTESTaddToArray
()
data/2dArray.js:488
FunctionTESTarrayCompare
()
data/Arrays.js:19
FunctionTESTbyteCount
()
data/Strings.js:37
FunctionTESTcheckCol
()
sheets/onEdit.js:237
FunctionTESTchunkString
()
data/Strings.js:12
FunctionTESTchunkStringParts
()
data/Strings.js:24
next →1–100 of 186, ranked by callers