excelFormulaUtilitiesJS icon indicating copy to clipboard operation
excelFormulaUtilitiesJS copied to clipboard

Throwing an error when an excel function is not supported

Open coral-re-ma opened this issue 4 years ago • 1 comments

Hi, I want to use the "formula.toJavaScript(formula)" but there are some excel functions like : ISBLANK or NOT that are not supported for js ( and cSharp). So first of all it will be great if you can add it, but anyway in order to be able to use it safely, It would be nice that when an excel function is not supported, an error will be thrown instead of copying the string as it is (e.g instead of keeping the string "NOT" inside the converted formula when NOT = "!" is not configured, throwing an unsupported function error)

Thanks!

coral-re-ma avatar May 09 '21 15:05 coral-re-ma

Check out https://formulajs.info/. This should give you a pretty complete implementation of excel formulas for JS.

joshbtn avatar May 09 '21 16:05 joshbtn