SetDefinedNameOptions
type SetDefinedNameOptions<AbortOnError> = object;Type Parameters
Section titled “Type Parameters”AbortOnError
Section titled “AbortOnError”AbortOnError extends true | false = false
Properties
Section titled “Properties”abortOnError?
Section titled “abortOnError?”abortOnError?: AbortOnError;Return null and make no change if the formula has any errors, rather than making the defined
name anyway and recording the error with addError.
Default
Section titled “Default”falsequalifyUnprefixedReferences?
Section titled “qualifyUnprefixedReferences?”qualifyUnprefixedReferences?: boolean;Name the first sheet explicitly in any reference of a workbook-scoped name that names an address but no sheet. Set false to store the formula exactly as given.
Default
Section titled “Default”truesheet?
Section titled “sheet?”sheet?: WorkSheet | null;Sheet to scope the name to, or null for workbook scope.
Default
Section titled “Default”nullvalidateNow?
Section titled “validateNow?”validateNow?: boolean;Validate the formula here. Set false only if the caller takes that on itself.
Default
Section titled “Default”true