Write a formula to a Cell

Aspose.Cells Product Family
1

Hello,

When i try to write that formula "=INDEX(rrrrrr!$A$1:$A$2;MATCH(T9;rrrrrr!$B$1:$B$2;))" to Cell "U9" returns me that error: "Error in Cell: U9-Invalid formula:"=INDEX(rrrrrr!$A$1:$A$2;MATCH(T9;rrrrrr!$B$1:$B$2;))".", but if i copy the formula directly to Excel, works.

Thanks.

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please provide us your simple source xls/xlsx file with this formula so that we could look into this issue at our end.

Please also download and try the latest version: Aspose.Cells
for .NET v7.3.4.3 to see if it resolves your issue or not.

3

Hi,


Please use “,” as separator in the formula instead of “;”.

Please change your formula e.g
"=INDEX(rrrrrr!$A$1:$A$2;MATCH(T9;rrrrrr!$B$1:$B$2;))“
to:
”=INDEX(rrrrrr!$A$1:$A$2,MATCH(T9,rrrrrr!$B$1:$B$2;))"

Thank you.