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 ;