>>>>> "Brian" == Brian Barker <b.m.bar...@btinternet.com> writes:
> At 18:29 18/02/2015 +0100, Uwe Brauer wrote: >> I run for example clean(C2) and it returns Err:522. C is the column with the problems > That means that your formula is circular. I'm guessing that you have > tried putting =CLEAN(C2) into C2 itself. Apart from the fact that this Right! I did this because I thought: if I copy the cell in a new column, and then want to replace the old one with the new one, I will have a problem: the new one depends on the old one and then everything gets deleted. But as you explain below: that can be avoided, thanks for pointing it out. By the way, when I perform this operations for one cell say C2 and then want to enhance it to the whole column, it seems that I can only do it by dragging the boundary of the cells with the mouse. Is this correct? I am asking since the original file in question has a column of 300 rows and using the mouse proved to be very very slow, but clean(C2:C300) did not work neither. Any comments? > 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
