pfelipm
/ formatocondicional.gs
Last active
December 13, 2024 11:38
Ejemplo de generaci贸n automatizada de reglas de formato condicional en Google Sheets con Apps Script | Example of automatically generating conditional formatting rules in Google Sheets using Apps Script.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Genera reglas de formato condicional sobre las celdas indicadas para modificar | |
| * sus colores de fondo de acuerdo con la paleta seleccionada en el desplegable de referencia | |
| * @OnlyCurrentDoc | |
| */ | |
| function generaReglasFormatoCondicional() { | |
| const hoja = SpreadsheetApp.getActive().getSheetByName('SPARKLINE_BARRAS'); | |
| const celdasObjetivo = ['C5', 'D5', 'E5', 'F5', 'G5']; | |
| const paletas = [ |
pfelipm
/ fxCONTARCOLORv2.gs
Last active
January 22, 2024 18:56
Funci贸n personalizada Apps Script para hojas de c谩lculo CONTARCOLOR (v2)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * 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. Tambi茅n puede simplemente devolver | |
| * los valores que cumplan la condici贸n de color para que puedan ser utilizados en cualquier | |
| * f贸rmula. | |
| * | |
| * 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. |
pfelipm
/ instalarAutoFirma.sh
Last active
September 24, 2024 14:51
Este script instala el cliente Linux de AutoFirma y Firefox ESR en tu dispositivo ChromeOS. Soluciona el error "archive uses unknown compression for member control.tar.zst" al instalar el paquete DEB de AutoFirma. Ejecuta el script en el terminal de comandos Linux de tu chromecosa e instala a continuaci贸n tus certificados digitales en Firefox.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
pfelipm
/ Bookmarklets left panel GAS IDE
Last active
June 14, 2023 19:18
Four bookmarklets to toggle / shrink / resize the left panel (and top section) of the Google Apps Script IDE
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 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.querySelector('div[jsname="Iq1FLd"]').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.querySelector('div[jsname="Iq1FLd"]').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 |
pfelipm
/ fxParseJson.gs
Last active
August 13, 2023 16:12
PARSEJSON Apps Script custom function for Google Sheets
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * 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 | |
| * |
pfelipm
/ Check user onOpen workflow.gs
Last active
October 3, 2022 15:59
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * 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 | |
| */ | |
pfelipm
/ Reset slicers.gs
Last active
November 23, 2021 17:04
Reset all slicers in the current sheet of a Google Spreadsheet
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * 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. | |
| * |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * 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! | |
| * |
pfelipm
/ TOC custom fx.gs
Last active
November 22, 2021 20:08
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * 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 | |
| */ |
pfelipm
/ fxRepetirFilas.gs
Last active
May 23, 2021 22:27
Funci贸n personalizada para HdC repetirFilas()
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * 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! |
NewerOlder