Base to exponent power not converting to JS correctly

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

Base to exponent power not converting to JS correctly #19

Open joshbtn opened 11 years ago

joshbtn commented 11 years ago

Error as reported here, http://maran-emil.de/nodes/7-tools-for-better-excel-into-javascript-formula-conversion

=ROUND((P12/100+1)^(1/P13-1),6)

Expected: ROUND(Math.Pow(P12 / 100 + 1, 1 / P13 - 1)), 6)

joshbtn commented 9 years ago

Starting work on this issue. Back on this project after a long Hiatus