[Libreoffice-bugs] [Bug 143165] [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05
https://bugs.documentfoundation.org/show_bug.cgi?id=143165 Eike Rathke changed: What|Removed |Added Status|NEW |ASSIGNED OS|Windows (All) |All Assignee|libreoffice-b...@lists.free |er...@redhat.com |desktop.org | Hardware|x86-64 (AMD64) |All -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143165] [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05
https://bugs.documentfoundation.org/show_bug.cgi?id=143165 --- Comment #8 from zzz --- Thanks guys for clues. I found there is indeed "M-D" and "D/M" in the preset date acceptance patterns, as you can see in my uploaded screenshot LibreCalc_Options_Language.png. I will make it clear that, for Japanese locale too, treating the literals "-d","-D","/d","D" as part of a date is unnecessary and unwanted. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143165] [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05
https://bugs.documentfoundation.org/show_bug.cgi?id=143165 --- Comment #7 from Ming Hua --- FWIW, when switched to en-US locale, and the date acceptance pattern is just "M/D/Y;M/D", input "5-D" doesn't trigger this bug anymore, but "5/D" still does. Similarly, input "5/D/Y" is also converted, to "7/5/21", which means "July 5th, 2021". Input "5/7/Y" is properly converted to "5/7/21", which means "May 7th, 2021". Input "M/5" or "M/5/Y" is not converted. Something is definitely wrong here. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143165] [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05
https://bugs.documentfoundation.org/show_bug.cgi?id=143165 Ming Hua changed: What|Removed |Added CC||ming.v@qq.com Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #6 from Ming Hua --- 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143165] [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05
https://bugs.documentfoundation.org/show_bug.cgi?id=143165 Mike Kaganski changed: What|Removed |Added CC||er...@redhat.com --- Comment #5 from Mike Kaganski --- I am reasonably sure this is not a bug, and 5-d likely is a valid date pattern in your locale, which means that for any cell formatted as number, the text is automatically recognized and converted to the date value. If this is the case, you should not play with autocorrect options (because what you see is *not* autocorrection, but recognition of numeric data), and instead simply pre-format your cells where you put textual data as Text (Format Cells->Numbers; select Text category). This makes sure that the data you enter is not attempted to be converted to numbers. There's some chance that I'm wrong, and 5-d is *not* a valid date pattern for your locale; maybe Eike can clarify? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143165] [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05
https://bugs.documentfoundation.org/show_bug.cgi?id=143165 --- Comment #4 from zzz --- Created attachment 173321 --> https://bugs.documentfoundation.org/attachment.cgi?id=173321=edit LibreCale_AutoCorrect_Localized.png (my option settings) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143165] [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05
https://bugs.documentfoundation.org/show_bug.cgi?id=143165 --- Comment #3 from zzz --- Created attachment 173320 --> https://bugs.documentfoundation.org/attachment.cgi?id=173320=edit LibreCale_AutoCorrect_Options.png (my option settings) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143165] [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05
https://bugs.documentfoundation.org/show_bug.cgi?id=143165 --- Comment #2 from zzz --- Created attachment 173319 --> https://bugs.documentfoundation.org/attachment.cgi?id=173319=edit LibreCalc_Options_Language.png (my option settings) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143165] [EDITING] When I type "5-d" into cell, it is autoconverted into date 2021/07/05
https://bugs.documentfoundation.org/show_bug.cgi?id=143165 --- Comment #1 from zzz --- Created attachment 173318 --> https://bugs.documentfoundation.org/attachment.cgi?id=173318=edit 5-D_bug_snap1.png (screenshot of 5-D_bug.ods) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs