Issue 103043 - BAD DATA SORTING AND FORMULAS TRASPOSITION
Summary: BAD DATA SORTING AND FORMULAS TRASPOSITION
Status: CLOSED DUPLICATE of issue 101690
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO310m11
Hardware: HP (PA-RISC) Linux, all
: P4 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-06-23 16:48 UTC by pella
Modified: 2009-06-24 02:22 UTC (History)
2 users (show)

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

Attachments
This is the file that show the BUG. TRY to order, in the sheet1, the colmuns B,C,D in CRESCENT order (Data -> Order > ...) and see the hated "data scrambling" (7.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-06-23 16:56 UTC, pella 		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 pella 2009-06-23 16:48:27 UTC 
OpenOff. CALC 3.1 (not in 3.0.1 and older)

I have 2 sheet;
the first sheet contain data oprdered in columns and "FIND" formulas (function)
that refear to the second sheet; all the "FIND" formulas ( 
=CERCA($A$3;Foglio2.$A$2:$A$4;Foglio2.$B$2:$B$4) ) have the $ for lock the cell
position.

When i try to ORDER the columns es: A, B and C in crescent or decrescent mode,
the "FIND Formulas" don't sink with the real cell, with the result of a total
data scramblimng.

...i'll try to attach a file that explain well what i'm telling.
Comment 1 pella 2009-06-23 16:56:33 UTC 
Created attachment 63174 [details]
This is the file that show the BUG. TRY to order, in the sheet1, the colmuns B,C,D in CRESCENT order (Data -> Order > ...) and see the hated "data scrambling"
Comment 2 wope 2009-06-24 02:19:10 UTC 
it is a duplicate ti issue 101690 

*** This issue has been marked as a duplicate of 101690 ***
Comment 3 wope 2009-06-24 02:22:20 UTC 
closed