Microsoft's OOXML Formulas Could Be Dangerous 360
hill101 writes "According to Rob Weir's blog, Microsoft's 325-page OOXML specification for spreadsheet formulas is deeply flawed. From basic trigonometric functions that forget to specify units, to statistical functions, to critical financial functions — the specification does not contain correct formulas that could possibly be implemented in an interoperable way. Quoting Mr. Weir: 'It has incorrect formulas that, if implemented according to the standard, may cause loss of life, property, and capital... Shame on all those who praised and continue to praise the OOXML formula specification without actually reading it.'"
Proof that open formats are a good idea? (Score:5, Interesting)
Because the format was an "open" standard, the serious flaws present in the format were quickly and correctly identified by third parties outside of Microsoft.
If it had been a trade secret, it could have been bundled into a product, and assumed to be reliable by its users. Instead, it's been exposed for what it is.
If anything, this proves that open formats are a good idea.
Re:EULA? (Score:3, Interesting)
And proof that single-ownership is bad (Score:4, Interesting)
a) wait until MS change the standard
b) then progress it through the "approvals" procedure
c) find out again if there are any problems (and go back to a)
d) implement these changes
And when it comes to WordSpacingLikeWord95 or whatever, how has this being "open" helped? People have asked what it means and been told nothing useful.
Oh, and doesn't this show that if MS had opened up the standard for perusal BEFORE filing it (like ODF did), wouldn't we have avoided this problem?
Re:Proof that open formats are a good idea? (Score:5, Interesting)
Surely we all saw this coming (Score:3, Interesting)
Anybody keeping a comprehensive and up-to-date list (or list of lists) of specific things that are wrong with OOXML? I see a bunch of scattered ones here and there. Of course, I've also wished there were a comprehensive list of specific "bad" things that MS has done; it would make demonstration of their unscrupulousness that much easier.
Re:Yeah, I'm sure this guy is objective (Score:4, Interesting)
If you read the article it isn't a cople of minor mistakes which can be corrected; it's a number of mistakes which have already made it past a review stage.
Implied warranty - fit for the purpose (Score:5, Interesting)
>
> * We trust all hand tools like wrenches and sockets to be exactly the size on the label
> * We trust all of our doctor's opinions whether or not a second opinion is recommended
> * We trust our math applications to do math properly
> * We trust our spell checkers to check properly
>
> In general, we trust the things we by to work as expected... as advertised.
http://www.oandp.com/edge/issues/articles/2006-08
http://www.brajeshwar.com/finance/insurance/Liabi
These links refer to the concept you're talking about. The second refers to the UK Consumer Protection Act, but the concept is general and fairly well accepted. From the first link:
"...any product that is sold comes with an implied warranty of merchantability and fitness for a particular purpose; and, just by selling a product, a seller is implicitly promising that: (1) the product is merchantable, i.e., fit for the ordinary purposes for which such products are to be used, provided that the seller is in the business of selling products of that kind; and (2) the product is fit for a particular purpose, provided that the seller, at the time of sale, knew the particular purpose for which the product was required, and the buyer relied upon the seller's skill or judgment in selecting a suitable product for that purpose."
This hasn't been successfully applied to software cases like this, but the issue hasn't be ruled out either. But it's hardly a stretch to expect that software such as a spreadsheet comes with an implied warranty that ordinary financial and statistical calculations are properly performed.
Microsoft can't code (Score:5, Interesting)
Amazing. That's the sort of mistake you'd expect from a First Year Computer Science Major, but not from a Second Year. This isn't the first time Microsoft have done this. Even for the Windows API, the code trumped the documentation. The best way to find out what a feature did was to write test programs to poke at it. Heck. Until recently DirectX needed three pages of goobleydo-gook to start up. These people just don't get APIs, period.
In Microsoft Visual Studio when you press F1 Help it comes up with a list that includes "How to Write Good Code". Yes, by Microsoft. Even in the early hours of the morning, it gets a smirk if not a gufaw or a laugh. Microsoft are not good programmers. Haven't been for a long time. Anyone worth their salt will launch a Start Up, or at least join a company offering reasonable growth and prospects. Microsoft is like a Pyramid Scheme. The people that joined at the start did very well. As for the people that joined late... not a chance. Which makes you wonder about the ones that joined anyway. Read the Book "Microserfs".
> Ecma
Why didn't Ecma pick it up? These Standard Bodies are in-name only. When a "Member" wants to push something through, it gets pushed through. Then the Member's sales reps can go to the Government body and say "Look! We have an Ecma approved Standard" and t he Government worker ticks the "Uses Industry Standards" box on the tender.
One of the funnier "standards" was a simulation standard called HLA. It was approved before anyone had built a proof of concept. People bet their careers on it and the whole government was ordered to embrace it. The only problem: When they finally built it, it didn't work. *OUCH!*
Re:EULA? (Score:3, Interesting)
Re:Proof that open formats are a good idea? (Score:2, Interesting)
FTA:
This is to be expected... (Score:3, Interesting)
Re:nCr mapped to AveDev?!! (Score:2, Interesting)
In the MSDN documentation for
Note This feature has been designed to be used in conjunction with a prerelease version of an anticipated successor to Microsoft Visual Studio
Now it took a while to parse that and I decided that I might possibly in the future write some code for it but only if I cannot find a better IDE/ and dev system.
MS have really started to come apart at the seams.
Re:Proof that open formats are a good idea? (Score:3, Interesting)
In the standards committee it was typical to find 50 people in a room reading *each* *single* *word* of the draft standard and arguing for hours over a single line - 8 hours a day for five days at a stretch. Immense attention to detail was spent on considering every possible interpretation of the words and wrangling over the best and most precise, unambiguous way to define what the standard was supposed to mean. The fact that the original C standard passed through almost unmodified (though slightly extended) in its later version is testament to all that work. Typically the people who work on standards committees put in vast amounts of effort to avoid precisely the lameness that TFA's article refers to. Seriously - not to specify whether SIN uses degrees or radians is inconceivable for an ISO standard.
Bill Plauger in particular did Trojan amounts of work on the C libraries to avoid dumb mistakes of those kinds.
M$ statement at Beuro of Indian standards (Score:2, Interesting)
As a part of M$ ECMA fast track process ISO/IEC JTC1, Bureau of Indian Standards(BIS) a P-member of ISO has to vote on OOXML. The Discussions for this is going on now. You can see the Documents at http://www.odfalliance.in/OOXML.html [odfalliance.in]
Here [odfalliance.in] (Page 4, item 9b) M$ repeats again the same affirmation: "Ecma 376 contains full documentation for spreadsheet formulas"
Full documentation for Microsoft and ECMA = copy and paste of Excel formula Online Help
From Minutes of Meeting of BIS working group on wordprocessing ML held on May 07, 2007, with comments [odfalliance.in]
Two beautiful points in MS response:
OOXML does not have a large number of features but is "feature rich".
6000+4000 pages of OOXML specifications are needed because MS couldn't be bothered to ask Oasis to define spreadsheet formula's
Re:now arriving at Dallas-Fort Worth... (Score:3, Interesting)
If trial lawyers are so despicable, you should vow to never, EVER, use them. EVER. But you know you would. That either makes *YOU* evil, or them not. Which is it?
Additionally, if trial lawyers are so awful, doesn't that make trials awful, by association? I mean, the whole point of a trial lawyer is to argue a trial. This seems a fairly fundamental requirement for a free and civil society.
Instead of fixing the legal system, you'd rather just do away with that portion of it altogether? What's this got to do with whether insurance itself is good or bad? Or trials are good or bad?
Re:Proof that open formats are a good idea? (Score:3, Interesting)
If you have been involved in drafting the C standard then you should be aware of the list of defect reports [open-std.org]. You should know that it is almost impossible to precisely specify every single detail that a normal working human would naturally assume.
The standard is far from complete in the sense that a literal and mechanical interpretation of it won't produce a working C compiler. You still need a human to fill in the gaps and to guess the trivially sane assumptions. Also remember that C standard is a much simpler thing to specify than the file format for an office suite. And yet it takes, as you say, 50 people in a room reading every single word.
And for the record, I work with implementing and testing JSR:s. They also contain goatse-sized holes, which is why the JCP requires reference implementations because specs never specify everything they need to specify.
Re:Proof that open formats are a good idea? (Score:3, Interesting)
Any standard that's intended for human readership will suffer precisely because it's written for humans. Attempts to use formal specifications (perhaps denotational semantics or something like 'Z') haven't really caught the public imagination though it would have been interesting to try. I'm sure I remember that being discussed tangentially during one of the boozy degenerations of an ANSI meeting after a long day of wordsmithing circa 1985.
Maybe it was a typo that italicised the 'If' in 'If you have been involved'
Sadly I'm also caught up in the mire of OOXML fast-track reviewing as a member of the British Standards Institute's panel. There are some very serious questions to be raised about just what can be done with a document that's so big. It probably took hundreds of staff-years of work in total to produce something as short as the C standard. Where does the effort come from to review and QA something so very much bigger?
Re:MS Office approx. Reference Implementation (Score:3, Interesting)
However, in practise does MS office not act as a reference implementation to clear
up ambiguities? ''
That's how Microsoft works. That's not how standards work.
The right way to handle this would be to take the whole thing away from Microsoft, who clearly doesn't have people who can do the job, and give it to people who have experience with standards, and let them create a workable standard. Then Microsoft can try to create an application that follows this standard, and they can try to translate old office documents to the standard.
On the other hand, you could save a lot of work by throwing away this whole nonsense, and let Microsoft use an existing, well-designed and carefully reviewed standard like the OpenDocument Standard.