New a workbook and fill col(A) with row number.
Copy the first cell of col(A).
New a workbook and paste it as link to any cell.
--> the link is like “cell://[Book1]Sheet1!A[1]“
In Book1, insert a column in the left of col(A). Then check the link address.
==> It still refer to the old location A[1], which should be B[1] now.
Fixed in Origin 2025b.