Bug 70407 - EDITING: Wrong sorting if complicated formulas (Sorting is correct, but wrong numbers appear)
Summary: EDITING: Wrong sorting if complicated formulas (Sorting is correct, but wrong...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.2.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-10-12 18:13 UTC by mmedek
Modified: 2013-10-13 08:21 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
On first sheet unsorted data, on second sheet sorted data by column q (in range b4-r21) - strange result in cell y13 (q13) - on third sheet (151.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-12 18:13 UTC, mmedek 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description mmedek 2013-10-12 18:13:27 UTC 
Created attachment 87527 [details]
On first sheet unsorted data, on second sheet sorted data by column q (in range b4-r21) - strange result in cell y13 (q13) - on third sheet

In attached file I tried to count 4 best results of 6 tournaments, but if some "unplayed" cells were empty, numbers from others rows appeared in my "assistant column" when sorting.
But after save and reopen correct results appear. So I have taken shot of screen and inserted it into sheet 3.

              
Operating System: Windows (other)
Version: 4.1.2.3 rc
Comment 1 m_a_riosv 2013-10-12 21:32:10 UTC 
Hi mmedek, thanks for reporting.

Please try if hard recalc [Shift+Ctrl+F0] solves the issue.
Comment 2 mmedek 2013-10-13 06:36:19 UTC 
(In reply to comment #1)
> Hi mmedek, thanks for reporting.
> 
> Please try if hard recalc [Shift+Ctrl+F0] solves the issue.



Yes, ctrl+shift+F9 solved the issue - mmedek
Comment 3 m_a_riosv 2013-10-13 08:21:43 UTC 
Some functions need a hard recalc to be updated, e.g. NOW(),