Export (0) Print
Expand All

3.2.3.1.7 R1C1 formulas

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