I am not sure, but I don't think things like ROW(1:12) is supported in
Calc. I remember many years ago when I, used to Excel, typed something
like ”=SUM(A:A)” (mening ”sum the entire A column”) in a cell. That
works with Excel, but didn't with Calc. Still today, I don't think
this works…
Johnny Rosenberg
2009/8/28 Karti <kartikeya_...@hotmail.com>:
> Hi,
> The following formula works perfectly in Excel but it does not work in Calc.
> {=Row(1:12)}
> Also the following doesn't work in Calc,
> {=Row(Indirect("1:12"))}
> Can someone help me with the solution for this?
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@openoffice.org
> For additional commands, e-mail: users-h...@openoffice.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
