Hi,
I’m attempting to use just the hot-formula-parser package to parse some Excel-like formulas, but I’m constantly getting an error on the following formula:
HLOOKUP(1, [[1],[2]], 2)
As per your unit tests, this should yield 2, but it doesn’t (see: Formula.js - Test - Lookup Reference (L50). )
Any chance you could help me out? I’ve reproduced the error in this stackblitz.
Thank you very much!
PS: Link to the Github issue.
PS2: Link to HandsOnTable JS Fiddle with formula support.
Hi,
HLOOKUP is supported by formula.js but not by formula-parser: https://github.com/handsontable/formula-parser/issues/11
Kind regards,
Wojciech
Hi Wojciech,
Thanks for the reply!
Would you be so kind as to point to me how would I use formula.js to parse HLOOKUPs inside a formula?
Thanks again!
Jorge
Hey @jorge.s
I have discussed the topic with Wojciech. It looks like it would take us some time to test some approaches. However as we are currently working on a new formula engine that would not do us any favours.
Please send me a message at support@handsontable.com
I will save your email among those users who would be the first to know about the new formulas.