This post was published 2 years 1 month 26 days ago.
It\'s is possible that the information within this article is now out of date or updated.

Like if the SP1 fiasco was not enough, today Microsoft officially admitted a very important bug found in Excel calculations.

Yesterday evening we were alerted to an issue in Excel 2007 (and Excel Services 2007) involving calculation of numbers around 65,535.  The first example that we heard about was =77.1*850, but it became clear from our testing as well as additional reports that this was just one instance where Excel 2007 would return a value of 100,000 instead of 65,535.  The majority of these additional reports were focused on multiplication (ex. =5.1*12850; =10.2*6425; =20.4*3212.5 ), but our testing showed that this really didn’t have anything do to with multiplication – it manifested itself with many but not all calculations in Excel that should have resulted in 65,535 (=65535*1 and =16383.75*4 worked for instance).  Further testing showed a similar phenomenon with 65,536 as well.

Like I said in my previous post: We need less pirouettes and a better job.

[Via JkonTheRun]

ctitanic (735 Posts) - Website | Twitter | Facebook

Working as IT Professional since 1994. IT Manager since 1999. Microsoft Most Valuable Professional in Tablet PC/UMPC since 2007. Owner/writer of www.ultramobilepc-tips.com . Published many articles in todoUMPC Magazine, www.todoUMPCmagazine.com, the first online magazine all about UMPCs. Maker of Tweaks2K2, a registry hacking tool for Pocket PC devices (www.tweaks2k2.com).