Olivier Besson gludion
gludion
/ gist:7c3b89df13fc1f1f25064adad1d7facd
Last active
May 12, 2021 16:24
Fixes broken (*) formatting rules in Google Sheets. (*) Broken = range has been messed up by cut&paste. Paste this code in Tools/Script Editor.
This file contains 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
| function onEdit(e) { | |
| checkAndFix(); | |
| } | |
| /* | |
| function onOpen() { | |
| var ui = SpreadsheetApp.getUi(); | |
| // Or DocumentApp or FormApp. | |
| ui.createMenu('Custom Tools') | |
| .addItem('Check formatting rules', 'checkAndFix') |