Re:Men born between 1893 and 1897 reminded to register for t...
by michaelt on Friday July 11, 2014 @11:40AM
(#8020706)
I just started LibreOffice Calc (the version distributed with the latest version of Ubuntu), chose a cell and entered "1-December-2014"
The program tidied it to 01/12/14 (I'm in the UK, presumably the field order is locale-dependent) then exported a CSV with the default settings. Voilia, I have a file with the date expressed as 01/12/14
My guess is this process only gets run once a year, so it's not been a high priority for automation, and someone's spreadsheet program is configured to work out two-digit years automatically.
The program tidied it to 01/12/14 (I'm in the UK, presumably the field order is locale-dependent) then exported a CSV with the default settings. Voilia, I have a file with the date expressed as 01/12/14
My guess is this process only gets run once a year, so it's not been a high priority for automation, and someone's spreadsheet program is configured to work out two-digit years automatically.