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]
