This library contains methods to beautify an excel formula. This library also contains functions to convert an excel formula to JavaScript (ECMAScript) or C# and python.
It is possible to become confused about which sub-expression is 'on the top' and which is 'on the bottom' in complex formulae with repeat multiply divide sequences. (excel can have un-expected priority order)
Could a mode be included to add diambiguating brackets (beautified) such that one knows which way up certain calcs are performed.
my example is:
=4.4/EXP(19*AF$7)/EXP(1350*EXP(2.2*AF$7)*$AE7)*$AK$3^2/900*$O$3
Where would you / where should I put the brackets 😃
It is possible to become confused about which sub-expression is 'on the top' and which is 'on the bottom' in complex formulae with repeat multiply divide sequences. (excel can have un-expected priority order)
Could a mode be included to add diambiguating brackets (beautified) such that one knows which way up certain calcs are performed.
my example is:
=4.4/EXP(19*AF$7)/EXP(1350*EXP(2.2*AF$7)*$AE7)*$AK$3^2/900*$O$3Where would you / where should I put the brackets 😃