To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101183 Issue #|101183 Summary|Sort incorrectly modifies case when "Case sensitive" o |ption is active. Component|Spreadsheet Version|OOo 3.0.1 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|marieraysmith
------- Additional comments from [email protected] Sat Apr 18 14:38:37 +0000 2009 ------- The sort option « Case sensitive » (*) does not work correctly: a sort transforms the case of a large number of words (but by no means all) in an apparently arbitrary fashion even when this option is active. Procedure used: - open document (attachment "Test Sort File before sort") - select the complete document by clicking on the topmost left-hand cell - select the "sort" option in "Data" - click on "options" and then select "case sensitive" and "Range contains column labels" - click on "sort criteria" (unfortunately all this is not in the same window) - identify "Sort Key" and then "Wortart", both in ascending order, as sort criteria - click on "OK" to launch sort. The result can be seen in the "Test Sort File after sort by Sort Key" attachment, where the words in case 8 in Column D in lines 43, 61, 66, 69,74, 76 (etc.) have been incorrectly changed to case 10. (*) note - the "Case Sensitive" sort option should be the default option (but unfortunately isn't). It should also be visible in the first panel (ie - without having to click on the "Options" button) to avoid unwanted massive change to type case by users who activate the sort without realizng that their document can be significantly altered if this (weird) option is not properly modified. --------------------------------------------------------------------- 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]
