From koffice  Tue Jan 29 01:44:28 2002
From: Jonathan <j.e.drews () worldnet ! att ! net>
Date: Tue, 29 Jan 2002 01:44:28 +0000
To: koffice
Subject: Re: kspread: copy paste
X-MARC-Message: https://marc.info/?l=koffice&m=101226869513057

On Monday 28 January 2002 19:37, Bill Spears wrote:
> How do I:
>     put 1 in a1
>     put a1+1 in a2
>     copy a2 to a3 through a10 so that a3 has a2+1 etc.
>
> When I copy a2 and select a3 through a10 and paste, all I get is a3=a2+1
> and nothing in the rest.
>
> Help!?


1
=A1 + 1
=A2 + 1
=A3 + 1
   .
   .
   .

After putting =A1 + 1 in cell A2, grab the frame, surounding A2, by the 
knob, at the lower right hand corner, and drag down.


HTH