Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@adomasven
Last active March 21, 2019 09:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save adomasven/7c014d510d01e1b2f8ac246bcceaa871 to your computer and use it in GitHub Desktop.
Save adomasven/7c014d510d01e1b2f8ac246bcceaa871 to your computer and use it in GitHub Desktop.
Remove named range duplicates
function removeDuplicateRanges() {
while (true) {
var doc = DocumentApp.getActiveDocument();
var nameToRanges = {}
doc.getNamedRanges().forEach(function(namedRange) {
if (nameToRanges[namedRange.getName()]) {
nameToRanges[namedRange.getName()].push(namedRange)
} else {
nameToRanges[namedRange.getName()] = [namedRange]
}
});
var removedRanges = 0
for (var name in nameToRanges) {
for (var i = 0; i < nameToRanges[name].length-1; i++) {
nameToRanges[name][i].remove();
removedRanges++;
}
if (removedRanges > 5) break;
}
if (!removedRanges) {
break;
} else {
doc.saveAndClose();
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment