2.1.865 Part 1 Section 18.17.2.3.2, R1C1-Style Cell Reference

  • Article

a.   The standard does not use EBNF to specify the productions for R1C1-reference.

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

 R1C1-reference=
   R1C1-row-only    |  
   R1C1-column-only    |  
   R1C1-cell, ":", R1C1-cell |
   R1C1-cell ;
 R1C1-cell=
   R1C1-row,  R1C1-column  ;
 R1C1-row-only=
   "R",  R1C1-absolute-number,   |  
   "R[",  R1C1-relative-number, "]"  ;
 R1C1-row=
   R1C1-relative-row  |  
   R1C1-absolute-row  ;
 R1C1-relative-row= "R"    |
   "R[",  R1C1-relative-number, "]"  ;  
 R1C1-absolute-row=
   "R", R1C1-absolute-number  ; 
 R1C1-column-only=
   "C",  R1C1-absolute-number  |  
   "C[",  R1C1-relative-number,  "]"  ;
 R1C1-column=
   R1C1-relative-column  |  
   R1C1-absolute-column  ;
 R1C1-relative-column= "C"    |
   "C[",  R1C1-relative-number,  "]"  ;
 R1C1-absolute-column= "C", R1C1-absolute-number  ;
 R1C1-relative-number=
   ["-"], digit-sequence   ;
 R1C1-absolute-number=                                  
   digit-sequence  ;  (* must be nonzero; see A1-Style Cell References  ("[ISO/IEC-29500-1] §18.17.2.3.1") *)

b.   The standard states that a negative offset indicates a row to the left or a column above, and a positive offset indicates a row to the right or a column below.

In Office, a negative offset indicates a column to the left or a row above, and a positive offset indicates a column to the right or a row below.