Hi.
I use Spire.XLS to set a cell formula as "=INDEX(E:E,1+MATCH(,COUNTIF(N$1:N4,E$2:E$1952),))&\"\"" then save the workbook.
But when I open the workbook manually, the formula of the cell becomes: =@INDEX(E:E,1+MATCH(,COUNTIF(N$1:N4,@E$2:E$1952),))&""
There are unexpected @ characters appear in Formula, and the value can't be evaluated.
What I missed? How can I solve it?