To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=61936
User er changed the following:
What |Old value |New value
================================================================================
CC|'' |'fst'
--------------------------------------------------------------------------------
Status|NEW |RESOLVED
--------------------------------------------------------------------------------
OS/Version|Windows XP |All
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
Subcomponent|code |editing
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Mar 15 05:11:18 -0800
2006 -------
It's not a bug, it's a feature ;-)
If you want references to point to the same cell after sort you'll have to use
absolute references at least for the row parts that would change according to
the sort changing the position of the formula cell, the same as if copied via
clipboard. In this case it would be =RANK(B$2;Liste), =RANK(B$3;Liste), ...
That adding a sheet reference changes the behavior as if the row reference was
absolute was implemented because Excel does it the same.
@fst: the internal Bugtracker ID for that was 86145.
---------------------------------------------------------------------
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]
