Dear Joe, Thanks for the clarification. Is it possible to translate this http://www.cpearson.com/excel/betternetworkdays.aspx in calc?
"Joe Smith" <[email protected]> wrote in message news:[email protected]... > 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: [email protected] For additional commands, e-mail: [email protected]
