Excel 2007重大bug：850×77.1＝100000 (ZZ)

经本人确认:

Google Group里一个以微软Office Excel为主题的新闻组里有人报告说，Excel 2007里存在一个重大bug，会将850*77.1错误地计算为100000，而不是65535。

当然，850*77.1并不是一个特例，不信你可以在Excel 2007里计算下边这些乘法：

=5.1*12850
=10.2*6425
=20.4*3212.5
=40.8*1606.25
=154.2*425
=212.5*308.4
=308.4*212.5
=425*154.2

结果都是100000吧？

这个看起来有些不可思议的问题很快得到了多名专家的确认，Excel MVP Bernad Leingme更是第一个站了出来。

事实上，问题出现在65535这个数字上。虽然现在还没能最终肯定到底是什么原因，但考虑到65535这个数字的特殊性(转换成二进制就是 1111111111111111，16位无符号整数能表示的最大值)，初步怀疑Excel 2007在浮点计算或者舍入误差方面出现了失误。另外还可以看出，出错的乘法公式中至少有一个数字带有一位小数。

更进一步地，如果把上述乘法之一放在A1单元格里，然后A1+1就会返回100001，A1*1返回100000，A1/1返回100000。这些 无疑都是错误的，因为Excel 2007已经把A1的值当成了100000，不过奇怪的是，A1*2返回的却是正确的131070，A1-1也是65534没错，A1/2也准确得到了 32767.5。Excel 2007如此反复无常的确令人难以琢磨。

测试还表明，Office 2000/XP/2003等旧版本都不存在这个bug，看来只是Office 2007的新“专利”了。

出现这么低级的bug，微软工作人员开发和审核的不严谨是很显然的，至少可以说是百密一疏，尤其是旧版产品反而没有问题，无疑会让微软更加尴尬。

http://news.mydrivers.com/1/91/91929.htm

网球鞋

今年六月买的网球鞋三周前已然鞋底见肉，不行了。经宝宝提醒，联系经销商询问质保期限。今日再度去电，被告知Adidias只有Barricade 和 Accelerator 有六个月的质保期，直接通过Adidias。 原来如此，设计上就用了定期早死的材料。下次看到两边有Michilen或者Goodyear的，得好好试试。

中秋又至

中秋来临之际，收到一堆礼物，还有一张支票。正好可以放入我参加茶公/茶母（韩国古装连续剧名）婚礼拿到的相框，做个长长久久的纪念。
祝大家团团圆圆，日子和和美美，人人心宽体胖，有情人都成眷属。
还有几个没结的？喂，那个谁，你四处看个啥呀，说的就是你呢。
还有你，还笑呢，没见这个生猪头，那个就要生猪尾么？你肚子怎么就还不大呢？
幸福的日子，还长着呢，大家好好享受吧。

Bewail the death of Laura

It's been about 9 months since we adopted her. We love her so much and seems she loves us too. But when I remembered to feed her today, she was found passed away. My carelessness...... I won't forgive myself, my dear hamster.

Preliminary Oral Exam

On May 4th, the Youth's Day, I passed my Ph.D.'s preliminary oral exam. That's almost the end of the stressful month includes Tae Kwon Do promotion, AcerS annual meeting in Baltimore (which was fun and allowed me to have more than 20 kinds of beers, not to mention seafoods), proposal writting, a full load of experiments including help with another group, prelim, results compiling and gift purchasing.
I'll be posting on my trip back China. It's believed to be terrific. ;)

That's America!
Migraine04

Where we lived...
Migraine04

AcerS meeting

This trip to Baltimore is super! Living in a highest place in downtown. Presentations after presentations; Seafood after seafood; Beer after beer; Drink and get drunk.. &_&
This city is kinda like Tianjin, feeling so familiar......Love it!

tests

It was 80 minutes' drive to the place where Jessie and I test for red belts.
What a hard day!Right after meeting with my professor, I had to run for the promotion.
The good thing is Irene said that we did a great job, although Jessie was kinda worried about wasting that 95 bucks. ^_^
The conductor did give us several black belt level things. The reason why they asked us to do something that we didn't do and was not told to do is to test our patience as martial artists!@#
Good I can focus on my thesis work now.

Gymnastic competetion in Beyer Hall, ISU. Never been so close..... Saw 2 Asian coaches, maybe from China.....
Migraine04

Sunny Friday, sunny campus. How many things can you see in our library?
Migraine04

回家

总算可以准备回家了。今天订到了5月10日 西北的票。＄980。也不想问太多的代理了，大约联系了5家，最后在我印象中比较信誉好的一家：Gateway订的。昨天收到Itinerary之后和同 学一说，才知道当时给我的建议居然是不要到这一家买，因为听说过几起加价事件。~!@##$%^& 回头细细检查,发现代理居然给我订了从怀俄明出发的票！！不可思议的错误........... 一大早同代理联系，改成我的计划路线。机座现已订好。
从我google的结果来看，这一家规模不小，多方推荐。可能正是因为人多量大，很少比例的票额改变率在很大的基数下产生了一定的不愉快的交易。可以理解。
此家出票很快，除了开始的错误，没有其他的意外。推荐。
^_^ ^_^ ^_^ ^_^ ^_^ ^_^ ^_^ ^_^ ^_^要回家啰^_^ ^_^ ^_^ ^_^ ^_^ ^_^ ^_^ ^_^ ^_^

Springs & Spring

Highest score ever...............It's a cool game!! New version nanaca-crash_v106.swf.

Linky:
http://www.geocities.jp/lledoece/nanaca-crash_v106.swf
*******************************************************
Spring is here again. But it seem that every time I believe spring is coming to Ames, it will snow the next day, or snow after rain. My preciooooooooooous spring..........
Migraine04

Lady in red? This is what our office looks like. Messy! hehehe.... I'm not better.
Migraine04

YY made pineapple bread today. Super! Breakfast for the coming week la... &_&
Migraine04

McAfee - Computer Virus Software and Internet Security For Your PC

McAfee - Computer Virus Software and Internet Security For Your PC

I'll be the one to show you the RING
Migraine04

my favorate TV show now
Migraine04