Issue 81349

Summary: sorting of rows goes wrong when references are present
Product: Calc Reporter: dick_kaas <dick>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kami911
Version: OOo 2.2.1   
Target Milestone: ---   
Hardware: All   
OS: Windows Server 2003   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
test file wich demonstrates the error. just sort on sort_val none

Description dick_kaas 2007-09-07 10:04:54 UTC 
I have a spreadsheet where cells are refering to a cell in another row.
When I do a sort on one or more columns in my spreadsheet I found  that the
reference is no longer assigned to the original cell.
I think this link should be maintained.

By the way the same problem occurs in MS-EXCEL but I think the open source
community should do better

When needed I can send you an example

Dick
Comment 1 frank 2007-09-07 10:20:29 UTC 
Hi,

if the sorted range does not contain the linked (to) cells, just use absolute
addressing. If the sorted range contain the linked (to) cells, how should this
work ?

Please attach a document showing your problem.

Frank
Comment 2 dick_kaas 2007-09-07 16:51:39 UTC 
Created attachment 48057 [details]
test file wich demonstrates the error. just sort on sort_val
Comment 3 frank 2007-10-25 15:02:24 UTC 
Hi,

as I've said before, how should this work ?

It's not just a few rows/columns to sort but could the thousands of cells in
case you have to sort a whole sheet it goes into 16 Million cells. So the amount
of memory would be huge if this is at all possible.

But let's requirements decide.

Frank
Comment 4 dick_kaas 2007-10-25 16:41:27 UTC 
May I suggest the following. I agree that the solution is not simple but first
things an open source party should do is
- admit that there is an error and 
- signal the user that something can go wrong

second working on the solution. Well I like the get to the result answer. First 
- keep track of all the changes in rows/columns and do the sorting (looks like
current method) [at least if you signal that there is a problem] This can be
hardly a memory problem.
- second check all the cells and make (on a base of changes) correct references.
Talking about millions of transactions is a theoretical possibility and I donot
think that that will occur in practice

Think of what you can do better than Microsoft!!

Dick
Comment 5 frank 2007-11-22 13:39:12 UTC 
*** Issue 82015 has been marked as a duplicate of this issue. ***
Comment 6 Regina Henschel 2008-09-14 18:03:49 UTC 
*** Issue 93886 has been marked as a duplicate of this issue. ***
Comment 7 frank 2008-11-06 15:23:54 UTC 
*** Issue 85147 has been marked as a duplicate of this issue. ***