2.1.894 Part 4 Section 3.17.2.5, Names

a.   The standard does not use EBNF to write the syntax for name.

Office writes the productions for name using the following EBNF:

 name-reference= name |
   external-name;
 external-name= single-sheet-prefix, name;
 name=
   name-start-character, [ name-characters ]  ;
 name-start-character=
   underscore  |  backslash  |  ? any code points which are characters as defined by the Unicode character properties, chapter four of the Unicode Standard ?;
 underscore=
   "_"  ;
 backslash=
   "\"  ;
 name-characters=
   name-character,  {name-character}  ;
 name-character=
   name-start-character  |  decimal-digit  |  full-stop  |  ? any code points which are digits as defined by the Unicode character properties, chapter four of the Unicode standard ?;

b.   The standard specifies that two names that are the same in different workbooks can be disambiguated by prepending the workbook name.

Office prefixes names used in the same context with the index of the relationship ID associated with the workbook name and an exclamation mark. A relationship ID index of 0 indicates the current workbook.

c.   The standard does not specify that \name-character is an invalid name.

Office will not create or load names of the form \name-character.

Show: