To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=60137 Issue #:|60137 Summary:|Case sensitive sort produces reversed output Component:|Spreadsheet Version:|OOo 2.0.1 Platform:|PC URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|pescetti
------- Additional comments from [EMAIL PROTECTED] Fri Jan 6 07:52:35 -0800 2006 ------- The Documentation for Data -> Sort -> Options in Calc describes "Case sensitive" as "Sorts first by uppercase letters and then by lowercase letters". 1. Write (or get through copy/paste) "Word", "Bb", "BB", "aa", "Aa", "AA", "bb" in column A, cells A1:A7 2. Copy the cells to B1:B7. 3. Select A1:A7. 4. Data -> Sort -> By "Word", ascending; in Options leave "Case sensitive" unchecked. 5. You get: "Aa", "aa", "AA", "bb", "BB", "Bb", which is OK. 6. Repeat for B1:B7 but check "Case sensitive". 5. You get: "aa", "Aa", "AA", "bb", "Bb", "BB". Expected: "AA", "Aa", "aa", "BB", "Bb", "bb". So "AA", "Aa", "aa" (and, similarly, "BB", "Bb", "bb") are reversed in the actual output. The documentation is far too terse to be clear (see issue 55873 for a wrong, but consistent, interpretation of it) but this really seems not to work as documented. [Reported by Pierluigi and Dario Burattini during Italian QA tests] --------------------------------------------------------------------- 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]
