Currently the concatenation operator (&) has the same precedence as multiple/divide, whereas in Openformula and Excel it is lower priority than addition/subtraction.
e.g. In json-formula this expression: 1 + 2 & 2 * 2 returns the number 45
whereas in Excel, =1 + 2 & 2 * 2 returns the string "34"
Expected Behaviour
We should change the priority to be the same as Openformula
vdua
commented
1 year ago
Currently the concatenation operator (
&) has the same precedence as multiple/divide, whereas in Openformula and Excel it is lower priority than addition/subtraction.e.g. In json-formula this expression:
1 + 2 & 2 * 2returns the number45whereas in Excel,=1 + 2 & 2 * 2returns the string"34"Expected Behaviour
We should change the priority to be the same as Openformula