Bug 164327 - In Japanese locale, when a value is entered, the time format "HH:MM:SS" is canceled and becomes "Standard"
Summary: In Japanese locale, when a value is entered, the time format "HH:MM:SS" is ca...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency tree / graph
 
Reported: 2024-12-15 01:44 UTC by nobu
Modified: 2024-12-16 06:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description nobu 2024-12-15 01:44:49 UTC 
Description:
In Japanese locale, when a value is entered, the time format "HH:MM:SS" is canceled and becomes "Standard".

Steps to Reproduce:
1. Change LibreOffice to the Japanese locale and restart.
2. Open new calc.
3. Insert "0.5" in Cell [A1].
4. Change Numbers Format of Cell [A1] to Time "HH:MM:SS".
5. Cell [A1] should read "12:00:00".
6. Insert "0.5" in Cell [A1] again.

Actual Results:
7. The Numbers Format of the cell is changed to "Standard" and "0.5" is displayed.

Expected Results:
7. The cell format is not changed and "12:00:00" is displayed again.


Reproducible: Always


User Profile Reset: No

Additional Info:

Not Reproduced with
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f27d2d76c4e577c7231ae755548a8fc20711ca48
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win
Locale: en-US (ja_JP); UI: en-US
Calc: CL threaded

Reproducible with
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f27d2d76c4e577c7231ae755548a8fc20711ca48
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: default
Comment 1 nobu 2024-12-15 01:48:59 UTC 
Reproducible with
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f27d2d76c4e577c7231ae755548a8fc20711ca48
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win
Locale: ja-JP (ja_JP); UI: en-US
Calc: CL threaded
Comment 2 m_a_riosv 2024-12-15 23:01:32 UTC 
Reproducible
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f27d2d76c4e577c7231ae755548a8fc20711ca48
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: ja-JP (es_ES); UI: en-US
Calc: CL threaded

happens also with
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f27d2d76c4e577c7231ae755548a8fc20711ca48
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

No dependent on the language.
Inherited from OOo
Comment 3 nobu 2024-12-16 03:28:35 UTC 
The format when entered as a shortcut in each locale is considered to be the target of the problem.
Date [ Ctrl + ; ]
Time [ Ctrl + Shift + ; ]

This is a malfunction for the user, but it may mean something.
One of the developers should be able to justify this specification.