[Libreoffice-bugs] [Bug 143165] [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05

[bugzilla-daemon at bugs.documentfoundation.org]

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

Ming Hua <ming.v.hua at qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ming.v.hua at qq.com
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #6 from Ming Hua <ming.v.hua at qq.com> ---
Reproduced with 7.0.6 and simplified Chinese (zh-CN) locale:
Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 2; OS: Windows 10.0 Build 19041; UI render: default; VCL: win
Locale: zh-CN (zh_CN); UI: en-US
Calc: threaded
...with both the attached sample ODS file and a fresh new spreadsheet.

I agree with Mike's diagnosis in comment #5, that this is not AutoCorrection,
but instead Calc converting inputted strings as dates according to
locale-specific settings.  However I also consider such conversion defective,
as the patterns for converting to dates in zh-CN locale is (Tools > Options >
Language Settings > Languages > Formats > Date acceptance patterns):
"Y/M/D;M-D;M/D;M／D;Y.M.D;Y／M／D;Y年M月D日;M月D日"
and it doesn't make sense that "5-D" would be treated as matching this pattern,
using the literal "D" in the input to match the "D" format code (and converting
it to the current month July anyway).

-- 
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/20210702/80fbf97a/attachment.htm>