[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice
Subject:    Re: KSpread; absolute cell references?
From:       Pam R <pamroberts () blueyonder ! co ! uk>
Date:       2002-03-25 13:39:41
[Download RAW message or body]

On Monday 25 March 2002 12:43 pm, Werner Trobin wrote:
> On Monday 25 March 2002 13:12, Pam R wrote:
> > How can I include a cell reference in a formula so that always refers to
> > the same cell even when I copy & paste the formula to other cell(s)?
> >
> > For example, if I have a single value in B1 and a lot of values in A3 to
> > A20 and want to calculate B3 to B20 as B1 times the corresponding value
> > in A3-A20:
> >
> > In Excel I can do this by entering the formula '=$B$1 * A3' into B3 then
> > just copying this down into B4-B20
>
> Yes, now try the same with KSpread... surprise! ;)
>
> Ciao,
> Werner
>
> P.S. When you do exactly that you don't get results in the cells, but this
> happens due to a dependency bug. Anyone?
> To work around you have to edit one of those copied cells.

Thanks (I think).  I was confused because I'd been trying it with KSpread 
from yesterday's cvs and couldn't get any results other than 0 in any of the 
cells containing the $B$1 type of reference, even after I tried to edit them. 

But I've just checked it in an older version of KSpread and that seems to 
work ok. Another small step backward for mankind?

Pam
-- 
Linux Step by Step (UK mirror): http://www.pam.roberts.btinternet.co.uk/sxs/
[prev in list] [next in list] [prev in thread] [next in thread]