I just upgraded to LO 3.6.2
I have a spreadsheet with a date column formatted as DD/MM/YY which up until now,has been working as expected. I noticed afer the upgrade that when I enter the date 5/1/13 it shows up in the column as 04/01/00, and in the formula bar as 1900-01-04 01:50:46. In addition, the same hours/minutes/seconds shows up no matter what the actual time of day is. Under options I have LO set up to recognize dates from 1930 to 2029. As mentioned, this only started after the upgrade.
Is this a known bug or am I missing something? I checked the bug page and I found a very old bug for the YEARFRAC function, but nothing else.
Date formatting changed after upgrade
Re: Date formatting changed after upgrade
This is not a known issue. It has nothing to do with "formatting". It is about wrong values. The 2-year setting nor any other setting has anything to do with it.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice