<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 - Wrong values shown in Userfields after changing Locale setting"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=120112">120112</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Wrong values shown in Userfields after changing Locale setting
          </td>
        </tr>

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

        <tr>
          <th>Version</th>
          <td>6.0.6.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>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>florian-adamus@gmx.de
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
In a document with userfields for timestamp and float values changing the
locale setting from German(Germany) to English(USA), restarting Libre Office
and updating the fields by pressing F9 leads to wrong values for all
userfields.

Steps to Reproduce:
1. Set Libre Office locale settings to English(USA)
2. Restart Libre Office
3. Open the attached libre office document
4. Press F9 to update the fields

Actual Results:
The value of the timestamp field is wrong (year -3741) and the values of the
other userfields are multiplied by 1000000.

Expected Results:
The userfields should show the correct values.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
The user fields in the attached document were created after the Open Document
Format for Office Applications (OpenDocument) Version 1.2 by an external tool.

Userfield declaration:
<text:user-field-decl office:value-type="date"
office:date-value="2017-09-14T16:09:46"
text:name="WW.Timestamp.Protocol.Close"/>
<text:user-field-decl text:name="T__9.actual" office:value="27.048431"
office:value-type="float"/>

Userfield usage:
<text:user-field-get text:name="T__9.actual"
style:data-style-name="N107">27.0484</text:user-field-get>

When double clcking one of the user fields the value shown in the property
window is still correct, even after updating.</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>