To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101653
------- Additional comments from p...@openoffice.org Tue May 12 08:51:42 +0000 2009 ------- Me too, did work since OOo 1.x till OOo3.0.1, broken in OOo3.1. Steps to reproduce it on attached file: - move cursor somewhere into the names of tracks (column B, first sheet TRACKS), for example at last line with "Yas Marina" which is unsorted. - Alt+D, S (Data / Sort) * calc will auto select relevant data range (ok) and ask for sort criteria (ok) - 1) choose sort by Column B (alphabetical sort by track names) * the "Yas Marina" will be moved to correct place at line 174, but accompanied lap length is wrong, it is calculated by formula "=VLOOKUP(B177;ALLtracks.$C$3:$G$300;5;0)" which should be "=VLOOKUP(B174;ALLtracks.$C$3:$G$300;5;0)". Basically all formulas accompanied with moved names are moved into new sort order, but they are not updated to reflect new line numbers. With correct behaviour they should either not move at all and just recalculation of them is needed, or if their target cell (name) moves, it should be updated inside formula too. - 2) choose sort by Column C (by lap length) * The final order of track names and data in columns D..I are correct, but formulas in column B are again broken and giving wrong results, not reflecting movement of the name cell. Attached file was created in OOo1.x, never edited in anything else then OOo, only converted to ODS with OOo2.x, the function always did work as expected till OOo3.1 hitting me hard, for me this is critical regression. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org