pfelipm

## fxCONTARCOLORv2.gs
/**
 * Realiza un recuento o calcula la suma o el promedio de los valores de las celdas
 * que tienen un color de texto o fondo determinado. Versión modificada de la función
 * CONTARCOLOR incluida en HdCPlus (https://workspace.google.com/marketplace/app/hdc+/410659432888),
 * ahora:
 *
 *   - Admite, además del recuento, la suma y el promedio de valores de celda según color.
 *   - Se usa el método getFontColorObject() para obtener el color de fuente, en lugar del obsoleto getFontColor().
 *   - Se admite la indicación del color con el que buscar coincidencias sin el "#" inicial.
 *   - Se generaliza la comprobación de colores HEX añadiendo "FF" como valor de transparencia si asHexString() no la devuelve.

## instalarAutoFirma.sh
sudo apt update
sudo apt -y install default-jre
sudo apt -y install binutils
sudo apt -y install zstd
wget https://estaticos.redsara.es/comunes/autofirma/currentversion/AutoFirma_Linux_Debian.zip
unzip AutoFirma_Linux_Debian.zip
ar x AutoFirma_*.deb
zstd -d < control.tar.zst| xz > control.tar.xz
zstd -d < data.tar.zst| xz > data.tar.xz
ar -m -c -a sdsd AutoFirma_repacked.deb debian-binary control.tar.xz data.tar.xz

## Bookmarklets left panel GAS IDE
// Create a new bookmark in your browser using any of these URLs | @pfelipm 06/02/23
// Demo: https://twitter.com/pfelipm/status/1622395953721364481

// 1. Toggles the side panel out of view
javascript:(function() {const style = document.querySelectorAll('div[jsname="Iq1FLd"]')[0].style;if (style.display == 'none') style.display = '';else style.display = 'none';})()

// 2. Allows the side panel to shrink down to 150px when resizing window
javascript:(function() {const style = document.querySelectorAll('div[jsname="Iq1FLd"]')[0].style;if (style.minWidth == "150px") style.minWidth = "225px";else style.minWidth = "150px";})()

// 3. Resizes the side panel to the width specified by a JS prompt

## fxParseJson.gs
/**
 * Parses a JSON string and returns a single element designated by its full path.
 * Mimics Coda's ParseJSON (https://coda.io/formulas#ParseJSON) formula.
 * @param   {A2:A3} jsonData  Source JSON string or data interval containing JSON strings to parse.
 * @param   {A5:A6} fullPath  Path string or data interval of paths to use for extraction, use ".number" for array elements.
 * @param   {false} stringify Optional, false (default) if result should be stringified only if it is an object.
 * @return  Extracted primitive value or stringified representation, if array or object.
 *
 * @customfunction
 *

## Check user onOpen workflow.gs
/**
 * Demo authorization workflow that checks whether the current user can run this Apps Script, uses
 * the Admin SDK Directory Advanced Service
 * Twitter thread here: https://twitter.com/pfelipm/status/1576954653425618945
 * @pfelipm (OCT/22)
 *
 * @OnlyCurrentDoc
 */


## Reset slicers.gs
/**
 * Resets all slicers in the active sheet using the Apps Script Spreadsheet Service.
 *
 * Context:
 *
 * Calling setColumnFilterCriteria(columnPosition, null) or trying to modify
 * in some other way the current filter criteria of a slicer whose criteria
 * has already been set manually (using the GUI) won't have any effect.
 * So, this function clones & deletes all slicers, instead.
 *

## getGroupsRecursively.gs
/**
 * Recursively gets all groups that a given user/group is a member
 * of, either directly or indirectly, in a GWS domain.
 *
 * -OR-
 *
 * checks whether user/group is a member of provided group,
 * both tasks support external users to the domain.
 * Uses the AdminDirectory advanced service, and should be invoked by domain Admins!
 *

## TOC custom fx.gs
/**
 * Builds a TOC in the spreadsheet.
 *
 * Pablo Felip (@pfelipm).
 *
 * @param {true} includeId Include sheet ID
 * @param {true} includeUrl Include link to sheet
 * @return List of [Sheet name, Sheet ID, Sheet URL]
 * @customfunction
 */

## fxRepetirFilas.gs
/**
 * Repite cada fila un nº indicado de veces
 * @param {A2:C4} intervaloDatos Intervalo de datos cuyas filas se van a repetir
 * @param {D2:D4} colRepeticiones Vector columna que indica el nº de veces a repetior cada fila
 * @customfunction
 */
