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: [email protected]
Reporter: [email protected]
CC: [email protected]
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.
