Re: [tdf-discuss] First LibO problem - OOo didn't do this...

Hi Charles,

Charles Marcus wrote (23-11-10 22:36)
> Ok, first real issue I've had with LibO...
>
> I have an old phone system that generates reports in CVS format.
>
> OOo always opened these with the number columns formatted as - numbers.
>
> LibO is formatting *some* of them as text fields, and when I change them
> to numbers with no decimals (to remove the .00 it is adding to them that
> OOo also never did), it adds the stupid ' character to the beginning of
> every cell, thus making it impossible to format these as numbers.
>
> How can I easily remove the ' symbol from the beginning of every field?

I have cam accross the same problem.
In OOo 3.3.0 there are some new settings on the dialogue that imports 
the csv, in the section Other Options.

If you fidlle a bit with those, you will find out how it works. (I can't 
remember what worked for me)

Regards,
Cor

--
 - giving openoffice.org its foundation :: The Document Foundation -


--
Unsubscribe instructions: E-mail to discuss+help@documentfoundation.org
Archive: http://www.documentfoundation.org/lists/discuss/
*** All posts to this list are publicly archived for eternity ***