To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=93886
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Resolution| |DUPLICATE
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sun Sep 14 17:03:50 +0000
2008 -------
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 ***
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
