Calculation Issue Update (Fix Available)

microsoft » Calculation Issue Update (Fix Available)

microsoft » Calculation Issue Update (Fix Available) — Wed, 10 Oct 2007 04:04:05 GMT

PingBack from http://microsoft.whitewitty.info/?p=4926

re: Calculation Issue Update (Fix Available)

Juan Pablo González — Wed, 10 Oct 2007 05:10:42 GMT

Thanks for the update David.

Excel Calculation fix

Bart Wessels' Blog — Wed, 10 Oct 2007 07:48:03 GMT

Two fixes came online today for an error in the display of calculation results in Excel 2007 and Excel...

Excel 2007で結果が65535, 65536になる計算が100000と表示されるバグ

秋元@サイボウズラボ・プログラマー・ブログ — Wed, 10 Oct 2007 09:06:57 GMT

via MSDN Excel Team blog Excel 2007を持ってな...

re: Calculation Issue Update (Fix Available)

MR — Wed, 10 Oct 2007 11:59:17 GMT

We notices that this fix (KB943075) contains two files called excel.msp and oartconv.msp. These file names also appear in fixes KB936509 and KB934391 respectively (the file size is only bit smaller). We just wanted to confirm, if this fix KB943075 replace excel.msp and oartconv.mps files found from fixes KB936509 and KB934391? Many thanks.

re: Calculation Issue Update (Fix Available)

Richard Black — Wed, 10 Oct 2007 12:31:16 GMT

I tried installing the Excel 2007 patch on my desktop PC, but it says:

"The expected version of the product was not found"

The message does not indicate what version it expected to find, or what version it did indeed find.

Aggggh.

re: Calculation Issue Update (Fix Available)

Sean — Wed, 10 Oct 2007 13:26:49 GMT

Should this fix be run when running Office 2002/2003 and using the file format converter?

Microsoft ya tiene disponible el parche para bug de excel 2007 ( 32 MB)

NOTICIAS-TIC.COM — Wed, 10 Oct 2007 13:44:57 GMT

Hace un par de semanas os coemntabamos un fallo de excel 2007. Pues bien, parece que tras un breve testeo Micrososft ya ha lanzado el parche que corrige esos errores de cálculo con un tamaño ni mas ni menos que de 32 MB. Si te encontrabas afectado po

re: Calculation Issue Update (Fix Available)

Wed, 10 Oct 2007 14:12:32 GMT

Just out of interest: Any chance of some more information about what went wrong and how? (Overoptimized floating-point formatting?)

Calculation Issue Excel2007 Update (Fix Available)

Noticias externas — Wed, 10 Oct 2007 14:17:55 GMT

Its an important update but size of the update ~33Mb. Why? What are the things it updated? "Two

Excel 2007 Calculation Issue Hotfix

Guy Barrette's Blog — Wed, 10 Oct 2007 16:12:20 GMT

re: Calculation Issue Update (Fix Available)

Dan B (MS) — Wed, 10 Oct 2007 19:18:16 GMT

MR - You can go ahead and install the versions of excel.msp and oartconv.msp from this patch without worrying about losing previous hotfixes. Hotfixes are 'rollups' that include all previous fixes.

Richard - We've gotten one other report of this and are looking into the possible cause. You may be able to solve it by uninstalling Office 2007 and reinstalling it (then apply the patch to a clean installation). If you try that, I'd like to know the results.

SeanC - yes, if you are running the Excel converter with Excel 2002/2003, you should apply this patch, and it will update the converter.

g - The patch is large because it contains updates for several components that use the Excel logic that showed this issue - you can see those components listed at the bottom of the KB article. Since several of those files are large, it makes the entire patch large.

Fix the converter?

Ben M. Schorr — Wed, 10 Oct 2007 20:37:33 GMT

Just curious, since this is a calculation bug why would we need to fix the file converters? Should Excel 2003 be doing the calculation and thus be unaffected by a calculation bug that exists in Excel 2007? The file converters just allowe Excel 2003 to read/write the new XLSX format, right?

Or does this bug exist in 2003 as well?

-B-

re: Calculation Issue Update (Fix Available)

Jack — Wed, 10 Oct 2007 20:59:04 GMT

"Or does this bug exist in 2003 as well?"

I'm going to check it out right now.

RE: Fix the converter?

Bill — Wed, 10 Oct 2007 22:01:03 GMT

I imagine you'd want the fix for 2003 running the converter for 2007 files. If a file comes to you in the 2007 format, and gets converted, it may not fix the error carried by the 2007 version. To my knowledge a similar bug existed in the '95 or '97 version of excel as well, but not the 2003 version.

Excel Services Calculation Issue Update & Fix!

LuisBE on Services — Wed, 10 Oct 2007 22:21:07 GMT

Please check out David's post for links to the fixes. http://blogs.msdn.com/excel/archive/2007/10/09/calculation-issue-update-fix-available.asp

re: Calculation Issue Update (Fix Available)

DAnglin — Wed, 10 Oct 2007 23:39:11 GMT

