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

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.