[Libreoffice-bugs] [Bug 138045] New: FORMATTING: Selecting a theme in Calc changes the language of number fields to US-English

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138045

            Bug ID: 138045
           Summary: FORMATTING: Selecting a theme in Calc changes the
                    language of number fields to US-English
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: wehofskym at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201106/c63910ab/attachment.htm>