Problem description: 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: 4.0.1.2 release
This is definitely a duplicate, I will search for the dupe
*** This bug has been marked as a duplicate of bug 45146 ***