^-operator to javascript not translated

joshbtn / excelFormulaUtilitiesJS

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.

http://excelformulabeautifier.com/

Other

394 stars 101 forks source link

^-operator to javascript not translated #62

Open bspoel opened 7 years ago

bspoel commented 7 years ago

When converting the formula '=A1^2' to javascript, it gives 'A1^2' as the result, but ^ in javascript is the bitwise XOR operator. It should be 'Math.pow(A1, 2)'

joshbtn commented 7 years ago

Thanks for the feedback! This is related to a very old issue I haven't been able to crack yet. https://github.com/joshbtn/excelFormulaUtilitiesJS/issues/19