Issue 88056 - making a left-to-right sort on the test file ended in lot's of #REF error
Summary: making a left-to-right sort on the test file ended in lot's of #REF error
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: 4.1.0
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-04-08 15:09 UTC by onicap
Modified: 2017-05-20 10:34 UTC (History)
3 users (show)

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

Attachments
test file (34.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-04-08 15:12 UTC, onicap 		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 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.