All the latest UK technology news, reviews and analysis
|
|
|
27 Sep 2007
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.
Latest stories from Security
Related articles
Related jobs
Poll
What is the most important IT priority for your company this year?
Hands on with the highly anticipated Android 4.0 Ice Cream Sandwich hybrid tablet
Connect with V3.co.uk
This paper focuses on a series of best practices and techniques for development teams looking to improve their software development processes
Why good data management at all levels is essential in the modern business (video, 6mins)
/ Corporate Account Manager / Management Consultant...
Prince 2 Project Management Professional, Client Facing...
Solution Architect / Technical Project Manager / Corporate...
Solution Architect / Technical Project Manager / Corporate...
Keep up to date with the latest products, services and technologies from the world's leading IT companies. IThound.com brings you over 2,000 white papers, case studies and analyst reports.
Do you agree?