Issue 102225 - Sort not working when the fields contain formula
Summary: Sort not working when the fields contain formula
Status: CLOSED DUPLICATE of issue 101690
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-05-25 14:58 UTC by cniehaus
Modified: 2009-05-25 17:19 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Column P is not sorted (32.75 KB, image/png)
2009-05-25 14:59 UTC, cniehaus 		no flags Details
Open this file to reproduce the bug. (14.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-25 15:01 UTC, cniehaus 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description cniehaus 2009-05-25 14:58:07 UTC 
I have a table in which a number is calculated with a VLOOKUP:

=VLOOKUP(O3;Q$7:R$12;2)

The result is a number from 1 to 6. When I sort the table using that dataset the
sorting is messed up (looks random to me).

To reproduce open the attached ODS-file and try to sort column P (also tried
with column O, doesn't work either). 

I also attached a graphic how the result looks like. 

Tested on ArchLinux and Windows XP.
Comment 1 cniehaus 2009-05-25 14:59:56 UTC 
Created attachment 62504 [details]
Column P is not sorted
Comment 2 cniehaus 2009-05-25 15:01:12 UTC 
Created attachment 62505 [details]
Open this file to reproduce the bug.
Comment 3 niklas.nebel 2009-05-25 17:19:31 UTC 
Same as 101690.

*** This issue has been marked as a duplicate of 101690 ***
Comment 4 niklas.nebel 2009-05-25 17:19:47 UTC 
closing duplicate