Issue 103615 - Data sort function with formula for 3.x
Summary: Data sort function with formula for 3.x
Status: CLOSED DUPLICATE of issue 101690
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO310m11
Hardware: PC Windows XP
: P2 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-07-17 21:50 UTC by victorlim
Modified: 2009-08-05 21:04 UTC (History)
3 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description victorlim 2009-07-17 21:50:27 UTC
I have three col. of data
1   5   a
2   4   6 (function: =A2 + B2)
3   3   6 (function: =A3 + B3)
4   2   6 (function: =A4 + B4)
5   1   6 (function: =A5 + B5)

Data sort with col. B, ascending order. I get the following

5   1   6 (function: =A5 + B5)
4   2   6 (function: =A2 + B2)
3   3   6 (function: =A3 + B3)
2   4   6 (function: =A4 + B4)
1   5   a

The formula =A5 + B5 was not sorted correctly; should be the following:
5   1   6 (function: =A1 + B1)
4   2   6 (function: =A2 + B2)
3   3   6 (function: =A3 + B3)
2   4   6 (function: =A4 + B4)
1   5   a

This function works fine in 2.x; only happen to 3.x
Comment 1 kpalagin 2009-07-19 09:07:56 UTC
Might be dup http://www.openoffice.org/issues/show_bug.cgi?id=101690.
Comment 2 Rainer Bielefeld 2009-07-19 10:05:21 UTC
I checked with "Ooo 3.1.0 WIN XP multilingual version German UI activated 
[OOO310m11 (Build 9399)]" and can confirm the reported effect. That's dangerous!

I checked with "Ooo Dev 3.2.0 multilingual version German UI WIN XP: [DEV300m52
(Build 9411)]" and saw the bug fixed.

Yes, I also believe that this is a DUP of Issue 101690

@victorlim:
Thank you for your attention!


*** This issue has been marked as a duplicate of 101690 ***
Comment 3 Mechtilde 2009-08-05 21:04:53 UTC
duplicate -> closed