[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

Am 10.09.2012 01:49, JAMES MAJESKI wrote:
> You are correct in that 12/31/12 is not ambiguous, but that is a special
> case. When each element is unique and without knowing the source preference,
> there are six different dates that may be generated from "10/11/12":
> 2010-11-12
> 2010-12-11
> 2011-10-12
> 2011-12-10
> 2012-10-11
> 2012-11-10

Your input data have 4 digit years. Before exporting csv from a 
spreadsheet you have to take care of unambiguous number formatting.
Again, there are much better applications to load, edit and save csv.
The Base component can be used as import configurator for pre-formatted 
spreadsheet templates, some spreadsheet geeks prefer macro programming.



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted