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
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:
Depends on:
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: ---

test file (34.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-04-08 15:12 UTC, onicap
no flags Details

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
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.