If you would read the initial posts of the topics you are replying to ...
What I've been doing is loading the .csv file into a text editor,
change those fields and then reload into calc. This is terribly
However, in the .csv file they send, the dollar transactions are all
given as text entries with ($xxx.xx) for negative entries and $xxx.xx
for positive entries.
which is perfectly well handled by Calc's csv importer. 90% of all text
import trouble can be answered with:
1. Choose the right locale which is English(USA) in this particular case
because of the $ currency, the point decimals and propably there are
also M/D/Y dates in the file.
2. Always check "interprete special numbers". A special number is
anything beyond digits with decimal separator. This option is obsolete
since it should be always on. You can mark individual columns as text
when you do not want them to be interpreted as special numbers. But once
the option has been checked it remains checked for subsequent csv imports.
To unsubscribe e-mail to: firstname.lastname@example.org
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
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