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 <[email protected]>: > 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: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
