<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 - date format: month and day automatically reversed"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=131967">131967</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>date format: month and day automatically reversed
          </td>
        </tr>

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

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

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

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

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

        <tr>
          <th>Severity</th>
          <td>minor
          </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>dolphis1@hotmail.fr
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
-systeme in french
libre office.
I set the date format in:
MM / JJ / AAAA
expected result:
date display in the format:
MM / JJ / AAAA
result obtained in display:
JJ / MM / AAAA
even setting the cell language for format to us.
(troubleshooting) solution:
replaces the letters in French formatting with the letters in English
formatting.
by entering:
MM / DD / YYYY
so as not to have the French format inversion of the dates.

Steps to Reproduce:
1.I set the date format in:
MM / JJ / AAAA (french)
2.
3.

Actual Results:
date display in the format:
JJ / MM / AAAA (french)

Expected Results:
date display in the format:
MM / JJ / AAAA (french)


Reproducible: Always


User Profile Reset: No



Additional Info:
(troubleshooting) solution:
replaces the letters in French formatting with the letters in English
formatting.
by entering:
MM / DD / YYYY
so as not to have the French format inversion of the dates.</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>