El 17/02/15 a las 10:06, Brian Barker escribió:
At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote:
El 17/02/15 a las 06:00, Uwe Brauer escribió:
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 formatting function which could resolve the issue.
You can use TRIM() or LIMPIAR() "in spanish" function over the column
C and correct the spaces or tabs.
I tried TRIM(), but this seemed to do nothing in this case. It would
not remove the tabs or line breaks or non-breaking spaces; it could
remove the ordinary spaces, but only when they were trailing - so only
if the non-breaking spaces had already been removed.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Brian,
Sorry, I tested with libreoffice in spanish and use LIMPIAR() function,
so I translated wrongly as TRIM(), but now I realize that the correct
funtion is CLEAN()
Try with CLEAN() over de Uwe attachment.
Hava a nice day.
--
Manuel Andrés Ramírez P.
Administrador Informático
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: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
