RSS Feed
Follow on Twitter
Facebook
Watch on YouTube
This post was published 5 years 7 months 23 days ago which may make its actuality or expire date not be valid anymore. This site is not responsible for any misunderstanding.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]
You can subscribe by e-mail to receive news updates and breaking stories.
Loading ...