Bug 116391 - Sort ignores capitals
Summary: Sort ignores capitals
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
6.0.2.1 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-14 00:00 UTC by Simon Dedman
Modified: 2018-03-14 09:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Simon Dedman 2018-03-14 00:00:27 UTC 
Description:
Sorting alphabetically ignores capitals which is problematic if trying to remove duplicates.

Steps to Reproduce:
1. In cells A1:A4 enter: The; the; The; the
2. Data > Sort > Column A > Ascending or Descending, doesn't matter.

Actual Results:  
Nothing happens

Expected Results:
List is sorted by first letter then second (etc) then case status of first letter then second (etc). Probably with capital first.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 6.0.2.1
Build ID: 1:6.0.2~rc1-0ubuntu0.17.10.1~lo1
CPU threads: 16; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: en-GB (en_US.UTF-8); Calc: CL


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0
Comment 1 m_a_riosv 2018-03-14 09:08:56 UTC 
There is Menu/Data/Sort - [Options] - Case sensitive, to do it how you want.