Used for runtime reflection.
Listen for changes to the named ranges.
Add a named range. This is case insensitive; must be unique, and must not have any spaces. This will throw an error if the name is invalid or already exists,
If true will replace hidden ranges if one already exists.
true
Returns a set of ranges from an address. Will return null if not a valid address.
This does not resolved named ranges.
Remove a named range.
The range to remove
Given the name return a valid name that closely matches.
Optional template: stringLoads value from JSON, this will clear any existing state
Lookup a named range with a given name.
This is case insensitive.
Lookup a named range by SheetRangeCoords. This will only return a match if all the ranges are exact matches.
Optional description: stringSearch the named items. These are sorted by type then by name.
Serialize the state
Updates a named range. This allows for the original name to be changed.
The original name
Validate that the NamedItem. This is identical to addNamedItem but without actually trying.
The range to validate
The scope of the range.
If true then won't check to see if the name is already used for hidden ranges.
This will throw an error if the sheetName is invalid.
true
null
Holds a collection of named ranges