vinci1it2000 / formulas

Excel formulas interpreter in Python.
https://formulas.readthedocs.io/
European Union Public License 1.1
358 stars 75 forks source link

Question: How to ignore invalid formula #108

Closed masykur8d closed 10 months ago

masykur8d commented 2 years ago

I am using the formulas library and come across the invalid formula error. I have read the documentation and the other issues here but I did not found any relevant answer.]

The error looks like this:

FormulaError: ('Not a valid formula:\n%s', '=IFERROR(IF(COUNTIF(F5,"*中*"),"-",IF(U5>=G5,IF(MATCH(M5,【車検A軍】ラベルリスト!$A:$A,0)-1=0,INDEX(【車検A軍】ラベルリスト!$A:$A,MATCH(M5,【車検A軍】ラベルリスト!$A:$A,0)),INDEX(【車検A軍】ラベルリスト!$A:$A,MATCH(M5,【車検A軍】ラベルリスト!$A:$A,0)-1)),F5)),"error")')

Is there a way to ignore the error?

the code looks like this:

xl_model = formulas.ExcelModel().loads(path2).finish()
xl_model.calculate()
xl_model.write(dirpath=path1)
vinci1it2000 commented 2 years ago

Can you share the input file?

vinci1it2000 commented 10 months ago

Special characters【】 broke the parser. Use normal characters.