search technology reviews, news, features, group tests
Popular Searches:   free , windows , video
 |  Register
 |  Newsletters  | 
Sitemap  |  RSS
RSS
Sunday November 29, 2009 12:21 PM AEST
Skip Navigation LinksPC Authority > News > Excel 2007 fails maths test
NEWS

Excel 2007 fails maths test

by Shaun Nichols  on Sep 28, 2007
Tags: Excel | 2007 | fails | maths | test
Spreadsheet software displays incorrect numbers.
Microsoft has admitted to a flaw in Excel 2007 which causes certain numbers to be displayed incorrectly.

The problem occurs when Excel attempts to display 65,535 or 65,536. Rather than displaying the actual number, the cell instead shows the value at 100,000.

The number 65,535 often appears as a maximum value in computing operations because it is the highest number which can be represented as a 16-bit unsigned number.

Excel group programme manager David Gainer assured users in a company blog that, while the number in the cell is incorrect, the value stored in memory will be accurate and will not throw off further calculations.

Gainer said that the issue occurs when any of six floating point numbers are displayed, and attributes it to "changes to the Excel calculation logic" made during what Gainer terms "the Office 2007 time frame".

A fix is in the final stages of testing, but Gainer would not give an expected date for release. Other versions of Excel are not affected.

Copyright © 2009 v3.co.uk
Email a Friend Email this
Print Page Print this
Tweet This Tweet this
Feedback Send us your tips


Ads by Google

Comments

Be the first to comment on this article.
Thoughts on this article? Add a comment below.
Login or register to submit a comment.
 

Top Stories

 All I want for Christmas...Apple slapping on the discount stickers this Friday
If you're looking to buy an Apple product then this Friday is your lucky day, with Apple planning a "Black Friday" discount frenzy.
 
Telstra release slew of new plans, Earth fails to shake
New broadband plans from Telstra with bigger download quotas are welcome, though you'll still find better value with the competition
 
TiVo 2.0:  Revamped content line-up could fuel box bust-up for pay TV competition, as IPTV era begins
TiVo have doubled their drive capacity, introduced IPTV capabilities, vast amounts of new content and better home networking options. But can the marketplace handle another content provider?
 


 
Intel
 
 
LogMeIn
 
 
Amazing Dell Coupons now available
 
Discover Apple