Share via

3.2.3.1.7 R1C1 formulas

  • Article

In R1C1 formulas, R1C1-style references shall be used instead of A1-style references.

An R1C1 formula has the following form:

 R1C1-formula=
 R1C1-expression ;
 R1C1-expression=
 {space}, nospace-R1C1-expression, {space};
 nospace-R1C1-expression=
 "(", R1C1-expression,  ")"  | 
 constant  | 
 prefix-operator, R1C1-expression  | 
 R1C1-expression,  infix-operator, R1C1-expression  | 
 R1C1-expression,  postfix-operator  | 
 R1C1-cell-reference  |
 R1C1-function-call  | 
 name-reference  |
 structure-reference ;
 R1C1-function-call=
   function-name,  "(",  R1C1-argument-list,  ")" ;
 R1C1-argument-list=
 R1C1-argument,  {  comma,  R1C1-argument  } ;
 R1C1-argument=
 [R1C1-expression] ;
 R1C1-cell-reference=
 [sheets-prefix]  R1C1-reference ;