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…...“EUR”,“GBP”,“USD”,“SEK”,“AUD”,“CAD”,“SGD”,“CHF”,“MXN”,“NOK”}, LEFT(H1..."EUR","GBP","USD","SEK","AUD","CAD","SGD","CHF","MXN","NOK"}, LEFT(H1...