2.1.864 Part 1 Section 18.17.2.3.1, A1-Style Cell References

  • Article

a.   The standard does not specify the productions for A1-reference using EBNF.

Office writes the productions for A1-reference using the following EBNF:

 A1-reference=
   A1-column,  ":",  A1-column    |  
   A1-row,  ":", A1-row    |  
   A1-cell, ":", A1-cell |
   A1-cell ;
 A1-cell=
   A1-column,  A1-row;
 A1-column=
   A1-relative-column  |  
   A1-absolute-column  ;
 A1-relative-column=
   letter, {letter}  ;  (* see semantic rules for A1-Style Cell References  ("[ISO/IEC-29500-1] §18.17.2.3.1") *)
 letter=
   "A"|"B"|"C"|"D"|"E"|"F"|"G"|"H"|"I"|"J"|"K"|"L"|"M"|
   "N"|"O"|"P"|"Q"|"R"|"S"|"T"|"U"|"V"|"W"|"X"|"Y"|"Z"|
   "a"|"b"|"c"|"d"|"e"|"f"|"g"|"h"|"i"|"j"|"k"|"l"|"m"|
   "n"|"o"|"p"|"q"|"r"|"s"|"t"|"u"|"v"|"w"|"x"|"y"|"z"  ;
 A1-absolute-column=
   "$", A1-relative-column  ; 
 A1-row=
   A1-relative-row  |  
   A1-absolute-row  ;
 A1-relative-row=
   digit-sequence  ;  (* must be nonzero; see A1-Style Cell References  ("[ISO/IEC-29500-1] §18.17.2.3.1") *)
 A1-absolute-row=
   “$”, A1-relative-row  ;