search

aidhound / hotxlfp

A Python Excel Formula Parser similar to the javascript handsontable formulaparser
MIT License
27 stars 12 forks source link

not work XLError('#NAME?') #2

Closed SovBur closed 3 years ago

SovBur commented 3 years ago

Hello. The exception ('#NAME?') does not work in the following cases: p = hotxlfp.Parser() formula = p.parse("MY_VAR") print(formula['error'])

expected to get an error '#NAME?', but None.

Also: formula = p.parse("MY_VAR + 5") print(formula['result'])

expected to get an result 'None', but 5.

leonelcamara commented 3 years ago

Good catch! I'll fix it.

SovBur commented 3 years ago

Thanks