[Libreoffice-bugs] [Bug 118003] New: Date format autocorrecting only on certain dates

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118003
           Summary: Date format autocorrecting only on certain dates
           Product: LibreOffice
           Version: unspecified
          Hardware: Other
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: davidpierce042 at gmail.com

I noticed something really odd with the auto-correct for dates in LibreOffice
Calc.

When I would input dates in a mm-dd-yy format, sometimes it would auto correct
to mm/dd/yy format in the cell, and a mm/dd/yyyy format in the bar above the
cell.

This would be fine, except that it only does this some of the time. I've done a
little bit of research and I think this behaviour is exclusive to cases where
day is between 1 and 11, and the year is between 1 and 31.

For instance, when I input 06-01-18 , in would be corrected to 06/01/18 while
05-31-18 would remain unchanged. 

I have tried turning off the AutoInput tool with no effect.
When I use the Format As Date tool (ctrl-shift-3) the date is changed from
06/01/18 to what I assume is an arbitrary number signifying the date in the
code. For instance 06/01/18 is reverted to 43252, 06/02/18 reverts to 432523
etc. Using the same tool on 05-31-18 changed nothing.

In the grand scheme of things this is a minor issue, more annoying than
anything else, in testing I found that I can put a [ ' ] character in front of
the date and the format will not change, nor will the character show in the
cell. But I thought I should still let you know.

-- 
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/20180605/51ede98d/attachment.html>