Hello,
I am using Aspose.Cells 25.6 for Java. To calculate formulas in my workbook, I call Workbook.calculateFormula(). I have the following formula:
=MATCH(TRUE, ISNUMBER(SEARCH({“JPY”,“KRW”,“CNY”,“BRL”,“EUR”,“GBP”,“U…...“SGD”,“CHF”,“MXN”,“NOK”}, LEFT(H1,7))), 0) When cell H1 contains the..."SGD","CHF","MXN","NOK"}, LEFT(H1,7))), 0) returns #ERROR ! when calculated...