Issue 81349 - sorting of rows goes wrong when references are present
Summary: sorting of rows goes wrong when references are present
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.2.1
Hardware: All Windows Server 2003
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 82015 85147 93886 (view as issue list)
Depends on:
Blocks:
 
Reported: 2007-09-07 10:04 UTC by dick_kaas
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

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

Attachments
test file wich demonstrates the error. just sort on sort_val (9.06 KB, application/vnd.sun.xml.calc)
2007-09-07 16:51 UTC, dick_kaas 		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 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. ***