Bug 62490 - : Sorting on calculated values ->
Summary: : Sorting on calculated values ->
Status: RESOLVED DUPLICATE of bug 45146
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2013-03-18 19:48 UTC by Philip Hurzeler
Modified: 2013-04-16 23:14 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Philip Hurzeler 2013-03-18 19:48:49 UTC
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: release
Comment 1 Joel Madero 2013-04-16 23:13:01 UTC
This is definitely a duplicate, I will search for the dupe
Comment 2 Joel Madero 2013-04-16 23:14:51 UTC

*** This bug has been marked as a duplicate of bug 45146 ***