HyperFormula - "Parsing error" debugging

Tags: #<Tag:0x00007f8b1ccbb408>
#1

image
image.png1229×264 12.9 KB

I’m getting this parsing error, but I can’t figure out why.

Heres is the excel file: https://docs.google.com/spreadsheets/d/1FhMF-iSqvSij117K47bsb0jsAigqT5fX/edit?usp=sharing&ouid=100520076069216889096&rtpof=true&sd=true

dpsP1!B29 formula:
=OR(Sheet1!$B$75=npcStats!A526;AND(Sheet1!B38=Items!A166;Sheet1!B75=npcStats!A461);AND(B53;B24;C9>IF(B7;19;59));Sheet1!B75=npcStats!A525)

I’ve checked the cell references in the formula and they are working fine.

#2

Hi @reinhardtrijna

Methods are used correctly. Here https://codesandbox.io/s/dreamy-brook-43cf4?file=/src/hyperformulaConfig.js:411-416 is the same set of methods (just a different formula).

There has to be an issue within the formula you have in that cell.

Ps. please get in touch with us at support@handsontable.com with questions related to Hyperformula use.

#3