[KLUG Members] calc

bsnl members@kalamazoolinux.org
Tue, 18 Nov 2003 23:19:24 -0800


No. I think you didn't get me correctly. I want to design sheet in a such a
way that if i enter number in A5 to A50 like 1 to 50 and if i delete any one
of the row say A35 then all the number in a a5 to a50 should automatically
update.

Thanks

komal
----- Original Message -----
From: "Nik R." <nrclan@mei.net>
To: <members@kalamazoolinux.org>
Sent: Sunday, November 16, 2003 11:29 AM
Subject: Re: [KLUG Members] calc


> Put in a sum function on your total line like this =SUM(A1:A50) and it
> will update dynamically.
>
> On Sun, 2003-11-16 at 11:11, komal wrote:
> > 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.
> >
> >
> >
> >
> > _______________________________________________
> > Members mailing list
> > Members@kalamazoolinux.org
> > 
>
>
> _______________________________________________
> Members mailing list
> Members@kalamazoolinux.org
>