El 19/02/15 a las 05:28, Uwe Brauer escribió:
deletes that value to are trying to recover, it suggests that you want > the value in C2 to be a CLEANed version of the value in C2 - > which is a CLEANed version of what is in C2! The formula refers back > to itself repeatedly, and the calculation can never end.> If you were to use a formula to achieve what you need, you would have > to put it into a spare column. You could choose to copy the results > back into the original cells, but you would need to use Paste Special > instead of ordinary paste and to deselect Formulae in the Paste > Special dialogue so as to freeze the results. > I trust this helps. Thanks indeed it does. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Maybe, as Andrew sugested in the list , the search and replace could be the solution. Try this. First, select the column C Call the search and replace option in the edit menu. In Search box fill with \n\t\t\t\t\t.. In Replace box left empty Click to open the more options mark option "Only in current selection" (I'm using a spanish versión, so I don't remember the correct words in english) mark oprtion "Regular expression" Click Replace all The pattern "\n\t\t\t\t\t.." correspond to the weird caracters in cells of column C, if this pattern change, maybe this solution need a fix. Try it, and we'll see. SECOND VERSION.. Searching a little deep. I Found that you can use [:cntrl:] in search box, to erase all non printable characters. Doesn't matter if the pattern change. Maybe this is the easy way to solution Uwe's problem. Bye -- 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