It fixed one problem but left the rest 4-4.1 still give 0.0999999996 not .1

Problem with update?

BW — Thu, 11 Oct 2007 02:01:54 GMT

Is there is problem with the hotfix(KB943075)? I tried running the update and I'm getting this error:

The installation of this package failed

and

A problem cuased the program to stop working correctly...

Thanks.

re: Calculation Issue Update (Fix Available)

Thu, 11 Oct 2007 02:16:12 GMT

Dan B, just for the record it wasn't I who commented on the patch size. (I asked a different question. I fear the answer is no.)

DAnglin, that isn't anything to do with this issue, it's just the way floating-point arithmetic behaves. (The number you write down as 4.1, as represented in the computer, isn't exactly equal to 41/10.) In principle Excel could make 4-4.1 exactly equal to 0.1 by adopting (a) decimal arithmetic instead of binary or (b) exact rational arithmetic instead of floating-point, but there are plenty of other problems with both of those. Not least the fact that either would typically be an order of magnitude slower, at least.

re: Calculation Issue Update (Fix Available)

Dan B (MS) — Thu, 11 Oct 2007 02:48:02 GMT

g - Right, sorry about that, I was responding to 'Noticias externas.' We're not planning to share details on this beyond what we've already communicated - i.e. that the issue occurred in formatting of floating point numbers near 65,565 and 65,536. It was code that we introduced as part of the calculation overhaul that we did for Excel 2007 however.

Richard, BW - the one other report we got of the patch not applying correctly turned out to be due to the user having a beta version of Office 2007 SP1 installed. The workaround is as I suggested - uninstall Office 2007 from Add\Remove Programs, reinstall from the CD, and then apply the hotfix.

Hotfix failed to install.

Phawinpon.C — Thu, 11 Oct 2007 03:52:26 GMT

After I tried to install the update, it shown message "The installation of this package failed".

How to correct this problem ?

Patch per bug nei calcoli di Excel 2007

Il Blog di Mario — Thu, 11 Oct 2007 05:46:59 GMT

Microsoft fixes the Excel bug

Craig Bailey Link Blog — Thu, 11 Oct 2007 08:47:20 GMT

Don't dilly-dally, make sure you rush to get the crucial, gaping-hole fixer Excel patch for the rounding

I bug come evento statistico

Marco Russo — Thu, 11 Oct 2007 10:45:17 GMT

Sarà difficile spiegarlo a chi non è tecnico, ma è un dato di fatto che l'unico programma senza bug

Corretto il bug di Excel 2007

Marco Russo — Thu, 11 Oct 2007 10:51:09 GMT

Pochi giorni fa ho segnalato un bug di Excel 2007 , all'interno di un post dove parlavo più in generale

re: Calculation Issue Update (Fix Available)

Korn1699 — Thu, 11 Oct 2007 18:12:02 GMT

Will a new 2003 converter be released with the patch integrated into it?

Excel 2007 patch for calculation issue released

Himanshu — Thu, 11 Oct 2007 18:40:48 GMT

Thanks for the update but are you sure that other office apps like MS Access are safe enough with such kind of bugs ? There's huge database calculations running in servers.

re: Calculation Issue Update (Fix Available)

Donald F. Costello — Fri, 12 Oct 2007 00:09:28 GMT

If Microsoft doesnt disclose what they have learned about the cause of the bug then they are dismissing the opportunity to let the emense staff in the foggy Computer World help them as they have in probably millions if not hundreds of millions of cases in the past. The SYA strategy is not cool.

re: Calculation Issue Update (Fix Available)

Dan B (MS) — Fri, 12 Oct 2007 05:23:33 GMT

Himanshu - For this issue, we're sure that other Office apps are not affected - we did a very complete test pass.

Phawinpon.C (and anyone else who see's the error: "The expected version of the product was not found." All indications are that this means you have a beta version of Office 2007 SP1 installed. If you use Add/Remove Programs to uninstall Office 2007, and then reinstall Office 2007 (but not the SP1 beta), then the patch should apply correctly. This is due to the way Office patching works - it only applys to versions of the product that are generally in-market for the public.

Korn1699 - We are not releasing a new converter at this time, but this patch can be applied to the converter if you have it installed.

re: Calculation Issue Update (Fix Available)

Anon — Fri, 12 Oct 2007 10:37:09 GMT

Will there be notice given on this blog when this patch hits Windows Update?

Excel 2007 Display bug fixed

Another day in the Office — Fri, 12 Oct 2007 13:32:53 GMT

Unless you have been on a deserted tropical island, you would have heard about the Excel 2007 bug whereby

re: Calculation Issue Update (Fix Available)

Beelzebubba — Fri, 12 Oct 2007 19:36:24 GMT

Duh! That happens to be tha maximim value of integers for a 16-bit OS!

Ever try to see what the default value for the last cell in Excel is? I'll give you two guesses...

I have to chuckle every time I see that one dudes sig that has the faux dictionary entry for Windows:

win-does: A 32-bit extention and graphical interface for a 16-bit patch for an 8-bit OS from a 2 bit company that can't stand one bit of competion.

...or something along those lines, I'm quoting from memory!

Just goes to show how much effort they actually put into futhering their software. Just making the "pig" prettier!

Cheers,

Bryan

Micorosoft Excel 2007 Doesn't Excel

Web White Noise — Sun, 14 Oct 2007 07:05:14 GMT

Apparently Microsoft Excel 2007 can't do it's times tables. Microsoft employee David Gainer, has posted on the Excel Blog that when computer users try to get Excel 2007 to multiply some numbers,...

Detailed analysis available

Chris Lomont — Mon, 15 Oct 2007 03:48:27 GMT

I posted a detailed analysis based on disassembling Excel at

http://www.lomont.org/Math/Papers/2007/Excel2007/Excel2007Bug.pdf

I show why precisely the 12 values format incorrectly, what chnaged from earlier versions, and how the hotfix corrects the bug.

Chris Lomont

re: Calculation Issue Update (Fix Available)

Sam — Mon, 15 Oct 2007 09:24:11 GMT

Chris,

The most comprehensive and well written article on the subject...I dont think any one in MS could have done a better job...

Sam

re: Calculation Issue Update (Fix Available)

Bryan Villarin — Mon, 15 Oct 2007 22:19:25 GMT

Will this be available through Windows Update?

Very useful Excel feature

Just code - Tamir Khason — Tue, 16 Oct 2007 12:10:11 GMT

After Excel bugs , where resolved , I started to pay attention of what this program provides me. I noticed

re: Calculation Issue Update (Fix Available)

Steven Palmer — Wed, 17 Oct 2007 09:29:45 GMT

I tried to apply this patch and it said that "I have no affected products", but I do have Office 2007 SBE and my Excel 2007 does suffer from the calculation bug.

EXCEL BUG FIXING

locuratropical — Wed, 17 Oct 2007 23:53:21 GMT

C'e' stato del trambusto nei giorni scorsi per un bug si excel 2007 dove in visualizzazione anziche'

re: The installation of this package failed

Felix — Sat, 20 Oct 2007 22:20:27 GMT

To anyone else getting the "The installation of this package failed" -- it's not a beta version problem necessarily; you also need Windows Installer 3.1 v2 for the patch files to work. This is available as KB893803.

~Felix.

re: Calculation Issue Update (Fix Available)

sam — Sun, 21 Oct 2007 12:14:24 GMT

David,

Kindly patch up the copy of excel on your servers... when to "test drive" excel 2007 in the Web browser...the rendering bug still appears...

Sam

re: Calculation Issue Update (Fix Available)

LongTimeLoyalDeveloper,User — Thu, 25 Oct 2007 20:05:54 GMT

>I tried installing the Excel 2007 patch on my desktop PC, but it says:

>"The expected version of the product was not found"

>The message does not indicate what version it expected to find, or what version it did indeed find.

Dan and Dave, and Bill and every M.S. developer for that matter: please PLEASE study this carefully. That little post may well be the essential expression of what is wrong with Microsoft. If you do nothing more before Judgment Day, "get" what is wrong here. Please "get" its inexcusability.

Brace yourselves: no, the solution is NOT to instead say "Runtime error 1004, application defined or object defined error"

Another Discrepancy (Bug)

Kanwaljit Singh Dhunna — Fri, 26 Oct 2007 18:17:50 GMT

Hi David,

Below is a link highlighting something which I feel should be categorized as a "BUG". I am reporting here because I don't where I should have been reporting. Sorry for that.

http://www.asap-utilities.com/blog/

Problem with copying filtered data in Excel 2007 + workaround

It says "you cannot copy only the filtered data in Excel 2007. If you use the autofilter to make a selection and then you only want to copy the filtered rows, Excel 2007 copied everything, even the hidden rows. This is different from the way Excel 2000-2003 works". In that way Excel 2000-2003 is better than Excel 2007.

Regards

CA kanwaljit Singh Dhunna

India

Another Calculation Issue - Excel will calculate exactly zero

Charles — Wed, 31 Oct 2007 22:00:10 GMT

See below

$145,510.22000000000000000000000000000000 +

$(72,140.74000000000000000000000000000000)+

$(32,041.10000000000000000000000000000000)+

$(30,658.61000000000000000000000000000000)+

$(8,848.40000000000000000000000000000000)+

$(800.22000000000000000000000000000000)+

$(521.48000000000000000000000000000000)+

$(499.67000000000000000000000000000000)=

$(0.00000000000289901436190121000000) should be exactly zero where do the extra numbers come from. Excel does this on a host of other calculations as well.

Microsoft Excel - Criticism - Excel 2007 display error

Confluence: Microsoft — Tue, 28 Oct 2008 09:19:34 GMT

Microsoft Excel Criticism Excel 2007 display error On September 22 September:September 22, 2007 2007:2007 it was reported<ref>