Bug 154613 - For type "Variable" field, the "General" format label is shown in the "Insert/Edit field dialog" according to document language of the field, while the "Text" format label is shown in the dialog according to UI language
Summary: For type "Variable" field, the "General" format label is shown in the "Insert...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
: 129820 (view as bug list)
Depends on:
Blocks: Fields Fields-Variable
  Show dependency treegraph
Reported: 2023-04-04 23:38 UTC by sdc.blanco
Modified: 2023-04-11 11:42 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description sdc.blanco 2023-04-04 23:38:58 UTC
Ctrl+F2 (or Insert - Field - More Fields - Variables tab)
Select type "Set variable" or type "user field"
Note the format list.
Change the document language and note Format list
Change UI interface language and note format list

Actual:  "Text" Format is shown according to the UI language.
          "General" is shown according to document language.

For the inserted variables, the pattern of what language the format is shown for the inserted variables, when using "Edit field" is variable. Sometimes they seem to keep the language that they were inserted with. Other times, when the UI language changes, then the format language also changes. And sometimes the format changes.  (Try to use one UI language, with a different document language to insert variables with the same name in both "Text" and "General" format, then save file and open with a different language interface)
Comment 1 Eike Rathke 2023-04-05 00:37:18 UTC
The "Text" and "Formula" entries are UI resource strings, the "General" is a locale data dependent number format code keyword you also see in a table's or Calc's number format dialog, hence may change with the document locale.
Won't fix.

The rest may be related to bug 154218, please check with a version that contains its fixes.
Comment 2 sdc.blanco 2023-04-05 01:15:52 UTC Comment hidden (no-value)
Comment 3 sdc.blanco 2023-04-05 12:51:18 UTC
As best I can tell:  Format "Text" is shown according to the UI language (independently of the UI language used to insert the field), while the label for Format "General" (en-US) is shown according to the document "language" of the field (e.g., as demonstrated in bug 129820, it is possible to change the format label for "General" by changing the language of the variable, where the UI language has no influence). This "hypothesis" (together with a recent master build) seems to account for the appearance of the format labels, when changing UI language and document language of the field.  

Comment 1 explains/confirms these observations.  Converting this ticket to "Documentation" -- with the suggestion for the following (approximate) addition in the "Format" section in [1].

  the Format label for General reflects the locale applied to the field, independent of the UI language. 

Tested with:
Version: (X86_64) / LibreOffice Community
Build ID: 1e9f4de320f67d1218c710bcee1969a2324c6888
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: da-DK (da_DK); UI: en-US
Calc: CL threaded

[1] https://help.libreoffice.org/7.6/en-US/text/swriter/01/04090005.html