Getting really sick of wasting my time -- having to change to a date format (in Calc) that works -- FOR ME. Very frustrating! Calc seems to default to YYYY-MM-DD. Why can't users choose a default date format? I need MM-DD-YY as default! I don't want to go back to Microsoft, but I WILL ditch LO Calc for (dread the thought) MS Excel -- if I must.
This is what you can do: https://ask.libreoffice.org/en/question/24722/how-to-change-the-default-date-format-in-calc-to-show-4-digit-years/
*** This bug has been marked as a duplicate of bug 46448 ***