Code
Hub
Workspaces
Following
Trending
Connect
MCP
copy
Create free account
hub
/
github.com/Max-Makhrov/GoogleSheets
/ functions
Functions
186 in github.com/Max-Makhrov/GoogleSheets
⨍
Functions
186
◇
Types & classes
1
Function
TESTconvertArrayToObject
()
data/2dArray.js:856
Function
TESTextrectColumnsByIds
()
data/2dArray.js:358
Function
TESTextrectColumnsByIdsFill
()
data/2dArray.js:435
Function
TESTextrectColumnsFromTableData
()
data/2dArray.js:286
Function
TESTfill
()
data/2dArray.js:621
Function
TESTfillRight
()
data/2dArray.js:651
Function
TESTfillRight2d
()
data/2dArray.js:679
Function
TESTfilter2dArray
()
data/Filter2dArrays.js:58
Function
TESTgetFileName
()
drive/DriveApp.js:107
Function
TESTgetFormulas
()
sheets/Formulas.js:109
Function
TESTgetFormulizer
()
data/Filter2dArrays.js:173
Function
TESTgetRandomArray
()
data/Arrays.js:204
Function
TESTgetRandomArrayOfIntegers
()
data/Arrays.js:232
Function
TESTgetSheetsInfo
()
sheets/Sheets.js:132
Function
TESTgetTableDescription
()
data/DataTypes.js:7
Function
TESTgetValueDirectly
()
other/TimeTests.js:66
Function
TESTgetValueImport
()
other/TimeTests.js:50
Function
TESTleftJoinArrays
()
data/2dArray.js:771
Function
TESTlistFilesInFolder
()
drive/DriveApp.js:20
Function
TESTtokenizer
()
data/Filter2dArrays.js:735
Function
TESTunpivot
()
data/2dArray.js:152
Function
TESTunpivotTable
()
sheets/UnpivotTable.js:125
Function
TESTwriteDataIntoSheet
()
sheets/Sheets.js:73
Function
TESTwriteReadProps
()
other/PropertuesService.js:52
Function
TIME_TESTgetValue
()
other/TimeTests.js:89
Function
TableInfo
(fileId, sheetId)
sheets/Importer.js:538
Function
TablesInfo
(fileIds, sheetIds, firstDataRows, idColumns, headerCols, originSheetIds)
sheets/Importer.js:471
Function
Tokenizer
()
data/Filter2dArrays.js:660
Function
addHeader
(header)
utils/tabulize.js:9
Function
appendColumns
(currentValue, index)
data/2dArray.js:535
Function
appendValues
(currentValue)
data/2dArray.js:568
Function
buildFormulas
(idFile, strSheet, formulas, cells)
sheets/Formulas.js:132
Function
check
(elt, i)
data/Arrays.js:111
Function
checkRowDv
(row, rowHead)
sheets/onEdit.js:136
Function
concatMergedArray_
(array)
data/2dArray.js:984
Function
copySheet
(SS, strToCopy, strName)
sheets/Sheets.js:235
Function
deleteEmptyCells
()
sheets/Sheets.js:270
Function
deleteTriggerOnHour_
(functionName)
sheets/Triggers.js:76
Function
filterClasses
(value, index)
data/Filter2dArrays.js:292
Function
getDvValue
(e)
sheets/onEdit.js:109
Function
getObjectsValueSafe_
(obj, keys)
data/snippets/getObjectVelueSafe.js:35
Function
getSheetContent
(SS, strSheet, numRow, numCol, numRows, numCols)
sheets/Ranges.js:13
Function
getTableDescriptions
(files, headers)
data/DataTypes.js:36
Function
getUnpivot
* Convert wide table into normal view. * * @param {range} sheet Name of sheet. * @param {range} header1 Range name of header1: left part of the
sheets/UnpivotTable.js:150
Function
getUserProperty
(key)
other/PropertuesService.js:121
Function
importSource
(tableId, userTableIds, update)
sheets/Importer.js:287
Function
importSources
(tableIds, userTableIdss, updates)
sheets/Importer.js:253
Function
importUser
(tableId, tableIdSource, checkFields, killSource, importType, strMacroBefore, strMacroAfter)
sheets/Importer.js:381
Function
importUsers
(tableIds, tableIdSources, checkFieldss, killSources, importTypes, strMacroBefores, strMacroAfters)
sheets/Importer.js:330
Function
importer
()
sheets/Importer.js:94
Function
makeTasks
(sheet)
sheets/Tasker.js:139
Function
makeTasksClearContents
(range)
sheets/Tasker.js:59
Function
makeTasksClearDataValidation
(range)
sheets/Tasker.js:60
Function
makeTasksDataValidation
(range, data, key)
sheets/Tasker.js:61
Function
makeTasksSetValue
(range, data, key)
sheets/Tasker.js:62
Function
readSettings
()
other/PropertuesService.js:41
Function
returnKey_
(row)
data/2dArray.js:1018
Function
returnValue
()
data/2dArray.js:613
Function
setId
(numRow, numColId, strRangeIdFree)
sheets/onEdit.js:196
Function
setSpreadsheetTrigger_
* function to create a trigger of selected type * * ss - Spreadsheet id * name - Trigger Function Name * type - Type of trigger * * Suppo
sheets/Triggers.js:103
Function
setTimeStamp
(numRow, numCol)
sheets/onEdit.js:223
Function
setTriggerOnEdit
(nameFunction)
sheets/Triggers.js:15
Function
setTriggerOnHour_
(functionName)
sheets/Triggers.js:50
Function
smallDiscovery
()
sheets/onEdit.js:125
Function
tabulize_
* @param {Object[]} objects * * @returns {String[][]}
utils/tabulize.js:6
Function
test_ObjectOnEdit
()
sheets/onEdit.js:24
Function
test_PasteInfo
()
sheets/Importer.js:796
Function
test_TablesInfo
()
sheets/Importer.js:454
Function
test_addTask
()
sheets/Tasker.js:80
Function
test_combine2DArrays
()
data/2dArray.js:176
Function
test_filterArraysByKeyArray
()
data/Arrays.js:95
Function
test_get2DArrayColumn
()
data/2dArray.js:456
Function
test_get2DArrayDifference
()
data/2dArray.js:890
Function
test_getFilled2DArray
()
data/Arrays.js:243
Function
test_getLine
()
data/2dArray.js:873
Function
test_getRangeValuesMapR1C1
()
sheets/Ranges.js:43
Function
test_getSheetById
()
sheets/Sheets.js:192
Function
test_getSubTaskA1Ranges
()
sheets/Tasker.js:400
Function
test_importUser
()
sheets/Importer.js:421
Function
test_importUsers
()
sheets/Importer.js:316
Function
test_importer
()
sheets/Importer.js:43
Function
test_intersection
()
data/Arrays.js:127
Function
test_join2Arrays
()
data/2dArray.js:994
Function
test_joinArrays
()
data/2dArray.js:954
Function
test_macroAfter
()
sheets/Importer.js:89
Function
test_macroBefore
()
sheets/Importer.js:83
← previous
101–186 of 186, ranked by callers