MATCH Formula Error

Aspose.Cells Product Family
1

Hi,

Please find the attached program to simulate the below issue.
com.aspose.cells.FormulaCalcException: Invalid param’s type of function MATCH; Cell: RegionalProductionRequest!AD6=IF(AND(B6<>B5,B5<>"",(ISERROR(MATCH(B5,RegionalProductionRequest___brandtotal.brandname,0))<>TRUE)),MATCH(B5,RegionalProductionRequest___brandtotal.brandname,0),0)
at com.aspose.cells.Cell.c(SourceFile:1538)
at com.aspose.cells.Worksheet.a(SourceFile:1523)
at com.aspose.cells.Worksheets.calculateFormula(SourceFile:564)
at com.aspose.cells.Worksheet.calculateFormula(SourceFile:1499)
at devtest.AsposeVersionTest.main(AsposeVersionTest.java:41)
Exception in thread “main”

When workbook.calculateFormula() is performed, I am not getting above issue.
It is occuring when calculateFormula is performed on worksheet with arguments recursive=true and ignoreError=false;

Please help me to understand what issue is.

Thank You.
Kailas

2

Hi Kailas,

Thank you for considering Aspose.

In your template file AA6, AB6 , AC6 ,AD6 cells are using the Match formula and the lookup array for those match formulas are having errors in them. You can simply open the file in Excel and you can see that the ranges you are using in these above mentioned cells have errors. That is the reason why the CalculateFormula is showing error. Please correct the relevant fields in your template file and it will work fine.

Thank You & Best Regards,

3

Hi nausherwan,

Thanks for your quick response.

When I open the same excel in excel 2003 I am not able to see any error.

Kindly Please elaborate me the nature of the error so that I can look into that direction.

Thank You.
Kailas

4

Hi Kailas,

Thank you for considering Aspose.

I have marked the errors in your template file (attached) and you can check and correct them and try out the process again.

Thank You & Best Regards,

5

Thank You for your best Support.

Kailas