| Summary: | : Sorting on calculated values -> | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Philip Hurzeler <ph> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | jmadero.dev |
| Priority: | medium | ||
| Version: | 4.0.1.2 release | ||
| Hardware: | Other | ||
| OS: | Windows (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
This is definitely a duplicate, I will search for the dupe |
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