https://bugs.documentfoundation.org/show_bug.cgi?id=170355
--- Comment #3 from [email protected] <[email protected]> --- Thanks for the reply, Regina. Firstly, I had tried the format first, add data later, I but that wasn't the problem My system locale settings weren't set (my TZ is Asia/GMT+7, but everything else is Australian) on Ubuntu, setting locale to LANG=en_AU.UTF-8 with update-locale and rebooting gave me: box:~$ locale LANG=en_AU.UTF-8 LANGUAGE= LC_CTYPE="en_AU.UTF-8" LC_NUMERIC="en_AU.UTF-8" LC_TIME="en_AU.UTF-8" LC_COLLATE="en_AU.UTF-8" LC_MONETARY="en_AU.UTF-8" LC_MESSAGES="en_AU.UTF-8" LC_PAPER="en_AU.UTF-8" LC_NAME="en_AU.UTF-8" LC_ADDRESS="en_AU.UTF-8" LC_TELEPHONE="en_AU.UTF-8" LC_MEASUREMENT="en_AU.UTF-8" LC_IDENTIFICATION="en_AU.UTF-8" LC_ALL= This worked when I logged back in, created a document, formatted the col as date first as you said, and added some AU dates, and the autofilled.. The only thing was that I had to set the cell format to a custom DD/MM/YYYY format, otherwise, in spite of entering DD/MM/YYYY data, it defaulted to DD/MM/YY.. But after finding/remembering how to set a custom date format, it worked For YYYY/MM/DD, I had to also add a custom YYYY/MM/DD format for that to work (there was a YYY-MMM-DD there already, but I wanted / separator)... This worked, and also stopped the runaway day part going past the month boundary, being now treated as a date I also added "D/M/Y;Y/M/D" to the date acceptance default which only included "M/D/Y;M/D" (these perhaps should be included by default seeing users from all over the world use he software?) through Tools->Options->Languages and locales->General->Date acceptance patterns.. Also added Formats->Locale setting in the same place to "Default English (Australian)".. I'm not sure this was strictly necessary, but I assume it would have made things confusing, but would have been good to test both. But for sompleteness that looks tidier I guess So setting the system locale properly worked, and I in an Asian TZ with AU locale defaults working basically perfectly now.. but there were several other steps in the program to make it complete But both date formats work with the above steps now thanks. Hope this helps someone else at some point -- You are receiving this mail because: You are the assignee for the bug.
