<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><table border="1" cellspacing="0" cellpadding="8">
        <tr>
          <th>Bug ID</th>
          <td><a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - sorting in calc can't be focused on letters alone"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=134747">134747</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>sorting in calc can't be focused on letters alone
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>6.0 all versions
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>x86-64 (AMD64)
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>Linux (All)
          </td>
        </tr>

        <tr>
          <th>Status</th>
          <td>UNCONFIRMED
          </td>
        </tr>

        <tr>
          <th>Severity</th>
          <td>enhancement
          </td>
        </tr>

        <tr>
          <th>Priority</th>
          <td>medium
          </td>
        </tr>

        <tr>
          <th>Component</th>
          <td>Calc
          </td>
        </tr>

        <tr>
          <th>Assignee</th>
          <td>libreoffice-bugs@lists.freedesktop.org
          </td>
        </tr>

        <tr>
          <th>Reporter</th>
          <td>w.helm@gmx.at
          </td>
        </tr></table>
      <p>
        <div>
        <pre>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</pre>
        </div>
      </p>


      <hr>
      <span>You are receiving this mail because:</span>

      <ul>
          <li>You are the assignee for the bug.</li>
      </ul>
    </body>
</html>