Hello Team,
I have added below 2 formulas in cell using aspose cells API (sample excel is attached with this ticket),
Column Q on US tab:
cell.setFormula("=IFERROR(VLOOKUP(D"+rowCounter+",Global!D:BM,13,FALSE),\"\")");
Column Q on Global tab:
cell.setFormula("=IFERROR(VLOOKUP(D"+rowCounter+",USA!D:V,16,FALSE),\"0\")");
But on the Global tab the added formula gets local file download directory path added the formula and the formula value gets changed to,
=IFERROR(VLOOKUP(D5,'C:\Users\689997\Downloads\[USA]USA'!D:V,16,FALSE),"0")
Due to above change vlook function is not working.
I am attaching sample excel report file for your understanding. Please let us know why we’re getting this issue.
Regards,
Pavan