Issue 23069 - wrong sort result
Summary: wrong sort result
Status: CLOSED DUPLICATE of issue 23089
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: niklas.nebel
QA Contact: issues@sc
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2003-12-01 18:43 UTC by Unknown
Modified: 2003-12-11 16:21 UTC (History)
1 user (show)

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

Attachments
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 Unknown 2003-12-01 18:43:09 UTC 
when I sort result of formulas wich are linked to values external to the actual 
sheet, if I use relative references to the external values, I obtain strange 
results.
I expect from the sort or to work perfectly, mantaining all links or to not 
work at all, not updating the links.

Instead i found that a part of the links are updated and a part are exchange 
with a strange permutation order.

In my examples
sheet1
Nome	1	2	3	4
				
Uno	58	98	100	25
Due	55	95	88	100
Tre	65	66	77	88

sheet2
Nome	Media	100	Volte
			
Uno	70,25	1	4
Due	84,5	1	4
Tre	74	0	4

media:Average()
100(Count.if
volte (Count.values)

if I try to order, for example the 3 column
i obtain in the formulas area
Sheet1.B4:E3 (should be B4:E4 if updates perfectly or B3:e3 without updating)
Sheet1.B5:E4 (should be B5:E5 if updates perfectly or B4:e4 without updating)
Sheet1.B3:E5 (should be B3:E3 if updates perfectly or B5:e5 without updating)

So I think this is a bug
Comment 1 utomo99 2003-12-02 10:27:15 UTC 
please attach the documents, so we can test and confirm it easier 
and faster. Thanks
Comment 2 frank 2003-12-08 13:28:28 UTC 
Hi,

this is a problem of relative and absolute addressing.

Relative means take the value from 1 place down or right or ... whatever
direction the reference goes. This goes also for the arrays. To prevent this,
use absolute references (a $ in front of the references e.g. =average($A1:$A5) )

Frank

Hi Niklas,

Excel gives an other result. Please have a look.

Frank
Comment 3 niklas.nebel 2003-12-11 16:20:26 UTC 
Same as 23089.

*** This issue has been marked as a duplicate of 23089 ***
Comment 4 niklas.nebel 2003-12-11 16:21:04 UTC 
closing.