function repetirFila(intervaloDatos, colRepeticiones) {

  // ⚠️ ¡Se debería realizar un control de errores sobre los parámetros de la función!

## ButtonLock.gs
/**
 * Simple demonstration of LockService...
 * https://developers.google.com/apps-script/reference/lock
 * ...to prevent concurrent executions of a GAS function,
 * for example when invoked by a button in a Spreadsheet (rather likely).
 * Demo: https://docs.google.com/spreadsheets/d/1n_7nZIi5QtN9URzsKdFW6WtSxPM9uUK3QhQSbzbltHg
 *
 * @OnlyCurrentDoc
 */
	/**
	* Realiza un recuento o calcula la suma o el promedio de los valores de las celdas
	* que tienen un color de texto o fondo determinado. Versión modificada de la función
	* CONTARCOLOR incluida en HdCPlus (https://workspace.google.com/marketplace/app/hdc+/410659432888),
	* ahora:
	*
	* - Admite, además del recuento, la suma y el promedio de valores de celda según color.
	* - Se usa el método getFontColorObject() para obtener el color de fuente, en lugar del obsoleto getFontColor().
	* - Se admite la indicación del color con el que buscar coincidencias sin el "#" inicial.
	* - Se generaliza la comprobación de colores HEX añadiendo "FF" como valor de transparencia si asHexString() no la devuelve.
	sudo apt update
	sudo apt -y install default-jre
	sudo apt -y install binutils
	sudo apt -y install zstd
	wget https://estaticos.redsara.es/comunes/autofirma/currentversion/AutoFirma_Linux_Debian.zip
	unzip AutoFirma_Linux_Debian.zip
	ar x AutoFirma_*.deb
	zstd -d < control.tar.zst\| xz > control.tar.xz
	zstd -d < data.tar.zst\| xz > data.tar.xz
	ar -m -c -a sdsd AutoFirma_repacked.deb debian-binary control.tar.xz data.tar.xz
	// Create a new bookmark in your browser using any of these URLs \| @pfelipm 06/02/23
	// Demo: https://twitter.com/pfelipm/status/1622395953721364481

	// 1. Toggles the side panel out of view
	javascript:(function() {const style = document.querySelectorAll('div[jsname="Iq1FLd"]')[0].style;if (style.display == 'none') style.display = '';else style.display = 'none';})()

	// 2. Allows the side panel to shrink down to 150px when resizing window
	javascript:(function() {const style = document.querySelectorAll('div[jsname="Iq1FLd"]')[0].style;if (style.minWidth == "150px") style.minWidth = "225px";else style.minWidth = "150px";})()

	// 3. Resizes the side panel to the width specified by a JS prompt
	/**
	* Parses a JSON string and returns a single element designated by its full path.
	* Mimics Coda's ParseJSON (https://coda.io/formulas#ParseJSON) formula.
	* @param {A2:A3} jsonData Source JSON string or data interval containing JSON strings to parse.
	* @param {A5:A6} fullPath Path string or data interval of paths to use for extraction, use ".number" for array elements.
	* @param {false} stringify Optional, false (default) if result should be stringified only if it is an object.
	* @return Extracted primitive value or stringified representation, if array or object.
	*
	* @customfunction
	*
	/**
	* Demo authorization workflow that checks whether the current user can run this Apps Script, uses
	* the Admin SDK Directory Advanced Service
	* Twitter thread here: https://twitter.com/pfelipm/status/1576954653425618945
	* @pfelipm (OCT/22)
	*
	* @OnlyCurrentDoc
	*/
	/**
	* Resets all slicers in the active sheet using the Apps Script Spreadsheet Service.
	*
	* Context:
	*
	* Calling setColumnFilterCriteria(columnPosition, null) or trying to modify
	* in some other way the current filter criteria of a slicer whose criteria
	* has already been set manually (using the GUI) won't have any effect.
	* So, this function clones & deletes all slicers, instead.
	*
	/**
	* Recursively gets all groups that a given user/group is a member
	* of, either directly or indirectly, in a GWS domain.
	*
	* -OR-
	*
	* checks whether user/group is a member of provided group,
	* both tasks support external users to the domain.
	* Uses the AdminDirectory advanced service, and should be invoked by domain Admins!
	*
	/**
	* Builds a TOC in the spreadsheet.
	*
	* Pablo Felip (@pfelipm).
	*
	* @param {true} includeId Include sheet ID
	* @param {true} includeUrl Include link to sheet
	* @return List of [Sheet name, Sheet ID, Sheet URL]
	* @customfunction
	*/
	/**
	* Repite cada fila un nº indicado de veces
	* @param {A2:C4} intervaloDatos Intervalo de datos cuyas filas se van a repetir
	* @param {D2:D4} colRepeticiones Vector columna que indica el nº de veces a repetior cada fila
	* @customfunction
	*/
	function repetirFila(intervaloDatos, colRepeticiones) {

	// ⚠️ ¡Se debería realizar un control de errores sobre los parámetros de la función!
	/**
	* Simple demonstration of LockService...
	* https://developers.google.com/apps-script/reference/lock
	* ...to prevent concurrent executions of a GAS function,
	* for example when invoked by a button in a Spreadsheet (rather likely).
	* Demo: https://docs.google.com/spreadsheets/d/1n_7nZIi5QtN9URzsKdFW6WtSxPM9uUK3QhQSbzbltHg
	*
	* @OnlyCurrentDoc
	*/