VectorLinux
August 23, 2014, 11:04:32 am *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Visit our home page for VL info. To search the old message board go to http://vectorlinux.com/forum1. The first VL forum is temporarily offline until we can find a host for it. Thanks for your patience.
 
Now powered by KnowledgeDex.
   Home   Help Search Login Register  
Please support VectorLinux!
Pages: [1]
  Print  
Author Topic: YAEAB?  (Read 1325 times)
Joe1962
Administrator
Vectorian
*****
Posts: 2499



WWW
« on: September 25, 2007, 09:31:43 am »

Yet Another Excel Arithmetic Bug?: http://www.appscout.com/2007/09/excel_cant_multiply.php

 Roll Eyes Shocked
Logged

O'Neill (RE the Asgard): "Usually they ask nicely before they ignore us and do what they damn well please."
http://joe1962.bigbox.info
Running: VL 7 Std 64 + self-cooked XFCE-4.10
The Headacher
Louder than you
Global Moderator
Vectorian
*****
Posts: 1545


I like the bass to go BOOM!


WWW
« Reply #1 on: September 25, 2007, 10:06:49 am »

That is soooo stupid. If you want to optimize the size of spreadsheets by using different data types you should do it correctly, and test cases that come close to the limit.

A lot of companies use excel sheets for calculations (which is sort of silly if you ask me, but that's another story). The difference between 65535 and 100000 is pretty significant... It could cause some very costly mistakes.
« Last Edit: September 25, 2007, 10:17:27 am by The Headacher » Logged

Most music on my soundcloud page was arranged in programs running on VL.
exeterdad
Packager
Vectorian
****
Posts: 2046



« Reply #2 on: September 25, 2007, 10:13:50 am »

Oh Dear.  MS might have a Corporation or two suing for lost $$.  Hate that.
Logged
saulgoode
Vectorite
***
Posts: 340



« Reply #3 on: September 25, 2007, 11:57:27 am »

Quite entertaining. Some of my favorite responses:

"most numbers seem to multiply ok"

"It's used in the algorithm that MS uses to report Vista sales."

"This is yet another example of where [OOo] Calc fails utterly to be compatible with Excel. How can I use Calc if I can't be sure that it will produce the same answers that my boss gets with Excel?"

"You wanted to see 65,535 and other popular numbers in spreadsheet results? You need Excel Penultimate Edition for that sir!"

"Sufficiently advanced incompetence is indistinguishable from malice."
Logged

A complex system that works is invariably found to have evolved from a simple system that works.
stoichyu
Packager
Vectorite
****
Posts: 369



« Reply #4 on: September 26, 2007, 09:55:41 am »

I remember back in high school, we were taught how to use Excel 2000. Apparently, Excel fails to do simple addition, sometimes. I don't know what I did with it but adding 3 simple numbers was probably too hard for it. The answer it gave was off by 2 and strangely, it only happened to that single spreadsheet. Doing it again from scratch gave me the correct answer.
Logged

There's no place like ~.
VL 5.8 PentiumD 2.8Ghz Registered Linux User #432836
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!