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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Jul 2 19:34:15 UTC 2021


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

            Bug ID: 143165
           Summary: [EDITING] When I type "5-d" into cell, it is
                    autoconverted into date 2021/07/05
           Product: LibreOffice
           Version: 7.1.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: pox_ox2 at yahoo.com

Created attachment 173317
  --> https://bugs.documentfoundation.org/attachment.cgi?id=173317&action=edit
5-D_bug.ods (example data. filesize 13kB)

Reproduction procedure:
  In any unformatted (General) empty cell, type "5-d" directly without the
doublequotes.
  (five hyphen dee)

Expected result:
  Cell value will become implicit text type '5-d, displayed as 5-d

Actual result:
  Cell value becomes date type 2021/07/05 (5th of July, 2021),
  displayed "7月5日" on my instance.

My environment:
  The date of experiment: 2nd of July, 2021
  Windows 10 64bit in Japanese mode
  Libre Calc: UI:English(USA), locale:Japanese
  I Think I have turned off all the autochange switches, as much as possible.
  (If there already is a user switch to turn this feature off, it is too
difficult to find.)

Reproducibility:
  100% (tested over 30 times)

Notes:
  * The range of numbers where this happens is only 1 to 12. "13-d" gives
"13-d".
    1-d gives 2021/07/01 and so on.
  * The "d" part can be either small "d" or capital "D".
  * "/" (slash) in the place of "-" (hyphen) gives the same date.
  * Among the several other alphabets I tried, none behaved similarly.
  * Can be either direct typed into the cell, or typed into the edit box.
  * Can be either typed in by keyboard or pasted from clipboard.
  * Actually, the cell doesn't have to be empty. Just type in.
  * Behavior differs by cell format:
      Date mode: Same date
      E+, Currency mode: Some number (probably date code)
      % mode: "5-d%"
  * Microsoft Excel 2000 and 365 doesn't show this behaviour. "5-d" is just
"5-d".

Very strange.

-- 
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/6cda02d1/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list