<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 - Calc: Macro - sorting is working just for first 3 criteria"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=135242">135242</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Calc: Macro - sorting is working just for first 3 criteria
          </td>
        </tr>

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

        <tr>
          <th>Version</th>
          <td>6.4.5.2 release
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>All
          </td>
        </tr>

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

        <tr>
          <th>Severity</th>
          <td>normal
          </td>
        </tr>

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

        <tr>
          <th>Component</th>
          <td>Writer
          </td>
        </tr>

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

        <tr>
          <th>Reporter</th>
          <td>buzea.bogdan@libreoffice.org
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
The exemple file attached contains a macro that is executed when we press
Ctrl+S (when we save the document).

When executed what should happend:
Sort by column 16               ASCENDING
Than by column 17               DESCENDING
Than by column 23               DESCENDING
Than by column 20               ASCENDING
Than by column 21               ASCENDING

What is happend:
Sort by column 16               ASCENDING
Than by column 17               DESCENDING
Than by column 23               DESCENDING

Last 2 options are ignored.


See the video, it's much easier to understand the bug.

Steps to Reproduce:
The exemple file attached contains a macro that is executed when we press
Ctrl+S (when we save the document).

When executed what should happend:
Sort by column 16               ASCENDING
Than by column 17               DESCENDING
Than by column 23               DESCENDING
Than by column 20               ASCENDING
Than by column 21               ASCENDING

What is happend:
Sort by column 16               ASCENDING
Than by column 17               DESCENDING
Than by column 23               DESCENDING

Last 2 options are ignored.

Actual Results:
The last 2 sorting criteria are ignored.

Expected Results:
The last 2 sorting criteria are executed.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 6.4.5.2
Build ID: a726b36747cf2001e06b58ad5db1aa3a9a1872d6
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: ro-RO (ro_RO.UTF-8); UI-Language: en-US
Calc: threaded</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>