2.1.568 Part 1 Section 18.2.5, definedName (Defined Name)

  • Article

a.   The standard states that the contents of this element are an extension on the ST_Formula simple type.

Excel requires the contents of this element to follow the grammar for a name formula, as defined in Name Formulas (§3.2.3.1.4, Name Formulas).

b.   The standard says that @customMenu is used.

In Excel, @customMenu is reserved and unused.

c.   The standard says that @description is used.

In Excel, @description is reserved and unused.

d.   The standard says that @help is used.

In Excel, @help is reserved and unused.

e.   The standard says that @statusBar is used.

In Excel, @statusBar is reserved and unused.

f.   The standard says that @shortcutKey is used.

In Excel, @shortcutKey is reserved and unused.

g.   The standard says that @xlm is used.

In Excel, @xlm is reserved and unused.

h.   The standard says that @vbProcedure is used.

In Excel, @vbProcedure is reserved and unused.

i.   The standard says that @functionGroupId is used.

In Excel, @functionGroupId is reserved and unused.

j.   The standard does not limit the length of the value of the comment attribute.

Excel restricts the value of this attribute to be at most 255 characters before escaping.

k.   The standard does not limit the length of the value of the name attribute.

Excel restricts the value of this attribute to be at least 1 and at most 255 characters.

l.   The standard specifies localSheetID is the sheet index in this workbook where data from an external reference is displayed.

Office uses this index for sheet-local names to specify the sheet on which the name is defined.

m.   The standard states that built-in names reserved by SpreadsheetML begin with _xlnm.

Office assumes that all names that being with _xl are restricted.

n.   The standard does not state restrictions around uniqueness of definedName elements.

If the attribute @localSheetId is used on a definedName, the defined name is local and its @name must be unique among the other defined names for the sheet ID. If the @localSheetId attribute is not used, the defined name must be unique among the other defined names that do not use the attribute.

o.   The standard makes no mention of an xml:space attribute.

Excel uses this attribute to specify, using the W3C space preservation rules, how white space should be handled for the element's contents; its allowed values are defined by the XML 1.0 specification.

p.   The standard says that @function is used.

In Excel, @function is reserved and unused.

q.   The standard states that the values of the name attribute are defined by the ST_Xstring simple type.

Excel requires the value of this attribute to meet the restrictions defined in Names ("[ISO/IEC-29500-1] §18.17.2.5").

r.   The standard states that the values of the localSheetId attribute are defined by the XML Schema unsignedInt datatype.

Excel restricts the value of this attribute to be at most 32766.