Issue 102997 - Sorting on ranges that contains cells with vlookup function belongs to other worksheet returns wrong results
Summary: Sorting on ranges that contains cells with vlookup function belongs to other ...
Status: CLOSED DUPLICATE of issue 101690
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO310m11
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-06-22 11:17 UTC by wipe
Modified: 2009-06-22 17:08 UTC (History)
1 user (show)

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

Attachments
vlookup_test.ods (7.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-06-22 11:19 UTC, wipe 		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 wipe 2009-06-22 11:17:41 UTC 
When sorting a range , if one of the columns contains vlookup function belongs 
to other worksheet, the values of these cells are not updated as expected, and 
they display wrong results.

In attached file 'vlookup_test.ods':
- sorting on worksheet1 'B3:C4' by column 'b' descending, the result is ok,
- when you do the same thing on worksheet2, the result - the cells in column c -
 are wrong. The first argument of vlookup points to wrong cell.

The only difference between the two worksheets is that the vlookup function's 
matrix table is on worksheet1.
Comment 1 wipe 2009-06-22 11:19:57 UTC 
Created attachment 63131 [details]
vlookup_test.ods
Comment 2 niklas.nebel 2009-06-22 17:07:41 UTC 
Same as 101690.

*** This issue has been marked as a duplicate of 101690 ***
Comment 3 niklas.nebel 2009-06-22 17:08:07 UTC 
closing duplicate