dbarowy / paraformula Goto Github PK

And they can take arguments that are arbitrary expressions. For example, suppose A1 contains the value 3. Then

=INDIRECT("B"&A1&":B"&(A1+3))

returns a reference to the range B3:B6.

Paraformula currently treats the : and , operators as special range syntax, which is incorrect. According to the Excel operator precedence table, they are just ordinary binary operators.

Susprise, surprise. In Excel, =2^2^3 yields 64, not 256 as one would expect. Paraformula parses exponentiation as right-associative (as one would expect), but unfortunately, this is incorrect.

An expression like =B2:B5 B4:B7 yields the intersection range B4:B5. Paraformula does not currently support this syntax. This should be implemented as suggested in #2.