Incorrect import of spreadsheets with external links

Incorrect import of spreadsheets with external links

Dear Zoho Sheet Team,

I've just imported a spreadsheet with some sheets inside it, where cells have links to other sheets like:

=IF(ISNA(VLOOKUP(RC[-4],Changes!R6C[-4]:R3805C[-2],1,0)),"","EXCLUSIVE")

After import these cells don't refer to those cells, but have non-calculated formulas with that text: =IF(ISNA(VLOOKUP(RC[-4],Changes!R6C[-4]:R3805C[-2],1,0)),"","EXCLUSIVE")

If i press F2 on the particular cell and then press Enter, cell's formula has been changed to =IF(ISNA(VLOOKUP(RC[-4];Changes.R6C[-4]:R3805C[-2];1;0));"";"EXCLUSIVE")
So as you might see, the link to the sheet has been changed from Changes!R6C to Changes.RC6

After that formula is being calculated correct.

So the question is: why don't you change those links to the correct values (for your system) during import?

That's a pity i have to change all of them manually :-(

Thank you.