[KLUG Members] re: calc

[Mike Williams]

>
>
>From: komal <agencies_ad1@sancharnet.in>
>To: members@kalamazoolinux.org
>Subject: [KLUG Members] calc
>Reply-To: members@kalamazoolinux.org
>
>Hi!
>I am new Open Office user. I am using one problem that I want to solve using
>solve.I want to fill column with number in a such way that if I delete
>particular row number will automatically updated. I.e I  want to fill cell
>A1 from A50 in a such a way that if I delete entire row A47 all number in A1
>to A50 will automatically updated.
>

Not quite sure what you mean here.  You want 1 to 50, such that if you 
delete 35 the 36 becomes 35 and etc?
If so, just fill them with a formula rather than doing an autofill.  A5 
would say =A4+1, or something. Then autofill the formula not the numbers. 

Note that I haven't tried this with OpenCalc specifically, but it's such 
a basic spreadsheet operation that I can't imagine it won't work.