I would like to prevent OpenOffice Calc or Microsoft Excel from updating absolute references when their target cells are moved.
For example, if cell B2 is "=$A$1" and you cut A1 and paste it in A2, B2 now says "=$A$2".
Is there any way to prevent this? It very easily leads to corruption of my carefully-crafted spreadsheets. (According to the OO.o issue tracker, it's a feature…)