To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101248 Issue #|101248 Summary|Sorting information with other information in the same | row Component|Spreadsheet Version|OOO310m9 Platform|HP URL|http://dripinvesting.org/tools/tools.asp OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P5 Subcomponent|formatting Assigned to|spreadsheet Reported by|chadmatthews
------- Additional comments from [email protected] Tue Apr 21 15:21:28 +0000 2009 ------- In spreadsheet listed in URL, "U.S.DividendChampions.xls" Click and hold cell "H7" and drag to cell "H121" for example, in order to sort "Yield" column by ascending or descending order. When "ascending order" button is clicked, nothing happens, or one random number will be misplaced. Very odd issue. In MSExcel, after performing the same steps and clicking "ascending order" a dialogue box comes up and asks "Would you like to expand current selection?", This option enables all of the information in the respective rows to be sorted along with the information that originally needed sorted. After trying to perform the same action in different columns, I noticed that information in cells that have a formula (*e.g. =((J12/I12)-1)*100) can not be sorted. Another example, Cat 3 Dog 1 Fish 2 If this information was setup in a spreadsheet, and I wanted to sort ascending, I should be able to highlight the column with the numbers, click a sort ascending button, then have the option to have the other information be sorted with it. Instead of just having the numbers column sorted. So the information would sort with it like this: Dog 1 Fish 2 Cat 3 --------------------------------------------------------------------- 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]
