We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Write a formula to a Cell


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 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.


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

Please change your formula e.g

Thank you.