Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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: 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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.