On Saturday, December 02, 2006 10:05 PM [GMT+1=CET], Nino Pereira
<[EMAIL PROTECTED]> wrote:
<snip>
I think I have found the cause of your problem and it may be a bug in
OOo.
I get your error message if I use "array formulae" as you have done. In
my example I created A1:A12 as sparsely populated. I then defined B1:B12
as an array and then set it to "=10*(A1:A12)". I get the error. However,
if I define B1 as "=10*A1" and then copy/drag the formula down to B12
then the error goes away.
To copy/drag, set the first cell in the result row/column as appropriate
and then click in it. You get a little "+" sign in the bottom right
corner of the cell. Click it and, holding the mouse button down, drag
left/right/up/down to the end of the range you need. Calc will
automatically copy the formula, adjusting row/column numbers as
appropriate. So, in my example above, B2 gets set to "=10*A2", B3 to
"=10*A3" and so on.
If you want to include in your formula a value from a specific cell,
then use "absolute" cell referencing: $A$1 means absolutely row A, col
1. "A$1" means relative row A, absolute col 1. Relative references get
changed automatically during copy/drag; absolute references don't. So,
for example, if you want to extend the above example by *always*
dividing the result by the contents of C3, you could copy/drag
"=10*A1/$C$3.
Harold Fuchs
London, England
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
