https://bugs.documentfoundation.org/show_bug.cgi?id=147694
Bug ID: 147694
Summary: In LibreOffice Calc, the date "3/4" is not converted
correctly.
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: pqxjd03...@yahoo.co.jp
Description:
In LibreOffice Calc, when I type "3/4" in a cell, "¾" is displayed even though
the cell's format is set to "Date", and the date is not displayed.
This problem occurs only when I enter "3/4", and it is displayed correctly when
I enter everything from the western calendar, such as "2022/3/4".
Steps to Reproduce:
1.Open LibreOffice Calc and create new spreadsheet.
2.Select one of the cells, right-click, and select "Format Cells..." to open
the formatting window.
3.Go to the "Numbers" tab and set "Category" to "Date". (By the way, this bug
will occur no matter what you set "Format" or "Language" to.)
4.Enter "3/4" in that cell.
Actual Results:
The cell will display "¾".
Expected Results:
The output should be in the correct format, such as "03/04/22" or "3月4日".
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.3.0.3 / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Flatpak
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
