https://bugs.documentfoundation.org/show_bug.cgi?id=150288
Bug ID: 150288
Summary: Aug. 1st becomes Jan. 8th when using DD/MM/YYYY date
format
Product: LibreOffice
Version: 7.2.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: joaol...@gmail.com
Description:
When using DD/MM/YYYY date format, typing 31/8/22 automatically formats to
31/08/2022, but typing 1/8/22 automatically formats to 08/01/2022. Aug. 1st
becomes Jan. 8th.
Steps to Reproduce:
1. On menu: File/New/Spreadsheet
2. Left-click on "A" to select the entire column A.
3. Right-click on "A" to open the pop-up menu, and select "Format Cells".
4. Select Category "Date", Language "Portuguese (Brazil)", and Format
"31/12/1999". Click "Ok". This will apply the DD/MM/YYYY date format.
5. Type 31/8/22 in cell A1. This will automatically format to 31/08/2022.
6. Now type 1/8/22 in cell A2. This will automatically format to 08/01/2022,
instead of 01/08/2022.
Actual Results:
Typing 31/8/22 automatically formats to 31/08/2022, but typing 1/8/22
automatically formats to 08/01/2022. Aug. 1st becomes Jan. 8th.
Expected Results:
Since the date format is set to DD/MM/YYYY, 1/8/2022 means Aug. 1st and should
automatically format to 01/08/2022 (Aug. 1st), not to 08/01/2022 (Jan. 8th).
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 7.2.7.2
Build ID: 20(Build:2)
CPU threads: 8; OS: Linux 5.18; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
OpenGL vendor string: Intel
OpenGL renderer string: Mesa Intel(R) HD Graphics 4000 (IVB GT2)
OpenGL core profile version string: 4.2 (Core Profile) Mesa 21.3.9
OpenGL core profile shading language version string: 4.20
OpenGL core profile context flags: (none)
OpenGL core profile profile mask: core profile
OpenGL core profile extensions:
OpenGL version string: 3.1 Mesa 21.3.9
OpenGL shading language version string: 1.40
OpenGL context flags: (none)
OpenGL extensions:
OpenGL ES profile version string: OpenGL ES 3.0 Mesa 21.3.9
OpenGL ES profile shading language version string: OpenGL ES GLSL ES 3.00
OpenGL ES profile extensions:
--
You are receiving this mail because:
You are the assignee for the bug.
