Hello, I am exploring fibonacci numbers, and figured a spreadsheet would be the quickest way to generate them. I created a spreadsheet in OOo, and was looking through the results when I noticed some of the numbers don't add up correctly, admittedly they are quite large numbers, but still ...
example follows (and I attached the ods file as well) just using the very first row, cell A1 has a 1 as does cell B1 cell C1 has the expression =a1+b1 I then copied and pasted C1 to the range of D1 to FT1, relying on OOo to change the references in the usual way. I changed the formatting to show full numbers instead of notation, and was widening the cells to be able to read the larger numbers instead of ### . Then I noticed that some of the numbers have a lot of trailing zeros, this just shouldn't be, so I went back to the begining of this discrepancy. And at cells BX1 to BZ1 I found the begining of this problem. If you add the numbers at BX1+BY1 with a calc.exe you will find that the answer in BZ1 is incorrect. 3,416,454,622,906,710 added to 5,527,939,700,884,760 is 8,944,394,323,791,470 and NOT 8,944,394,323,791,460. I promise I'm not using a Pentium with the fdiv bug :) .. actually using an Athlon64 3800+ Thank you, Charles "Theory is when you know something, but it doesn't work. Practice is when something works, but you don't know why. Microsoft programmers combine theory and practice: nothing works and they don't know why."
fibonacci numbers.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
