To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=44805
User haxwell changed the following:
What |Old value |New value
================================================================================
CC|'' |'haxwell'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Mar 16 12:50:19 -0800
2005 -------
Confirmed using OOo 1.9.84 on Win 2000 SP4.
1. Open the attached file in Calc.
2. Select cell range B43:E61.
3. Click on Data \ Sort. Under Sort By, choose Avg Points. Ascending should be
selected.
4. Hit OK.
Something erroneous happens with the formula in the Avg Points column. Before
the sort a formula similar to (=IF(ISERROR(C56/D56/$C$41);0;C56/D56/$C$41)) is
in fields E56, E58 and E60. (=IF(ISERROR(C59/D59/$C$41);"---";C59/D59/$C$41)) is
in E57, E59, and E61. After the sort, all the selected E fields contain the
second formula.
Also, with an Ascending sort, the values in the Team column are changed, even
though they are not part of the sort.
---------------------------------------------------------------------
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]
