excelFormulaUtilitiesJS
excelFormulaUtilitiesJS copied to clipboard
joshbtn
Based on ewbi's go calc excel formula parser http://ewbi.blogs.com/develops/popular/excelformulaparsing.html. This library contains methods to beautify an excel formula. This library also contains fu...
Hi, I am unable to get correct no of tokens with escape when my string contains escape charector. eg : ``` var str = 'FOO "\"hello world\""'; var items =...
I get the following error: ``` $ mocha --opts .mocharc app /client/node_modules/excel-formula/index.js:9 xl = excelFormulaUtilities; ^ ReferenceError: excelFormulaUtilities is not defined at Object. (/client/node_modules/excel-formula/index.js:9:3) at Object. (/client/node_modules/excel-formula/index.js:24:4) at Module._compile (internal/modules/cjs/loader.js:688:30)...
Please assign a different color to each opening and closing parentheses if you can. Thank you
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...
I put in the following formula: ` =IF(IF(ISERROR(SEARCH("bh", A6)), -1, SEARCH("bh", A6)) >=0, "Birmingham", IF(IF(ISERROR(SEARCH("sh", A6)), -1, SEARCH("sh", A6)) >=0, "Sheffield", IF(IF(ISERROR(SEARCH("lon", A6)), -1, SEARCH("lon", A6)) >=0, "London", "Unknown")))` However...
Hello, When I use getTokens() if a formula that contains an array of arrays, apparently it's unable to recognise that is an array of arrays. Example: var tokens = formula.getTokens('VLOOKUP(2,[[2,3,4],[5,6,7]],...
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)'
``` =IF(A149="","",MAX(IF(Input!$E$11+BI!AB149>Input!$K$3,0,OFFSET(Proj!$M$1,BI!AB149*12,0))+IF(Input!$E$11+BI!AB149>Input!$J$74,0,Input!$I$74)+IF(AB149>Input!$K$76,0,ROUND((1-(1+Input!RT_INT)^-(Input!RT_term-AB149+1))/(1-(1+Input!RT_INT)^-Input!RT_term),4)*Input!SA_RT),ROUND(OFFSET(Proj!$CH$1,BI!AB149*12,0),-2)+IF(Input!$E$11+BI!AB149>Input!$J$74,0,Input!$I$74)+IF(AB149>Input!$K$76,0,ROUND((1-(1+Input!RT_INT)^-(Input!RT_term-AB149+1))/(1-(1+Input!RT_INT)^-Input!RT_term),4)*Input!SA_RT))) ``` It does't indent the -2 in `ROUND` properly unless it's a positive number.
I'd like to have a drop down to configure: Indent with tabs or spaces? Then: How many spaces? Please! Great tool!
