Problem description: Some, but not all dates do not format correctly. Steps to reproduce: 1. Format cell to date mm/dd/yy 2. Type 2-13-13. Will not format correctly. 3. Type 2/13/13. Will format correctly. 4. Type 4-13-13. Will format correctly. 5. Type 4/13/13. Will format correctly. Current behavior:Displays as 2-13-13 Expected behavior:Should display as 02/13/13 Operating System: Windows 8 Version: 4.0.1.2 release Last worked in: 3.6.5.2 release
Hi scooby, please take a look to this link: http://erack.org/blog/archives/8-LibreOffice-date-acceptance-patterns.html maybe can help.
Reading the blog post that was put in comment 2, this seems like a clear bug. I get no good result with both 1 & 3 (you say 3 works for you, it doesn't for me) I have been able to confirm the issue on: Version 3.6.5.2 Platform: Bodhi Linux 2.2 x64 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + As I've been able to confirm this problem on an earlier release I am changing the version number as version is the earliest version that we can confirm the bug, we use comments to say that the bug exists in newer versions as well. Marking as: New (confirmed) Minor - substantially slows down high quality work High - anyone would expect #-##-## and format set to date, to format correctly. + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material
@Joel: Behavior depends on locale used. If here the given 2-13-13 input should really produce a date in an assumed M/D/Y locale the cell format could be set to M-DD-YY first. @scooby_snacks19: What locale are you working in? The format mm/dd/yy lets me assume en-US, then both (!) inputs 2-13-13 and 4-13-13 do not produce a date but remain as textual cell content. This is not different from 3.6.x I'm closing this as NOTABUG.