At 11:28 19/02/2015 +0100, Uwe Brauer wrote:
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?
No. Dragging the fill handle (not the cell boundary) is indeed one,
often convenient way. But others are copying and pasting, as well as
using Edit | Fill > | Down. For these, you will need to select the
target range, but you can easily do that using click at one end and
Shift+click at the other.
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.
Actually, you can use formulae like that, where a function operates on a range:
o Select the first cell of the target range.
o Enter the formula.
o To complete the formula, don't press Enter or click the green
arrow. Instead, press Ctrl+Shift+Enter. The formula (visible in the
Input Line) has now grown enclosing braces, as
{=CLEAN(C2:C300)}
- but note that you cannot type the braces yourself. This is called
an array formula.
(By the way, I think I'd established that CLEAN() wouldn't work for
you: three applications would be necessary to remove all five tab
characters and you would still have the remaining space and
non-breaking space to deal with if you wanted to process the values
as numbers.)
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
