Export (0) Print
Expand All
Expand Minimize

2.1.855 Part 1 Section 18.17.2.3.1, A1-Style Cell References

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  ; 
Show:
© 2014 Microsoft