On 08/28/2009 07:16 AM, Karti wrote:
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"))}
...
You can use =ROW(A1:A12) or =ROW(INDIRECT("A1:A12")); they should work
in Excel as well. You can use any column--"A" is as good as any--but the
column has to be specified: Calc always requires both column and row in
a reference.
The second form is usually better, even though it's longer and even more
confusing, because the indirect reference won't be adjusted by the
application behind your back. If you use the first form, and later
insert a new row somewhere between A1 and A12, the formula will be
adjusted to =ROW(A1:A13), changing the size of the array and possibly
throwing off the calculation.
I often use a named expression to hide the contortions, something like
"INT1_100" for ROW(INDIRECT("A1:A100")).
And, if you only need 1..12, you might use an array constant, which is a
bit more obvious as to the purpose: {1|2|3|4|5|6|7|8|9|10|11|12}.
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
