gnumeric bug with fibionaci



1) Set B2=1, B3=1
2) Set B4=sum(b2:b3)
3) Copy B4
4) Select B5:B15
5) Paste

This should result in the fib series running down B.  Indeed, the formula is
properly propogated down the column, with (b2:b3) being automatically
changed to the appropriate values, i.e., b(n-1):b(n-2).

The problem is that the displayed values are wrong, starting with B10.

Here's what I get, starting with B2:

1
1
2
3
4
5
13
21
9
15
24
39
63

As you can see, the value for B10, which is "9", is wrong, even though
the formula is "=sum(B8:B9)".

Any thoughts as to why this is happening?

--
Todd Graham Lewis            32°49'N,83°36'W          (800) 719-4664, x2804
******Linux******         MindSpring Enterprises      tlewis@mindspring.net



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]