El 17/02/15 a las 06:00, Uwe Brauer escribió:
Hello
I periodically receive excel files (generated by Office 2010 I think,
but saved in the old binary format).
Some of these columns cause me problems, since they seem to contain spaces
and even newlines. I could correct that manually, but since the file
contains hundred of lines this is cumbersome.
So the question is whether there exist any formating function which
could resolve the issue.
I attach an (shorted) example of the problem and would appreciate any
help. Using Linux and OO 4.1.
Regards
Uwe Brauer
Uwe and List friends, Good Morning.
Looking your file, I think this information maybe is imported into excel
from a text or csv file, and this process is not doing very well.
You can use TRIM() or LIMPIAR() "in spanish" function over de column C
and correct the spaces or tabs.
Or maybe ask the informartion in text form, so you can import directly
into libreoffice.
Have a nice day.
--
Manuel Andrés Ramírez P.
Informatic Administrator
GNU/Linux Registered User:412887
Visite:www.getgnulinux.org/es/
<<Yo Tengo mi Office Legal y no pagué por su licencia>>
"El placer más noble es el júbilo de comprender"
(Leonardo Da Vinci)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
