[Libreoffice-bugs] [Bug 134747] New: sorting in calc can't be focused on letters alone

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134747

            Bug ID: 134747
           Summary: sorting in calc can't be focused on letters alone
           Product: LibreOffice
           Version: 6.0 all versions
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: w.helm at gmx.at

Description:
When I have a list of texts, naturally I would sort it like this:
"Ich habe..."
"I'm gonna..."
"In der..."
"I want..."

But Libreoffice considers also whitespace and special characters and sorts it
like this:

"I want..."
"I'm gonna..."
"Ich habe..."
"In der..."

(sorry for the mixed language - shouldn't matter, it's just about characters)


I didn't find an option to change that behaviour and also asked in a forum and
didn't get a different result. 
Could there be an option to choose if only letters matter or all characters?

(actually I don't know since when this happens - maybe it was always like this,
and it's just now bothering me enough to report that)


Steps to Reproduce:
1. make a list like in the description
2. sort it
3. ?

Actual Results:
"wrong" sorting

Expected Results:
"natural" sorting


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.0.7.3
Build-ID: 1:6.0.7-0ubuntu0.18.04.10
CPU-Threads: 4; BS: Linux 4.15; UI-Render: Standard; VCL: gtk3; 
Gebietsschema: de-AT (de_AT.UTF-8); Calc: group

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200712/86bcdc17/attachment.htm>