<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 - FORMATTING: Selecting a theme in Calc changes the language of number fields to US-English"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138045">138045</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FORMATTING: Selecting a theme in Calc changes the language of number fields to US-English
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.6.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>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>wehofskym@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
If you select a Theme in Calc with Format|Spreadsheet Theme the default
language settings and thus the formatting of numbers is always set to English
(USA).
If the default language is different this can change the display of numbers in
an unexpected way (e.g. if the language is set to German (Germany)).
This occurs also if the default settings are English (GB).
The language is not changed by selecting a template, when the language format
of the number was changed previously.
I can remember that this error occurred in an older version.
Steps to Reproduce:
1.Switch LibreOffice Language settings to "Deutsch (Deutschland)" (or any other
except "English (US)"): Language of User Interface and Locale Settings.
2. Restart LibreOffice
3. Create a Calc-Dokument (Tabellendokument)
4. Enter a valid number in any cell. For German use e.g. 2,34
5. The number is correctly displayed with comma.
6. Check the Format of the cell with the context menu "Zellen formatieren" on
the tab "Zahlen". The Format is the default language ("Deutsch (Deutschland)").
7. Change the theme by opening Format | Themen-Auswahl
8. The displayed number changed from 2,34 to 2.34.
9. If you check the Format of the cell it is changed to "English (US)". The
format is also changed for any empty cell.
10. Change the format of the cell back to "Deutsch (Deutschland)". The number
is now displayed as 2,34
11. Change the theme again. The displayed number with the modified format is
not changed.
Actual Results:
The language of the cell format is set to "English (US)" if the language was
not explicitly changed before.
Expected Results:
Themes should not be bound to a certain language.
If a cell is formatted with the default format this should be retained by
selecting a theme.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.4.6.2
Build-ID: 1:6.4.6-0ubuntu0.20.04.1
CPU-Threads: 4; BS: Linux 5.4; UI-Render: Standard; VCL: gtk3;
Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE
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>