gnumeric incorrectly increments if pointing to another page when you insert another cell.

If you have data on sheet#2 (example numbers 1 and 2)
cell A1= 1
cell A2= 2

and you have pointers on another sheet (sheet#1)
cell A1 =Sheet2!A1  (points to sheet#2 cell A1)
cell A2 =Sheet2!A2  (points to sheet#2 cell A2)

then the error occurs if you insert a cell at A2 on sheet#1
Go to menu and click Insert->Cells, then select "down"

Now A2 is empty which is okay, but A3 is incorrectly pointing at A3 on sheet#2 because A3 now holds =Sheet2!A3.
The correct value should have remained as =Sheet2!A2 since no insert was actually performed on Sheet#2.

Just-as-a-note: Gnumeric appears to perform correctly the other way around if A2 was inserted on Sheet#2 (Sheet1!A2 was correctly updated).