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.
Please what's the language used, if it's not a language using mm/dd/yy, it doesn't accept 05-31-18 as a date, and 06-01-18 is introduced as d06m01y18 06-01-18. Setup for cell number options a language using mm/dd/yy or change it in default spreadsheet style.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20181203
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-20190111