The data are dumped into a blank new sheet. In a blank new sheet there is only the "General" number format which applies one distinct number format per number format category. You must not try to edit text tables in a spreadsheet and expect numbers to be resaved in the same number format as they have been imported. Spreadsheets are not able to do this. As a matter of fact, spreadsheets are inappropriate to edit and save csv data. Of course you can use imported text data in calculation models, but then the formatting of the input would not be relevant by any means.
CSV is an exchange format for databases in plain text. Each line represents a database record. Each record has the same amount of database fields. Each database field holds one field type (dates below dates, integers below integers, text below text, etc.). There are several ways to deal with csv files using the Base component. Once you have anything in the Base component, you can also link it to preformatted spreadsheets. Then there are programmatic ways to import text into preformatted templates. Both, databases and macro programming, is something for professional users only. For Windows users there is an excellent text editor: http://csved.sjfrancke.nl/ This tiny text editor for tabular data can do more for you than any spreadsheet. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4006294.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] 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
