[libreoffice-users] Re: Calc method to change whole column cell content

If you would read the initial posts of the topics you are replying to ...

MRZenwiz:
> 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
> cumbersome.

> 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: users+unsubscribe@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