Created attachment 105590 [details]
a spreadshheet to reproduce the bug
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
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.
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: 22.214.171.124 release
Last worked in: 126.96.36.199 release
Thank you for the report. However, this was previously noticed in Bug 81633 - Sorting shouldn't always automatically adjust references.
Set status to Duplicate.
*** This bug has been marked as a duplicate of bug 81633 ***
thanks for your comment.
I added this bug because my test seemed to me lightly different from 81633 (wrong result if order of part of columns, right if all columns), but, really, as you noted, in fact it is the same problem. So, thanks for your note and for setting it as duplicate.
Migrating Whiteboard tags to Keywords: (possibleRegression)