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:
This tiny text editor for tabular data can do more for you than any
View this message in context:
Sent from the Users mailing list archive at Nabble.com.
For unsubscribe instructions e-mail to: email@example.com
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
- Re: [libreoffice-users] Re: Date will not format or sort when imported into calc (ods) (continued)
Impressum (Legal Info)
: 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