So a user working with CSV face the dificulty that it seems that AOO by default manage dates with a 2 digit year format. This causes havok on his data. Having a regular field with 2/20/2015 changed to 2/20/15.
The issue is that by default (might be the locale) AOO assigns a 2-digit year format, and not even the tempalte can be change to address that. I think shortcutting information is never a good idea, the opposite wouldnt be a problem and wonder if this can be patched somehow by editing the source defaults for the US locale (and others). To reproduce: 1 . Create a date column with xx/yy/xxxx 2. Save it as CSV 3. Open it in Calc 4. Check 'Detect special numbers' (if you dont do this, the dates are displayed as a string text) 5. See the format of the date change from xx/yy/xxxx to xx/yy/xx -- Alexandro Colorado Apache OpenOffice Contributor 9060 55AB FFD2 2F02 0E1A 3409 599C 14FC 9450 D3CF
