Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Sorting cells with references results in invalid references | ||
---|---|---|---|
Product: | Calc | Reporter: | tastenton <rolf.lochbuehler> |
Component: | editing | Assignee: | spreadsheet <spreadsheet> |
Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> |
Severity: | Trivial | ||
Priority: | P4 | CC: | issues, rb.henschel |
Version: | OOo 2.4.1 | Keywords: | oooqa |
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows Vista | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
tastenton
2008-09-14 17:12:20 UTC
What do you want, is impossible using relative address references. When the cell content of B3 is the formula "=B2+1", then this mean in fact,"Take the content of the cell, which is one row before me and add 1." When now the content of B3 comes by sorting into the cell B1, it still has the meaning "Take the content of the cell, which is one row before me and add 1." But now in 'one row before me' is nothing. That is the way relative addressing and sorting works actually. Issue 81349 is indeed a feature request to get a new way of sorting. I'll solve this issue as duplicate therefore. To get a proper sorting, you must 1. use absolute address references and 2. output the sorting to a new place or sort a linked copy of the list. In this way the references point to the correct values in the unsorted list. *** This issue has been marked as a duplicate of 81349 *** closing duplicate |