Celio RedFly in Action
November 7, 2009 – 9:36 pm | Comments

A few days ago I commented about the Celio Redfly adding support for BlackBerrys. I came across that bit of information first while researching to purchase a Celio RedFly myself and then while I’ve been …

Read the full story »
Mobility Site Minute

Check out our podcast, the Mobilitysite Minute. Quick news, views, and interviews.

Mobilitysite Contests

The lastest Mobilitysite.com Contests. What can you win today?

Mobility Site Videos

Video reviews, 1st looks, and demos of the hottest mobile devices.

Mobilitysite Polls

Our polls help get our reader’s take on what’s happening in Mobility.

Mobilitysite Reviews

Mobilitysite reviews take you deep into the hottest mobile devices, software and accessories.

Home » Software

Microsoft Excel Calculation BUG! Be aware!

Posted by ctitanic on September 26, 2007 – 1:20 pm
closeThis post was published 2 years 1 month 12 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]

Post to Twitter Post to Yahoo Buzz Post to Digg Post to Facebook

Tags:

ctitanic (728 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).





You can also participate in other conversation in our active forums with 200,000 other Members. It only takes 2 minutes to sign up one time for free in the forums.
  • Doug Smith
    Weird. That's the same amount of rows that earlier versions of excel had. 2007 now has additional rows to 1,048,576
blog comments powered by Disqus