[libreoffice-users] saving as csv newline inserted

Hi

I have an excel (xls) file which I open with scalc (5.3)
and save it as csv

Unfortunately it looks like

Field1,Field2,Field3,Field4,Field5
"Name","05329954A
           ",0.55,0.75,1.3

Instead of

Field1,Field2,Field3,Field4,Field5
"Name","05329954A ",0.55,0.75,1.3


The reason is that in the first column there is a after name a space
which is translated to a newline when exporting.

How can I get rid of this unwanted newline?
I tried to format the cells but it seemed not to have worked.
Thanks

Uwe Brauer 


-- 
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