Issue 88056

Summary:

making a left-to-right sort on the test file ended in lot's of #REF error

Product:

Calc

Reporter:

onicap <omar>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

CLOSED FIXED

QA Contact:

Severity:

Trivial

Priority:

CC:

amy2008, issues, rainerbielefeld_ooo_qa

Version:

OOo 2.4.0

Target Milestone:

4.1.0

Hardware:

All

OS:

All

See Also:

https://issues.apache.org/ooo/show_bug.cgi?id=123063

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
test file	none

Description onicap 2008-04-08 15:09:32 UTC

On the attached file we make a Data->Sort->left-to-right on Row no 3. We can see
that in random cells the otherwise correct (until the sorting) references are
transformed in #REF errors.

Comment 1 onicap 2008-04-08 15:12:03 UTC

Created attachment 52657 [details]
test file

Comment 2 onicap 2008-04-08 15:13:04 UTC

Before the sorting we make an Select all (Ctrl+a).

Comment 3 amy2008 2008-08-27 03:44:51 UTC

onicap, 
I can't reproduce it in OOo300_m3_EN on WinXP and Linux.
Please check it again in the latest build, ^_^

Li Meiying

Comment 4 Rainer Bielefeld 2013-11-05 18:40:04 UTC

NOT reproducible with "AOO 4.0.1   – German UI / German locale  [Rev. 1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)", “historic”  4.0  User Profile used for all  predecessor versions

Also NOT reproducible with 3.4.0

But was Reproducible with "Ooo 2.0.3 [680m5 (Build 9011)]" German WIN7  Home Premium  (64bit) for an ascending row3 sort as per reporter's instruction, here I see "#Ref" in cells D5, G5 J5 and many others 

So FIXED for now.

Has been fixed for AOO 3.4.0, but because of crippled Target Milestone selector contents  (Bug 123063) I only can select TM = 4.1.0, no useful information can be left.