I have added below 2 formulas in cell using aspose cells API (sample excel is attached with this ticket),
Column Q on US tab:
Column Q on Global tab:
But on the Global tab the added formula gets local file download directory path added the formula and the formula value gets changed to,
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.