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

Free Support Forum - aspose.com

Additional @ symbol is added with Excel formula while exporting to Excel

I have used a formula like below, means when there is sheetname soon after the ‘=’ sign then additional symbol ‘@’ comes it self while exporting the excel.

e.g:
string strFormula = "IFERROR(IF(MATCH(1,(D1=‘sheet name’!D:D)*…so on

but in excel file this formula comes like:
"IFERROR(IF(MATCH(1,(D1=@‘sheet name’!D:D)*…so on

means extra @ comes itself. so cell formula doesn’t work.

Can someone please help on it,

@anjali.b,

Please try our latest version/fix (Aspose.Cells v21.9.x) if you are not already using it. If you still find the issue with latest version, kindly create a standalone console application (runnable), zip the project to post us with template Excel files. We will check your issue soon.

By the way, if this is an array formula, you may try to use SetArrayFormula() method instead of Formula attribute.

1 Like

Yes, it worked, Many thanks.

@anjali.b,

Good to know that latest version fixes your issue now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.