To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103615 Issue #|103615 Summary|Data sort function with formula for 3.x Component|Spreadsheet Version|OOO310m11 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|code Assigned to|spreadsheet Reported by|victorlim
------- Additional comments from [email protected] Fri Jul 17 20:50:27 +0000 2009 ------- I have three col. of data 1 5 a 2 4 6 (function: =A2 + B2) 3 3 6 (function: =A3 + B3) 4 2 6 (function: =A4 + B4) 5 1 6 (function: =A5 + B5) Data sort with col. B, ascending order. I get the following 5 1 6 (function: =A5 + B5) 4 2 6 (function: =A2 + B2) 3 3 6 (function: =A3 + B3) 2 4 6 (function: =A4 + B4) 1 5 a The formula =A5 + B5 was not sorted correctly; should be the following: 5 1 6 (function: =A1 + B1) 4 2 6 (function: =A2 + B2) 3 3 6 (function: =A3 + B3) 2 4 6 (function: =A4 + B4) 1 5 a This function works fine in 2.x; only happen to 3.x --------------------------------------------------------------------- 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]
