Steps to reproduce:
1. Put 5 in a1, 10 in a2, 15 in a3, =a1 in a4, =a2 in a5, =a3 in a6
2. Put 1 in b1, 2 in b2, 3 in b3, 4 in b4, 5 in b5, 6 in b6
3. Sort range a1..b6 on column a
Current behavior: #REF! in some cells, wrong sort results.
Expected behavior: Calculate to get numbers, sort on the numbers, in sorted results replace the numbers with the formulas that generated them.
Operating System: Windows 7
Version: 126.96.36.199 release
This is definitely a duplicate, I will search for the dupe
*** This bug has been marked as a duplicate of bug 45146 ***