Issue 103615

Summary:	Data sort function with formula for 3.x
Product:	Calc	Reporter:	victorlim <victorswlim>
Component:	code	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P2	CC:	issues, kpalagin, rainerbielefeld_ooo_qa
Version:	OOO310m11	Keywords:	oooqa
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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