To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92604
User wilberw changed the following:
What |Old value |New value
================================================================================
Priority|P3 |P2
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sat Aug 9 02:13:13 +0000
2008 -------
This issue is similar but different to issue 61936. The sort function is buggy
and I have created another spreadsheet called "sortingwithformulasV2.ods" to
demonstrate this. Open up sortingwithformulasV2.ods and select area A2:C4 and
click on "Data | Sort | OK". It appears the sort function is modifying the
relative references based on how far up or down a row moves during the sort.
Before the sort this row:
08/08/2008 =F71/4 Rent
was on row 2. After the sort it had moved down one row and so it then modified
the relative reference down by one:
08/08/2008 =F72/4 Rent
Now have a look at these rows:
11/08/2008 =F72 Food
18/08/2008 =F72 Food
25/08/2008 =F72 Food
01/09/2008 =F72 Food
08/09/2008 =F72 Food
which before the sort where on rows 15-19. After the sort these rows now occupy
4-8 and have a look how the data has been modified:
11/08/2008 =F61 Food
18/08/2008 =F61 Food
25/08/2008 =F61 Food
01/09/2008 =F61 Food
08/09/2008 =F61 Food
and also have a look at row 10:
15/09/2008 =F62 Food
^^ It can clearly be seen that the sort function is modifying relative
references inconsistently changing behaviour radically especially if you use a
function.
This should remain as a P2 priority because "User data is corrupted in an
easy-to-encounter way".
The "Data | Sort" function should include a new option in its "Options" page of
"Preserve relative references" which by default should be ticked as this would
be the behaviour the majority of users would expect when performing a 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]
