You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/12/02 06:41:42 UTC

[Bug 121428] New: Incorrect Ascending Sort Using Basic

https://issues.apache.org/ooo/show_bug.cgi?id=121428

            Bug ID: 121428
        Issue Type: DEFECT
           Summary: Incorrect Ascending Sort Using Basic
    Classification: Application
           Product: spreadsheet
           Version: AOO 3.4.1
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: programming
          Assignee: issues@openoffice.apache.org
          Reporter: alan.schnell@hawaiiantel.net
                CC: issues@openoffice.apache.org

I am writing a Basic macro and encountered an issue with the sort function
while using the call oCells.Sort(sortProperties()). My locale is English, USA.
For the sorts something pecular happens! The upper and lower case letters are
incorrectly sorted but with a twist. The letters are in the correct order but
upper and lower case order is REVERSED.

Example:
  Using the following names:
    Pring, Wes
    whitmer, Tony
    Whitmer, Tony
    rosario, Kerry
    Rosario, Kerry
    Stewart John

  A case sensitive ascending sort results in:
    Pring, Wes
    rosario, Kerry
    Rosario, Kerry
    Stewart John
    whitmer, Tony
    Whitmer, Tony

  A case sensitive descending sort results in:
    Whitmer, Tony
    whitmer, Tony
    Stewart John
    Rosario, Kerry
    rosario, Kerry
    Pring, Wes

These results are clearly wrong.

I have tried the above data using the menu sort and I get the same result! I
copied the data from one spreadsheet to another new, empty spreadsheet (copying
only text, no formats) and got the same result both from my Basic program sort
and from the menu sort.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121428] Incorrect Ascending Sort Using Basic

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121428

binguo <bi...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |binbjguo@gmail.com
     Ever confirmed|0                           |1

--- Comment #1 from binguo <bi...@gmail.com> ---
Verified on Aoo_Trunk_20121214.1915 Rev.1413470, it occurs, confirm it.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121428] Incorrect Ascending Sort Using Basic

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121428

Yan Ji <ya...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |121500

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.