Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

2.1.892 Part 4 Section 3.17.2.3.2, R1C1-Style Cell Reference

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  (“[ECMA-376] Part 4 §3.17.2.3.1; A1-Style Cell References”) *)

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.