gnumeric bug with fibionaci
- From: Todd Graham Lewis <tlewis mindspring net>
- To: gnome-list gnome org
- Subject: gnumeric bug with fibionaci
- Date: Tue, 20 Oct 1998 17:30:49 -0400 (EDT)
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]