To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=85147
User mike_hall changed the following:
What |Old value |New value
================================================================================
CC|'amy2008' |'amy2008,mike_hall'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Priority|P2 |P3
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Thu Oct 23 22:19:48 +0000
2008 -------
For the following four cells:
A2: 2 B2: a
A3: 1 B3: =B2
Sort these four cells on column A, and the formula in B3, now in B2, no longer
points to the 'a' character, now in B3, instead it points to B1. Behaviour is
the same in Calc and in Excel.
In this case perhaps it's 'obvious' what you want, but maybe you can think of
other scenarios where something different may be 'obvious'. For this situation,
the 'solution' is to select and copy the cells in column C (for the first
attachment spreadsheet), Click Paste Special, clear Paste all and Formulas and
check Numbers and click OK. (This does the same as Paste Special > Values in
Excel, though it's not as intuitive.) You can then sort correctly. I realise
that's not what you wanted to do, but AFAIK there isn't a way to do that.
This is not a bug. Sort simply doesn't support what you want to do. If you wish
to change this issue into a request for an enhancement, that's fine, but it will
almost certainly need a lot of analysis to demonstrate that the change does what
you want and what others might want, unambiguously, intuitively, without
introducing unwanted side effects.
I've set Invalid. Please revert if you don't agree. Also changed P2 to P3.
---------------------------------------------------------------------
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]
