To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102225 Issue #|102225 Summary|Sort not working when the fields contain formula Component|Spreadsheet Version|OOo 3.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|cniehaus
------- Additional comments from cnieh...@openoffice.org Mon May 25 13:58:07 +0000 2009 ------- I have a table in which a number is calculated with a VLOOKUP: =VLOOKUP(O3;Q$7:R$12;2) The result is a number from 1 to 6. When I sort the table using that dataset the sorting is messed up (looks random to me). To reproduce open the attached ODS-file and try to sort column P (also tried with column O, doesn't work either). I also attached a graphic how the result looks like. Tested on ArchLinux and Windows XP. --------------------------------------------------------------------- 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