Created attachment 105590 [details]
a spreadshheet to reproduce the bug

Problem description: 
In some columns of a spreadsheet, A to K, I load some values.
In subsequent columns, L to Q, there are formulas that make some simple computation on the cells of the columns A to K.
The cells in columns A to K are not protected. The cells in columns L to Q are protected.
Now, I select a rectangular block of value cells (some rows, columns A to K), and make a row reordering (based on some value in a column from A to K): the formulas in the columns L to Q change reference. They "follow" the "value" cells, instead of being unchanged. To have no errors I must unprotect the spreadsheet and select all the columns for the row reordering.

Steps to reproduce:
1. Load and open the test file I have loaded
2. Select from column A to column K, from row 5 to row 14
3. Select Data, Order, choose column J as order key, and order

Current behavior:
The formulas in the columns from L to Q change the reference to the corresponding cells. For instance formula in cell L5 becomes H14-I14, and so on.

Expected behavior:
Cells in columns L to Q should be unchanged. For instance, after reordering, cell L5 should be H5-I5, as before partial ordering.

The only way to reorder without errors is select all the columns for row reorder.
Operating System: Windows XP
Version: 4.3.1.2 release
Last worked in: 4.1.6.2 release