Thanks Jerry, it works magic! 2008/12/23 Jerry Feldman <[email protected]>: > On 12/23/2008 03:16 PM, zhang zhengquan wrote: >> >> Dear openoffice Calc users: >> I am pretty new to openoffice and I would like to know >> how to generate a sequence of numbers from 1-60 in a column, >> >> I hope it will look like this >> 1 >> blank >> blank >> blank >> 2 >> blank >> blank >> blank >> 3 >> blank >> blank >> blank >> >> >> > > You can do something like: (assuming column A; > In A1 place a 1 > Leave A2, A3, A4 blank > In A5 enter a formula "=A1+1" > Select cells A2 through A5, click Edit Copy, or ctrl-C, or the copy icon.. > Then place your cursor into the cells to want to copy into, such as A6 > through A43, then click on Edit/Paste, Control-V, or the paste icon. > > This is simplistic, but it works. > > -- > Jerry Feldman <[email protected]> > Boston Linux and Unix > PGP key id: 537C5846 > PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846 > > > --------------------------------------------------------------------- > 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]
