Slashdot Mirror


Microsoft's OOXML Formulas Could Be Dangerous

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.'"

360 comments

  1. EULA? by Anonymous Coward · · Score: 5, Funny

    if implemented according to the standard, may cause loss of life, property, and capital...

    Didn't you read your Office EULA?

    Microsoft specifically disclaims any damage relating to loss of life, property, or capital.

    1. Re:EULA? by setagllib · · Score: 2, Interesting

      Precisely because it's so likely with Microsoft products. If they didn't disclaim it they'd be in serious trouble. Disclaiming doesn't make it a non-issue though.

      --
      Sam ty sig.
    2. Re:EULA? by Anonymous Coward · · Score: 1

      All (OK, almost all) EULAs do this. Nothing special about Microsoft here. If I could get a piece of software that said, "We claim all responsibility for all kinds of damage caused by flaws in our product," that'd be too good to be true.

    3. Re:EULA? by setagllib · · Score: 1

      Like you said, 'almost' all. Many markets actually hold their suppliers to certain standards. I'm pretty sure NASA's software developers are held accountable, not that it has counts for much, what with their repeated incompetence. Still, I'm sure butts were liberally kicked.

      --
      Sam ty sig.
    4. Re:EULA? by jeffasselin · · Score: 2, Interesting

      Well, here in Quebec at least, such provisions are illegal and software manufacturers can and have been held responsible for the reliability and functionality of their products.

      --
      If he explores all forms and substances Straight homeward to their symbol-essences; He shall not die.
    5. Re:EULA? by Anonymous Coward · · Score: 0
      Sounds like Quebec:

      1.doesn't understand software and computers

      2. will have a stifled market for software

      3. costs will go up due to lack of supply.

      Think doctors and malpractice lawsuits. Texas just put a cap on malpractice lawsuit awards and doctors are flooding there, sure to drive health care costs down.
    6. Re:EULA? by trianglman · · Score: 2, Insightful

      Actually, in the US, many provisions in most EULAs are illegal and not considered valid. I don't know specifically about the "no liability" clauses, but I do know that in somewhat related cases, warnings do not remove a company's liability (i.e. wet floor signs aren't protection against a company being sued when a customer falls on said wet floor). I personally don't see why holding a company liable for damage caused by their software is a bad thing. It might get us software that will actually work...

      --
      Clones are people two.
    7. Re:EULA? by daem0n1x · · Score: 1

      They would be owing me a shitload of money if it wasn't for that.

    8. Re:EULA? by RobertLTux · · Score: 1

      I think if a suit happened then you would get a lower penalty if you had an arguably "effective" set of signs. Now if you didn't post at all then you would get very sued since you didn't make any effort to warn folks of the hazard. I think if you actually locked the door (or have some sort of "Force Field" surrounding the area) you could not be sued.

      Please note IANAL so if you need to use this data please consult one in your area.

      --
      Any person using FTFY or editing my postings agrees to a US$50.00 charge
    9. Re:EULA? by digitig · · Score: 1

      if implemented according to the standard, may cause loss of life, property, and capital... Where is that quote from anyway? I can't find it in the RA.

      Anyone who is using software for a safety-of-life application when the software has not been validated for that specific application [1] is not competent to do the job, irrespective of what's in the EULA.

      [1] Or whoever authorised the software for that application, at least.

      --
      Quidnam Latine loqui modo coepi?
    10. Re:EULA? by rbanffy · · Score: 1

      Yeah... Right...

      Just try to pull that off with flight control, nuclear facility operation or something equally critical.

      "Geez, chief. Dunno what happened. The software said we could remove the moderator bars safely"

      or

      "How come we crashed the plane? The navigation software assured us the mountains were 1.6 miles to the left!"

    11. Re:EULA? by Geek+of+Tech · · Score: 1

      Wait. Does this make Microsoft into a legal hitman? Cool. I think I'll start giving all of my enemies copies of Vista, XP and Bob...

      --
      Stop the Slashdot effect! Don't read the articles!
    12. Re:EULA? by kestasjk · · Score: 1

      Well, here in Quebec at least, such provisions are illegal and software manufacturers can and have been held responsible for the reliability and functionality of their products. The BSD license basically says nothing more than "I, the coder, will not be responsible if something goes wrong", so this isn't a new clause or a Microsoft specific clause.
      --
      // MD_Update(&m,buf,j);
    13. Re:EULA? by cyphercell · · Score: 1

      I think if you actually locked the door (or have some sort of "Force Field" surrounding the area) you could not be sued.

      You don't remember any stories about burglars breaking into houses, slipping on skateboards and suing, cause I do (might be legend too though), funny thing is I don't think there was even a reduction in damages.

      --
      Under the influence of Post-Cyberpunk Gonzo Journalism
    14. Re:EULA? by cyphercell · · Score: 1

      1.doesn't understand software and computers

      This is a myth. Some systems are actually designed to be used rather than just shoved out the door.

      --
      Under the influence of Post-Cyberpunk Gonzo Journalism
    15. Re:EULA? by jeffasselin · · Score: 1

      As far as I know, these law-required provisions are only required if you SELL your product. If it's free, well...

      --
      If he explores all forms and substances Straight homeward to their symbol-essences; He shall not die.
    16. Re:EULA? by jeffasselin · · Score: 1

      You are thinking about a system like in the US where someone could sue a company for millions of dollars for damage. Up here, you could certainly get the cost of the software back and return it, which only makes sense. Beyond that, you would have to prove actual financial damages and would almost never get much more than that.

      Over-litigation and mounting monetary rewards are mostly a US problem. What's more these provisions only apply to stuff you pay for: OSS isn't affected.

      --
      If he explores all forms and substances Straight homeward to their symbol-essences; He shall not die.
    17. Re:EULA? by CastrTroy · · Score: 1

      I don't think putting up the warnings reduces your liability, but placing a caution sign on the floor does lower the chance of somebody slipping on that floor, and giving them a reason to sue you. That lady who sued McDonald's because she spilled coffee on herself says different though. Now McD's places a warning label on their coffee, letting you know that it's hot. It's still really damn hot, so I'm not sure how this would remove any liability. I find that their coffee twice as hot as most other coffee places. Obviously not in temperature, but in the way that I can only hold the cup for half the time of any other place before my hand gets uncomfortably hot.

      --

      Anthropic principle: We see the universe the way it is because if it were different we would not be here to see it.
    18. Re:EULA? by Discoflamingo13 · · Score: 1

      Name some NASA catastrophes that are the direct result of software error.

  2. Please No! by mhannibal · · Score: 1, Funny

    Commenting without reading the background information?! Good god - not on /. Please say it ain't so!!

    1. Re:Please No! by mhannibal · · Score: 0

      What the h*

      This isn't Offtopic! It might be Redundant though...

    2. Re:Please No! by FST777 · · Score: 1

      Some mods don't even read the summary, let alone TFA. I feel your pain.

      --
      Free beer is never free as in speech. Free speech is always free as in beer.
  3. Impartial reviews by KiloByte · · Score: 5, Funny

    Shame on all those who praised and continue to praise the OOXML formula specification without actually reading it.
    To the contrary, they have all carefully read the checks they received.
    --
    The creatures outside looked from Alt-Right to Antifa; but already it was impossible to say which was which.
    1. Re:Impartial reviews by Anonymous Coward · · Score: 0

      In American English, it is "checks". You fail it...

    2. Re:Impartial reviews by VirusEqualsVeryYes · · Score: 5, Funny

      Not to be a grammar Nazi, but

      1. "not" should be capitalized;
      2. "nazi", as a proper noun, should be capitalized;
      3. "words" should be singular, as you are referring to one single word, "check";
      4. "im" should be capitalized and spelled with an apostrophe;
      5. there should be a period after "mistake"; and
      6. "cheque" is, if not only the British spelling, interchangeable with "check" -- in an international forum such as the Internet, both are acceptable.

      Please surrender your club card at the next meeting. Have a nice day.

    3. Re:Impartial reviews by Arancaytar · · Score: 1

      > not to be a spelling nazi, but the words you're after is cheques. im sure it was an honest mistake

      - Not
      - the word ... is
      - I'm
      - mistake.

      You had this coming; glass houses etc. :P

    4. Re:Impartial reviews by miro+f · · Score: 0, Offtopic

      not to be a spelling nazi, but the words you're after is cheques. im sure it was an honest mistake

      - Not
      - the word ... is
      - I'm
      - mistake.

      You had this coming; glass houses etc. :P


      "The word you is after"?

      How's that glass house treating you?
      --
      being vague is almost as cool as doing that other thing...
    5. Re:Impartial reviews by Random832 · · Score: 1

      not to be a spelling nazi, but the words you're after is cheques. im sure it was an honest mistake

      - Not
      - the word ... is
      - I'm
      - mistake.

      You had this coming; glass houses etc. :P


      "The word you is after"?

      How's that glass house treating you? How about "the word you are after is"?

      Don't criticize people for imagined mistakes, they make plenty of real ones anyway. ... ...

      glass houses, etc. :-P
      --
      We've secretly replaced Slashdot with new Folgers Crystals - let's see if it notices.
    6. Re:Impartial reviews by Phisbut · · Score: 1

      "The word you is after"?

      Try "the word you are after", instead of the original "the words you are after". "cheques" is a single word, therefore, "word" needs to be singular.

      Nice try though.

      --
      After 3 days without programming, life becomes meaningless
      - The Tao of Programming
    7. Re:Impartial reviews by mwvdlee · · Score: 1

      You are my hero!

      The funniest thing is "check", although modern spelling, is perfectly acceptable.

      --
      Slashdot social media options: AIM, ICQ, Yahoo, Jabber and Mobile Text. Why no MySpace?
    8. Re:Impartial reviews by Anonymous Coward · · Score: 0

      Wow, so all Americans can't spell then. You ALL fail it.

    9. Re:Impartial reviews by MrManny · · Score: 1

      To the contrary, they have all carefully read the checks they received.

      Though they should have read the specification too, if the checks were written in OOXML formulas.

    10. Re:Impartial reviews by Anonymous Coward · · Score: 0

      Hear hear! Or is that "hear hear?" Any way...

      4. "im" should be capitalized and spelled with an apostrophe;

      He must have read this "Bob" cartoon instead of this one. Personally, as an Asimov fan, I prefer this one. But that one, unfortunately, is about robots rather than apostrophes.

      What was the topic again?

    11. Re:Impartial reviews by Arancaytar · · Score: 1

      > "The word you is after"?

      At the risk of "whooooosh" (sarcasm meter is broken), I'll point out that I meant "The word [you're after] is cheques". I included the verb "is" because it is the one "word" has to agree with ("word is" or "words are", but not "words is"). I left out "you're after" for brevity and to make it clear what part was the error.

    12. Re:Impartial reviews by Anonymous Coward · · Score: 0

      5. there should be a period after "mistake"; and

      Full stop, pricktits.

    13. Re:Impartial reviews by Anonymous Coward · · Score: 0

      Full stop, pricktits.

      What, you're commanding a boat now?

      I feel sorry for your engineer, forced to go through life with the name "Pricktits".

    14. Re:Impartial reviews by Furry+Ice · · Score: 0, Flamebait

      While I fully agree that the rules of English are screwed up, you need to put your trailing comma before the closing quote, not after. Line 2 should have read:

      2. "nazi," as a proper noun, should be capitalized;

      Of course, this rule makes sending grammatically correct emails containing instructions intended to be pasted into a UNIX shell prompt impossible. Should we change the language? Hell yes! Will that happen? I don't know, but it hasn't happened yet.

    15. Re:Impartial reviews by Anonymous Coward · · Score: 0

      Well, we Aussies spell it Chexckques that way everyone fails it...

    16. Re:Impartial reviews by armb · · Score: 4, Informative

      > While I fully agree that the rules of English are screwed up, you need to put your trailing comma before the closing quote

      That's the rule for American English. British English is often more logical.
      http://grammar.ccc.commnet.edu/grammar/marks/quota tion.htm
      http://www.catb.org/jargon/html/writing-style.html

      --
      rant
    17. Re:Impartial reviews by miro+f · · Score: 1

      Well then the "is" is superfluous since it was in the original text to begin with ;)

      --
      being vague is almost as cool as doing that other thing...
  4. So? by ColaMan · · Score: 3, Insightful

    .....if implemented according to the standard, may cause loss of life, property, and capital..

    Pffft....as if this has ever been much concern to software manufacturers before.

    Every EULA has boilerplate text denying all responsibility , and you'd be mad to trust any results from software implicitly. Double check it yourself , even if it's just a few corner cases.

    --

    You are in a twisty maze of processor lines, all alike.
    There is a lot of hype here.
    1. Re:So? by erroneus · · Score: 4, Insightful

      A user NOT trusting his tools is a very strange thing. If it were some sort of software engineer doubting software tools, that's one thing and it's somewhat expected. But in general:

      * 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. (No, I haven't seen Excel advertised to be accurate, but in a math application, it's implied by its very existence) So to say that you should re-check the results by hand is not just ridiculous, it would never happen.

      I remember when the Pentium processor first came out and there was this math error in there somewhere. It was a BIG deal.

      But before passing too much judgment on this too quickly, a little verification of the bugs might be helpful and let's mark our calendars to see how fast Microsoft fixes the problem... oh wait, the problem is said to be in the file specification? What does that mean if they update the format specification with regards to their ISO certification?

    2. Re:So? by ColaMan · · Score: 1

      All your trust examples are good... to a point.

      For me , it'd probably be when the personal financial loss involved gets over $1000 or so, then the trust in what is essentially a black box starts to go down.

      I worked for a time in a lab reporting on coal samples. Penalties for incorrect spec coal can easily end up being half a million bucks for one shipment. My spreadsheets were a small step in the chain of reporting and they took a lot of tedious calculations out of the loop, but I made damn sure they were correct - with test cases of previous data - before letting them loose.

      --

      You are in a twisty maze of processor lines, all alike.
      There is a lot of hype here.
    3. Re:So? by 1u3hr · · Score: 1
      * We trust our spell checkers to check properly

      I don't. I could list lots of dubious or wrong words I've found as "suggested" by various spell checkers, and as many errors they just ignore. Not to mention the problem of the wrong, but correctly spelled, word (horde/hoard, strait/straight, there/their, lose/loose....)

    4. Re:So? by wikinerd · · Score: 1

      * 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

      I don't know how many think like I do, but I generally take everything with a grain of salt. I have never trusted 100% any doctor opinion. If there is something I may say that I trust completely, this is probably rigourous mathematical proofs. Everything else is not to be trusted completely. But it also depends on what definition you put on the word trust.



      A socket may not be of the correct size: The assembly line might have malfunctioned at some point, or a worker might have been sleepy during work. Doctors may act unprofessionally and medicine does not know everything. Maths apps may hide bugs in their source code. And I won't comment on the spell checker example, as I completely distrust all automated spell checkers under the sun, especially the one bundled in Word.


    5. Re:So? by tsa · · Score: 2, Insightful

      In general:

      * We trust all hand tools like wrenches and sockets to be exactly the size on the label


      OK, I'm with you here.

      * We trust all of our doctor's opinions whether or not a second opinion is recommended

      I guess you have a good health and don't see doctors often, or you would never say this.

      * We trust our math applications to do math properly

      Really? I live in a scientific environment and I've never seen a colleague who put his/her full trust in a mathematical program.

      * We trust our spell checkers to check properly

      You're joking, right?

      I myself never trust anything fully, especially if it's capable of doing more than one specific thing. Even if it doesn't have design flaws, it can break or be used in a way it wasn't meant to be used for.

      --

      -- Cheers!

    6. Re:So? by spottedkangaroo · · Score: 2, Funny

      Every EULA has boilerplate text denying all responsibility

      I can't believe this is still happening... Imagine, for example, that your kitchen range or your kitchen table or your window AC unit came with such a document?

      --
      Imagine if you weren't allowed to use roads because a bus company complained about your driving 3 times. --skunkpussy
    7. Re:So? by Eivind · · Score: 1

      You do ? I sure don't trust hand-tools to be exactly the size claimed. They're probably reasonably close, but I wouldn't be terribly surprised to find say some tool that is really a 2-inch tool relabeled and sold as a 5cm one, despite it really being 5.08cm

      I do, generally, trust my doctor. But not blindly. If I for whatever reason think that something he says sounds dubious, and it is important, I can and *will* get a second opinion, regardless of if he recomends that or not.

      I sure as *hell* don't trust general applications (like Excel) to do math correctly. Oh, they're probably sort of close most of the time, but -correct- ? I doubt it. I'm personally aware of atleast something like half a dozen smaller errors, and doubtlessly there's more. (for example: the rounding of financial numbers in the Norwegian version of Excel are not according to how the law says you *have* to do that, so anyone using it for accounting or for calculating invoices would be screwed)

      I trust dedicated math-programs (like Maple and Matlab) somewhat more, beacuse they've been closely scrutinized over years by users who deeply care about getting the details rigth, nevertheless I'm certain they have bugs too.

      And spell-checkers ? You got to be kidding me. They get *most* *grave* errors, but they don't even come anywhere half-close to being 100% correct. And there's large classes of errors where they help not at all. Like if you mis-spell head as "heed" they won't trigger because "heed" is a valid word. (but wrong)

    8. Re:So? by Smidge204 · · Score: 1

      We trust all hand tools like wrenches and sockets to be exactly the size on the label

      If the wrench is mislabeled or out of spec, the worst that happens is it doesn't fit right. Attempting to use a wrench that doesn't fit right will, at worst, damage the nut or bold. Since you're using the tool to begin with, you should have the mechanical aptitude necessary to say "hey, this doesn't fit right..." - which is exactly the opposite of "trusting" the tool. (The decision to use it anyway is up to the individual)

      We trust all of our doctor's opinions whether or not a second opinion is recommended

      A doctor is a LICENSED professional who is HELD ACCOUNTABLE for his mistakes. How many consumer-level software applications are certified and insured against malfunction?

      We trust our math applications to do math properly

      You shouldn't. Not that the two previous examples are in the same category as this one, though. If you explicitly trust whatever data the computer spits out for anything but the most trivial of tasks then you have absolutely no business using one. At the very least you should be running subconscious "sanity checks" to see if the results even make sense. ("2 + 2 = 247.13 huh? Okie dokie!")

      We trust our spell checkers to check properly

      It is still up to you to proofread it and make sure the spellings chosen are still the correct word. Again, if you explicitly trust whatever data the computer spits out for anything but the most trivial of tasks then you have absolutely no business using one. E-mail to a friend is one thing, but if simple language mistakes show up on your resume I don't think I'd put you at the top of the list.

      =Smidge=

    9. Re:So? by Anonymous Coward · · Score: 0

      Which of the three passages below is the authentic excerpt from Wikipedia?

      1. {This page is currently protected from editing until disputes have been resolved.}

        [Image:KarlMarx.jpg]
        United States President Abraham Lincoln was President of the United States during the Revolutionary War, and a well-known Libertarian.[1] Though some historians see Objectivist tendencies in his greatness.[2][3] Many of his most generous qualities can be traced back to the philosophy of Ayn Rand.[4]

        Lincoln is now known to have suffered a mild form of Autism known as Asperger's Syndrome.[5][6][7]

        Assassinated at 54 by a vandal known as Jon Harvey Booth,[8] or some say by political crony Edwin Stanton, Lincoln would have been 187 years old today (as of 2005)[original research?] had he not been assassinated in the prime of his life at the age of 45 by unemployed actor Juliette Lewis Botch.[9]

      2. Conan Christopher O'Brien, 44, is the comedian and the host of The Tonight Show With Jay Leno. He is Scottish, as were his parents, as well as his three brothers and two siblings. He has no relation to CNN anchor Soledad O'Brien.

        O'Brien, who is 43, is commonly thought by television audiences to be of diminutive stature, though some journalists and alternative biographers dispute this claim.

        As of 2007, O'Brien has been confirmed dead of tuberculosis. His hair color was red. He was 45.

      3. The Pokédex (Pokemon Zukan[?], lit. "Pokémon Encyclopedia") is an electronic device designed to catalogue and provide information regarding the various species of Pokémon featured in the Pokémon video game and anime series. The name Pokédex is a neologism including Pokémon (which itself is a portmanteau of pocket and monster) and index. The Japanese name is simply "Pokémon Encyclopedia" in Japanese.

        In the video games, whenever a Pokémon is first captured, its data will be added to a player's Pokédex. In the anime the Pokédex is a comprehensive electronic reference encyclopedia, usually referred to in order to deliver exposition. There are four differently numbered Pokédex modes to date: the Kanto Pokedex, introduced in Pokémon Red and Blue; the Johto Pokédex, introduced in Pokémon Gold and Silver; the Hoenn Pokédex, introduced in Pokémon Ruby and Sapphire and expanded upon in Pokémon FireRed and LeafGreen; and the Sinnoh Pokédex, introduced in Pokémon Diamond and Pearl.

    10. Re:So? by mh1997 · · Score: 1

      I sure don't trust hand-tools to be exactly the size claimed. They're probably reasonably close, but I wouldn't be terribly surprised to find say some tool that is really a 2-inch tool relabeled and sold as a 5cm one, despite it really being 5.08cm
      That's why when going to the hardware store to by a 2-inch tool, I pull out my super duper ultra calibrated caliper to ensure that it is exactly 2 inches! I do this because it is really easy to slide an exactly 2 inch wrench onto an exactly 2 inch bolt.
    11. Re:So? by IDontAgreeWithYou · · Score: 1

      Well, it's a little different with software. The manufacturer of a range, table or AC unit know exactly what you are going to do with it and can assure its safety if used as intended. Microsoft, on the other hand, can't know exactly what the output of an Excel spreadsheet will be used for. As an extreme and unlikely example, imagine an engineer using Excel to calculate stress in a new building. Maybe the result from his spreadsheet is not quite accurate enough and the building falls. It's up to the user to know the limitations of the software.

      --
      Finding other idiots on /. that agree with your opinion doesn't make it any less stupid.
    12. Re:So? by ericrost · · Score: 2, Insightful

      "* We trust all hand tools like wrenches and sockets to be exactly the size on the label"

      Well, technically we trust our hand tools to conform to the nominal size specifications that go along with the size on the label and thus interface correctly with any connector that also conforms to that nominal size specification.

      A 3/8" wrench is not 3/8" EXACTLY, it is some close approximation of 3/8" toleranced such that a correctly toleranced bolt that is a close approximation of 3/8" is guaranteed to be smaller (in the case of a hex head bolt).

      Just your friendly neighborhood mechanical engineer. :)

    13. Re:So? by ddimas · · Score: 1
      A user NOT trusting his tools is a very strange thing.


      21 CFR part 11 specifies that a metrology function SHALL verify the accuracy of all tools and equipment used for the manufacture, analysis, and distribution of pharmaceutical products. The FDA requires by law that you do not trust your tools.

    14. Re:So? by st0nes · · Score: 1

      2 + 2 = 247.13 huh?

      True, but only for very large values of 2.

      --
      Tempora mutantur, nos et mutamur in illis
    15. Re:So? by mwvdlee · · Score: 1

      I'm sure you meant the same thing, but just to be certain;

      We trust the things you list to be correct within a certain margin.

      I don't trust any wrench to be the within a nanometer of the stated size.
      I trust any doctor's opinion if it manages to fix the medical problem.
      I trust my math application to be sufficiently accurate for my needs.
      I trust the spell checker to catch most errors, leave many undetected and even produce a few false errors.

      All of these items (with the possible exception of spell checking, to the best of my knowledge) have some intrinsic problems which means they cannot be 100% accurate, and thus can only be trusted upto a certain point.

      --
      Slashdot social media options: AIM, ICQ, Yahoo, Jabber and Mobile Text. Why no MySpace?
    16. Re:So? by WWWWolf · · Score: 1

      * We trust our math applications to do math properly

      The old problem of "do what I mean, not what I type" applies to mathematical programs. You're expected to give the computer the exactly correct formulae - and sanity-check both the input and the results. If you get wrong results and everything is in place, you're supposed to notice at some level. "Whoops, I forgot to read the documentation for this function" is the most common complaint.

      * We trust our spell checkers to check properly

      Yet the publishers, for some reason, still keep employing "editors" - those pesky people who keep finding tons of errors in the perfectly spellchecked manuscripts you submitted. =)

    17. Re:So? by MontyApollo · · Score: 1

      I don't think anyone is saying there is bugs in Excel or any consumer product. I think they are complaining about MS's *description* of formulas for the OOXML format, though nobody has actually seen MS's actual software code implementation. If a software developer mindlessly implemented these formulas based purely on this description there might be problems, but if he had any knowledge in this area he would know what was intended or he would know to ask for better clarification.

    18. Re:So? by CastrTroy · · Score: 1

      Do you trust that a 2x4 is 2 inches by 4 inches?

      --

      Anthropic principle: We see the universe the way it is because if it were different we would not be here to see it.
    19. Re:So? by Anonymous Coward · · Score: 0

      * We trust our spell checkers to check properly

      Ewe muss bee out of your mine too thrust a spell checker.

    20. Re:So? by CrimsonAvenger · · Score: 1

      A socket may not be of the correct size: The assembly line might have malfunctioned at some point, or a worker might have been sleepy during work.

      This is certainly possible. However, when you reach for a 3/4" socket, do you also reach for a ruler at the same time to verify that the socket was the correct size? If not, then you trust that the socket is the correct size. Your trust may be misplaced, but nonetheless you have trusted.

      --

      "I do not agree with what you say, but I will defend to the death your right to say it"
    21. Re:So? by wikinerd · · Score: 1

      you trust that the socket is the correct size

      Not really, I actually just gamble.

  5. Let me be... by cosmocain · · Score: 0

    ...the first to say:

    Nothing newto see here, please move along.

    Just another product that's supposed to mature after extensive paying-user-beta-testing.

    And hey - see: This ist just the OPEN specification which is used to implement OOXML-support in third-party software. This does not in any way mean that MS itself implemented OOXML that way... hinthinthint...

  6. nCr mapped to AveDev?!! by sashang · · Score: 1

    That's crazy. According to the article someone implemented nCk as some sort of average deviation? wtf?

    1. Re:nCr mapped to AveDev?!! by Zelos · · Score: 1

      Probably another misprint. The copy of the 2007 documentation I have has loads of them: tables printed off the edge of the page, incorrect examples etc. It looks like a document prepared carelessly in a hurry.

    2. Re:nCr mapped to AveDev?!! by afaik_ianal · · Score: 1

      It's a simple misprint. Some incredible number of CS text books get qsort, and even binary search wrong. We all get over it, because we know our domain.

      We know our domain so well in fact, that we don't really need to be told that trig functions obviously work in radians.

      People converting between cups and mL? Is anyone going to care if different tools use different definitions of a cup? Oh no! Our recipe's are going to be out by a little bit! If it matters that it be accurate, why is it being specified in cups anyway?

    3. Re:nCr mapped to AveDev?!! by LiquidCoooled · · Score: 2, Interesting

      You think thats bad?

      In the MSDN documentation for .NET Compact Framework Data Providers there is a small note:

      Note This feature has been designed to be used in conjunction with a prerelease version of an anticipated successor to Microsoft Visual Studio .NET. Check the documentation accompanying the commercially released version for any updates.

      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.

      --
      liqbase :: faster than paper
    4. Re:nCr mapped to AveDev?!! by Tacvek · · Score: 1

      What it really means is that it has been updated for the Beta of the next Visual Studio .NET [next as of the time that was updated] (Was this in an MSDN released with a Visual Studio? If so then it was for the beta version of that version of Visual Studio). (I'm guessing you got it with Visual Studio .NET 2003, and the document had not been updated since the beta.)

      --
      Stylish sheet to fix many problems in Slashdot's D3: https://gist.github.com/801524
  7. Typical Microsoft... by QuietLagoon · · Score: 4, Insightful
    ... put out garbage into the marketplace, and then wait for the customers to do the quality assurance work that Microsoft should have done.

    The trouble is that the politicians standardizing on this spec will look only at its length and declare it to be good. Maybe Microsoft made the specification long with that intent in mind.

    1. Re:Typical Microsoft... by Warbothong · · Score: 1

      That might work in a software case, but software can be patched pretty easily. A standard is a set-in-stone way that things should be done. To 'patch' a standard requires a new standard (just look at the process involved in making every variation of 802.11). To avoid unneeded extra standards each one goes through a long process of theoretical uses to make sure it covers every possible application in its field, removing parts which unnecessarily duplicate the work of existing stadards, and that it does so in a general way, thus allowing unforseen future advances to integrate seamlessly into the standard, in a way that is backwards and forwards compatible (eg. HTML can embed all manner of things, but this doesn't make browsers which don't support these things crash, they just ignore them) whilst also allowing future standards to extend it in incompatible ways if needed (eg. XHTML). Then, after agreement between all of those affected has been reached, this theoretical standard is written down and released, never to be changed. People wanting to implement this standard are free to do so without any extra permissions needed than they would need without using the standard and going their own way. Thus the theoretical fantasy land where this all works is turned into a real world product used in real world situations, with real world bugs, etc. OOXML is the complete opposite to a standard. It was not heavily thought out in a theoretical sense to make it easily changeable to ensure the best possible ideas were encapsulated regardless of running code or specific implementations, instead it takes a real world application with real world bugs, real world limitations and inflexibilities, etc. which has not been reviewed and amended by anyone outside those that propose it (Microsoft had control throughout their initial standardisation procedure), it does not cover everything in its field in a general way (it even defines a limited set of borders that can be used!), it doesn't use existing standards for those areas it does not need to cover (even the DATE is specified! And the OOXML spec includes their own vector drawing system which has no reason to be there and could just as easily be the standard SVG), in itself it could simply exist as an extension to the ODF standard (if such an extension is indeed needed). The whole process has been hacked apart until only the final 2 stages are left, making it a standard then implementing it, and then those have been reversed. It would be a disgrace if it went through ISO. In a decade or so, when Microsoft is finally competing on a level playing field with some competition, such an ISO standard will still exist, with all of its incredibly legacy ideas and implementations (in 10 years time who the hell is going to implement functions "like Word 95"?), and we'll all look back and laugh at what a disgrace the system was in. Of course, we might all be looking back at ODF through the MSN Portal of Truth (the wayback machine got shut down for copyright violation) and wondering how the heck such a poorly centralised rabble of differing vendors got anybody to take them seriously without paying any implementation tax and we'd be loling to each other through our MSN phones about how people back then were all sitting on Slashdot and hurling abuse around about using firearms to take down governments without actually bothering to write a letter to their local government representative outlining the issues they felt so strongly about.

    2. Re:Typical Microsoft... by QuietLagoon · · Score: 1
      That might work in a software case, but software can be patched pretty easily.

      Not really. Software patches are a pain. How many different software programs do you have on your computer? Imagine if they all released multiple patches per year. How can you manage to assure that you have a stable system?

      Now think of the mess of using Microsoft for an external-facing server. You won't sleep or have weekends to yourself.

      by the way, you should use paragraphs in your postings. ;)

  8. Meaningless statement by Anonymous Coward · · Score: 3, Insightful

    Shame on all those who praised and continue to praise the OOXML formula specification without actually reading it.

    What percentage of those who praise ODF specifications actually read it? Or any other specification? I would imagine it is a small percentage.

  9. Surprised? by JohnFluxx · · Score: 3, Insightful

    I doubt anyone is surprised. How can you possibly fast track a 325 page document, giving the public only a time amount of time to check it, then expect it to be perfect.

    Man, I really really get annoyed at Microsoft.

    1. Re:Surprised? by TheSciBoy · · Score: 1

      It's a 6000 page specification. The 325 pages concerned are only the specifications for the formulas.

      As per usual though, Microsoft has proven that greasing enough palms will get even an international standard approved without much review. Something the medical industry has known for years.

      To quote someone (Denis Leary?): "They drove a dump truck of money up to my house, man. I'm not made of stone!"

      --
      Badgers, we don't need no stinking badgers! - UHF
    2. Re:Surprised? by ejdmoo · · Score: 1

      It's Krusty.

      Hopefully the spec will be fixed. A spec is even more easily fixed than software!

    3. Re:Surprised? by PhilHibbs · · Score: 1

      Unfortunately the spec was written to match Excel, so MS won't change the definition of Pica that Excel uses, or add calendrical localisation that Excel does not support, etc. so some things (like specifying that SIN uses radians) can be fixed but not so others.

    4. Re:Surprised? by TheRaven64 · · Score: 1

      A spec is even more easily fixed than software That's not even remotely true. Once more than one implementation of the spec is deployed, people have to try working to the new spec, but also including work-arounds for software that still uses the old version. Take a look at how well HTML 4 (let along XHTML 1) is supported for an example.
      --
      I am TheRaven on Soylent News
    5. Re:Surprised? by ejdmoo · · Score: 1

      True. At this point, there is only one implementation, however, which makes the spec easy to fix.

      Also, do we know that the spec matches the software? Or is the software wrong, too? Specs sometimes getting written after the software, and then they can be wrong (and the software can be right).

  10. I WISH it was that "good"... :-( by BerntB · · Score: 2, Informative

    Just another product that's supposed to mature after extensive paying-user-beta-testing.

    I wish it was that "good". :-(

    The OOXML spec seems to be a dump of the MS Office data formats, so it should already be decades old. But sure, let us not assume malice when stupidity will suffice as explanation. I mean, we don't speak about condemned criminal here, do we? Oh, wait...

    --
    Karma: Excellent (My Karma? I wish...:-( )
  11. Re:Confused? by Goffee71 · · Score: 2, Funny

    Microsoft to prostitution in ten posts, is that a record?

    --
    If he's the Walrus then can I be a penguin please?
  12. Proof that open formats are a good idea? by moosesocks · · Score: 5, Interesting

    I don't know about you, but I view this as being a very GOOD thing.

    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.

    --
    -- If you try to fail and succeed, which have you done? - Uli's moose
    1. Re:Proof that open formats are a good idea? by Rakshasa+Taisab · · Score: 4, Interesting

      MS pretty much seems to have cut-n-pasted their MSOffice help files and decided to call that a 'standard'. Only thing good about it, is that it will make ISO be so much less willing to ratify their standard. If you look at their CEILING definition, as linked in the article's comments, it is so unprofessionally written you'd wonder at the size of EMCA's checks.

      --
      - These characters were randomly selected.
    2. Re:Proof that open formats are a good idea? by jkrise · · Score: 1, Interesting

      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. Exactly! Imagine a Hospital implementing OOXML for it's entire IT needs, and a prescription reads: 1 tbsp Terramycin, twice daily. If a patient sues the hospital for wrong dosage, lots of red faces will be guaranteed.

      FTA:

      The CONVERT function (Part 4, Section 3.17.7.48) converts from one unit to another. Some conversions explicitly allowed include liquid measure conversions such as from liters to cups or tablespoons. But whose cup and whose tablespoon? Traditional liquid measures vary from country to country. In the US, a cup is 8oz, except for FDA labeling purposes when a cup is 240ml. But in Australia a cup is 250ml and in the UK it is 285ml. Similarly a tablespoon has various definitions. OOXML is silent on what assumptions an application should make. I guess I won't be using OOXML to store my recipes, and certainly not to calculate medical doses!
      --
      If you keep throwing chairs, one day you'll break windows....
    3. Re:Proof that open formats are a good idea? by tomstdenis · · Score: 1

      w.r.t. "convert," this is why doctors don't say "take a cup of $BLAH" they use measurements like mL/cc, mG, etc.

      Take 1/72nd of a cup of morphine!!!! STAT!!!

      --
      Someday, I'll have a real sig.
    4. Re:Proof that open formats are a good idea? by bjourne · · Score: 1, Insightful

      Sorry, but this is FUD of the worst kind and it is very unfortunate that it comes from IBM and the free software community. Every standard has omissions, most even glaring faults. You could find similar problems in virtually all specs. I'm to lazy to provide examples, but you can dig up lots of problems with even a venerable and industry proven spec like C89/90 too. So the spec doesn't specify whether trigonometry functions accept radians or degrees? That is what is called a "bug." Most likely, the OOXML spec will be revised to include those details. What makes or breaks the spec is whether it will be updated to fix its problems. In the meantime, you do what every other spec implementor since the time of dawn has done, rely on the reference implementation. Does MS Excel use radians or degrees? There is the answer.

      A buggy spec is better than no spec at all, and ODF has no information whatsoever about its formula functions. Harping down on OOXML when ODF completely omits so much information is pretty laughable. If you want to push for ODF then please don't use fallacious arguments.

    5. Re:Proof that open formats are a good idea? by Askmum · · Score: 1

      MS pretty much seems to have cut-n-pasted their MSOffice help files and decided to call that a 'standard'.
      No they haven't. Even the help files specify for each trigonomic function that the argument or return value is in radians.
      Even better: the help text on most functions provide one or two example calculations so that you can even check the input!

      MS hasn't even cut-n-pasted their MSOffice help files! They made a botch job and even managed to botch that up, and then slapped some money on the table to get it fast-tracked and approved. I can't even begin to describe how disgusted I am at this company.
    6. Re:Proof that open formats are a good idea? by Anonymous Coward · · Score: 0

      "I don't know about you, but I view this as being a very GOOD thing. 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."

      And this happened before or after the ECMA review process?

    7. Re:Proof that open formats are a good idea? by Lemmeoutada+Collecti · · Score: 1

      Pcn po 1tsp 2x dl

      Which in doctor speak translates to Penecillin, Per Ora (by mouth), 1 teaspoon, twice daily.

      Penecillin is a very reactive antibiotic, and can easily be overdosed, though not often fatally. But even a mild overdose can lead to diarrhea, vomiting, and other such unpleasantness.

      This is exactly why I always ask my doctor to specify in metric units or give me capsules, and use a dosing spoon to take the liquids.

      But most doctors prescribe in the locally familiar units, knowing the tolerances and such for dosage.

      --

      You can have it fast, accurate, or pretty. Pick any 2.
    8. Re:Proof that open formats are a good idea? by Karellen · · Score: 3, Insightful

      Oh, I definitely agree that open formats are a good idea, and that this does show one very good reason why.

      But, the point is that MOOXML is a shitty open format. It was written in a closed environment, without a decent review by anyone, in 1/20th the time you'd expect a spec of that size to take, and is being put on a "fast-track" process to ISO which means - if it goes through - it will never have had a proper review by anyone.

      Yes, having the format be open is a good thing.

      But this format is utter crap, on many different levels. It's size, complexity, inconsistency, bugginess, NIH-iness, reliance on Win32, etc., etc., etc.... make it completely unsuitable to be ratified as an ISO standard.

      When you're turning something into an international standard, you want to take your time and get it right. That's what the standardisation process should be about. Creating something usable by as many parties as possible. MOOXML fails completely here.

      Yes, I'm in favour of them opening their document formats. I wish they'd release updated documentation for the binary .doc format as well, usable by anyone (last I checked there was a "you must agree not to use this information to create products that compete with office" clause in the (outdated) documentation download) so that people could interoperate with those formats on non-Windows platforms. But do I wish for the binary .doc format to be an international standard? Hell no!

      --
      Why doesn't the gene pool have a life guard?
    9. Re:Proof that open formats are a good idea? by mikeb · · Score: 2, Interesting

      "You could find similar problems in virtually all specs" Well I would like to see your evidence of that! Having worked on the the original C standard extensively and done a fair bit of work on the C++ standard, I find it rather annoying that an unsubstantiated statement like this is trotted out.

      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.
    10. Re:Proof that open formats are a good idea? by Xiaran · · Score: 1

      Id like to whole heartly back you up on your post on behalf of my father. Tho Ive never done any work on an ISO standard I know the amount of work that is involved. My dad worked on several ISO standards but particularly the X.500 standard. The amount of time(and in those days paper... no email) spent on getting a good spec is enormous and most people dont seem to realise it. Through on top of that intergovernmental and intercompany arguments and its often a wonder any ISO standards are approved at all.

    11. Re:Proof that open formats are a good idea? by tomstdenis · · Score: 1

      um I've never been prescribed anything that was that sensitive to measurements that wasn't in pill form. When I had pneumonia they'd give me the banana flavoured antibiotic, but a few mL eitherway won't kill you. and table spoons don't generally vary that much in volume. But when I was given stronger meds for sinus pressure it was in pill form and well measured. Because a few mg either way could cause problems.

      At a hospital with an IV they would measure out a syringe and add it to your drip, so there are no spoons involved...

      Tom

      --
      Someday, I'll have a real sig.
    12. Re:Proof that open formats are a good idea? by Anonymous Coward · · Score: 0

      No, this is not a good thing.
      At least some of these errors have been out in the open in the implementation of MS Excel for over ten years and have not been fixed.
      What makes you think MS is going to fix them now?
      Instead, we're going to get a "standard" that codifies these mistakes.

    13. Re:Proof that open formats are a good idea? by the_greywolf · · Score: 1

      At a hospital with an IV they would measure out a syringe and add it to your drip, so there are no spoons involved...

      Imagine if they used Excel to calculate what goes into that syringe.

      --
      grey wolf
      LET FORTRAN DIE!
    14. Re:Proof that open formats are a good idea? by bjourne · · Score: 2, Interesting

      Well I would like to see your evidence of that! Having worked on the the original C standard extensively and done a fair bit of work on the C++ standard, I find it rather annoying that an unsubstantiated statement like this is trotted out.

      If you have been involved in drafting the C standard then you should be aware of the list of defect reports. 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.

    15. Re:Proof that open formats are a good idea? by mikeb · · Score: 2, Interesting

      At face value, the list of defect reports might be assumed by a naive reader to suggest that the C standard is full of holes and would metaphorically never float. In fact on rereading it, I think that in the main it supports my point :)

      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' .. my track record in involvement in the ANSI standard for C is well known for those who care to look. For those who don't, ISBN 978-0201544336 and http://publications.gbdirect.co.uk/c_book/ may assist.

      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?

    16. Re:Proof that open formats are a good idea? by John+Meacham · · Score: 1

      We should not take chances with such things, software bugs can be quite deadly.

      http://en.wikipedia.org/wiki/Therac-25

      --
      http://notanumber.net/
  13. Congress as role-model? by JonTurner · · Score: 5, Funny

    >>How can you possibly fast track a 325 page document, giving the public only a time amount of time to check it, then expect it to be perfect.

    Damned if we know.
    Signed,
    The US Congress

    1. Re:Congress as role-model? by $RANDOMLUSER · · Score: 1

      Brilliant. Sad but true.

      --
      No folly is more costly than the folly of intolerant idealism. - Winston Churchill
    2. Re:Congress as role-model? by necrogram · · Score: 1

      Well as my best friend likes to put it, "you can only get two of three: Fast, Cheap, Right"

  14. Just want to point out... by Anonymous Coward · · Score: 2, Informative

    The trig functions take arguements in radians, and the arctrig functions return radians. This doesn't ever need to be said - it's goddamn assumed by anyone who knows what they are doing. Unless degrees are specifically mentioned, you always assume it's radians. ALWAYS. I might as well complain that when I press the pi button on my calculator it outputs a number but doesnt specify whether it's in base10 or something else...

    If someone thinks that these functions even MIGHT work with degrees, than they should NOT be implementing them for anything that might cause the "loss of life, property, and capital". Leave the important stuff like that to professionals.

    1. Re:Just want to point out... by pytheron · · Score: 1

      This doesn't ever need to be said - it's goddamn assumed by anyone who knows what they are doing And it is also assumed that that that the end implementation made the same assumption as you. These assumptions start to rely on one another and stack up quick !
      To quote :- "and what do they say about assumption being the brother of all fuckups ?"
      --
      "I am not bound to please thee with my answers" [William Shakespeare]
    2. Re:Just want to point out... by Anonymous Coward · · Score: 0

      I might as well complain that when I press the pi button on my calculator it outputs a number but doesnt specify whether it's in base10 or something else...

      I would hope it is in whatever base the calculator currently is using, and NOT in base 10 (unless of course base 10 is currently used).

      In other words, it's not specified what base pi is in because pi doesn't care about base. It's just another number.

    3. Re:Just want to point out... by Xab · · Score: 1

      Hi, while I get your point, I would like to state that we are talking here about a normative context (ISO) where such assumptions, even the more common sense-driven, are not welcome, to say the least.
      It is the aim of a standard to be as precise and ambiguity-free as possible and certainly mentioning units is no big effort nor big cost.
      You mention professionals at the end of your comment. Such properly-assuming individuals actually also care to have good standards.
      Xavier

    4. Re:Just want to point out... by Xiaran · · Score: 3, Insightful

      The problem is that we are talking about a proposed international standard and you are using the phrase "it's goddamn assumed by anyone...". There should ideally be *no* assumptions in a stadard... it needs to be as clear and accurate as humanly possible. Remember that once a standard is published it is translated into many laguages and possibly implemented in different cultures as mentioned in TFA. What you assume to be obvious may or may not be obvious to others.

    5. Re:Just want to point out... by Anonymous Coward · · Score: 0

      I agree the standard should be precise.

      I was more pointing out the stupidity of the whole "loss of life, property, and capital" FUD in the article. Anyone implementing these functions in a situation where life, property or capital is at stake will already know to use radians. If they don't, then they are likely unqualified to do what they are doing, and no amount of precision in the standard will help them.

    6. Re:Just want to point out... by Anonymous Coward · · Score: 0

      My friend you are utterly wrong. You are greatly overestimating the human nature. I have personally be present in various situations where idiots with too much power have made mistakes, and later blamed people below themselves in the power chain.
      Excel has a godlike reputation with people in power. They use it religiously (and trust it with the lives of others). You cannot begin to comprehend how many people have been affected by Excel's capriciousness. "Surely people will not use something unreliable in situations like these" is naiveness in its extreme.
      The real world does not work in an ideal way, you know.

    7. Re:Just want to point out... by sid0 · · Score: 1

      Very true. If you say that sin(90) = 1, YOU'RE WRONG. You have to say sin(90 degrees) = 1. Mathematics, and the radian concept, is universal.

    8. Re:Just want to point out... by clickety6 · · Score: 1

      Logo Programming Langauge

      FORWARD 100
      LEFT 90
      FORWARD 100
      LEFT 90
      FORWARD 100
      LEFT 90
      FORWARD 100
      LEFT 90

      This draws a square.
      What does that tell you about the units of the angles ?

      --
      ----------------------------------- My Other Sig Is Hilarious -----------------------------------
    9. Re:Just want to point out... by sqlrob · · Score: 1

      Someone implementing the standards probably wouldn't be in that position.

      Someone using software implemented the standards will be. So you can't use "verified against standard X" for any level of confidence in the results. So why even bother with a standard?

    10. Re:Just want to point out... by Anonymous Coward · · Score: 0

      I assume you meant "... mother of all ..."

    11. Re:Just want to point out... by Anonymous Coward · · Score: 0

      lock, stock and two smoking barrels.

      "mother, brother.. or any other sucker.."

  15. And proof that single-ownership is bad by Anonymous Coward · · Score: 4, Interesting

    Now that MS are the only ones who are allowed to change the standard, we must

    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?

    1. Re:And proof that single-ownership is bad by ray-auch · · Score: 1
      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?


      Well, we could look at ODF to see. Take one problem, from the article:

      First, let's take the trigonometric functions, SIN (Part 4, Section 3.17.7.287), COS (Part 4, Section 3.17.7.50) and TAN (Part 4, Section 3.17.7.313). Hard to mess these up right? Well, what if you fail to state whether their arguments are angle expressed as radians or degrees? Whoops


      So where is this specified in ODF then ?

      Oh, it isn't. Hence the existence of OpenFormula (and maybe other projects) to fix the deficiency.

      So, did ODF avoided this problem ? No - ODF still got right through to approval whilst still having this exact same problem as OOXML.

      AFAICS, two ODF1.1 compliant spreadsheets could implement Sin() differently (eg. degrees vs. radians) and still be completely compliant with the standard.

      "Whoops".
  16. Let's not get ahead of ourselves... by iamdrscience · · Score: 1

    It has incorrect formulas that, if implemented according to the standard, may cause loss of life, property, and capital
    Surely this is a Bad Thing, but if you're put in the situation where you're trusted with peoples' lives, you shouldn't let them depend on a single spreadsheet anyways.

    Capital and property I can see, but until stories start popping up about people dying because of spreadsheet errors, let's tone down the hyperbole, alright?
    1. Re:Let's not get ahead of ourselves... by TheReaperD · · Score: 1

      Well, not quite REAL deaths, but still 80,000 dead...

      [quote]
      The error that the CDC has "admitted" is a calculation error in the spreadsheet that was used to come up with the 400,000 obesity death estimate. They referenced the wrong cell in the spreadheet. When this mechanical error was fixed, the death estimate dropped by 80,000.
      [/quote]

      Original article: http://www.ucsf.edu/its/listserv/stanglantz-l/0351 .html

      --
      "Be particularly skeptical when presented with evidence confirming what you already believe." -
    2. Re:Let's not get ahead of ourselves... by Anonymous+Cowpat · · Score: 1

      you own some property which is rented by someone else. Next January a spreadsheet error causes you to lose that property (don't ask how). The new owner of the property kicks your tenants out. They no longer have anywhere to live and die of exposure the next night.

      You run a charity which provides food to homeless people. A spreadsheet error makes you believe that your budget is only 10% of what it was last year. You drastically cut back your work. Someone dies of starvation.

      Life can still be lost indirectly through loss of property or capital, not just if you're using a spreadsheet to calculate the safe loading weight of a rollercoaster.

      --
      FGD 135
    3. Re:Let's not get ahead of ourselves... by CmdrGravy · · Score: 2, Funny

      A simple spreadsheet error in the zoo transportation department commands them to mail a large crocodile to a balcony at the top of a large block of flats. A party of innocent children are walking down the road under the balcony and are all hit and killed by a large falling crocodile.

      The Israeli kidnap and asassination department are looking through their targets spreadsheet where a simple spreadsheet error has flagged your address at the top of their list. Next day you are kidnapped, tortured and killed.

      A simple spreadsheet error in the town planning department lead them to construct an large and elaborate new drain system underneath your house down which your house, your wife and all your belongings are sucked never to be seen again.

  17. Yeah, I'm sure this guy is objective by WalterGR · · Score: 2, Insightful

    Who is the author, Rob Weir?

    I work for IBM, as a performance architect, as well as on various ODF technical topics. (source)

    So a guy working on a different document format, for a company who competes with Microsoft, has unkind words? Color me shocked.

    OOXML defines spreadsheet formulas, and ODF doesn't. The Microsoft boosters have been parroting the party line for quite some time.

    Uh... ODF doesn't define spreadsheet formats. There's no standard for spreadsheets in ODF. How is that "parroting the party line?"

    1. Re:Yeah, I'm sure this guy is objective by january05 · · Score: 5, Insightful

      ODF will define spreadsheet formulas, in the next version. And come on, the "IBM conspiracy" take from MS is really lame since OOXML is the one with proprietary patented extensions. I'll take any open standards company I can get, personally.

    2. Re:Yeah, I'm sure this guy is objective by january05 · · Score: 1

      Further, MS didn't accept significant changes when they pushed it through ECMA. Now that they're *Fast-tracking* it through ISO, how exactly how are they going to make changes to the hundreds of contradictions already found when they haven't already changed anything? The vote is set for August, I believe.

    3. Re:Yeah, I'm sure this guy is objective by topham · · Score: 3, Interesting

      Parroting the party line is promoting the fact that it has formulas as showing it is superior to ODF when the formula specification is next to useless because it wasn't reviewed properly.
      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.

    4. Re:Yeah, I'm sure this guy is objective by Bert64 · · Score: 1

      ODF references an external spec for formulas, IE the "OpenFormula" spec, which is also available from oasis-open.org
      Just like it references some other open specs for other parts, it makes no sense to reinvent the wheel.

      --
      http://spamdecoy.net - free throwaway anonymous email - avoid spam!
    5. Re:Yeah, I'm sure this guy is objective by jkrise · · Score: 2, Insightful

      So a guy working on a different document format, for a company who competes with Microsoft, has unkind words? Color me shocked. A competitor has a vested interest in exposing short-comings of his competition. So an IBM employee is the best critic of a competing Microsoft product. Why is this hard to understand? Why not criticise the views expressed, rather than the person he is OR his employers?

      As for spreadsheet formats not being defined in ODF - it isn't a big deal, and the alliance seem to be working on the issue, in any case. A wrong formula is infinitely worse than No Formula.

      I wonder what your vested interest is... your lack of a meaningful response and indulging in mud-slinging appears very deceptive, and your motives - suspect.

      --
      If you keep throwing chairs, one day you'll break windows....
    6. Re:Yeah, I'm sure this guy is objective by WalterGR · · Score: 2, Insightful

      I wonder what your vested interest is... your lack of a meaningful response and indulging in mud-slinging appears very deceptive, and your motives - suspect.

      I'm a Microsoft shill. They pay me a ton of money to post on /. because they know that maybe - just maybe - all it will take is one more post in their favor to convert the unfaithful.

      Seriously? Come on dude. This entire story is more-of-the-same get-the-crowd-riled-up /. click-fodder. But if you want to make a show of it...

      So an IBM employee is the best critic of a competing Microsoft product. Why is this hard to understand?

      My post pointed out that the guy isn't objective. Then it proceeded to give an example of using the pejorative "parroting the party line" for merely stating a fact. That's it.

      As for spreadsheet formats not being defined in ODF - it isn't a big deal, and the alliance seem to be working on the issue, in any case.

      A lack of spreadsheet formats is a big deal if, for example, you want to create a spreadsheet.

      I prefer to comment on stories and not my rhetorical technique, so I won't be watching for responses to this post. If you'd like to discuss it further, feel free to e-mail me at waltergr@aol.com.

    7. Re:Yeah, I'm sure this guy is objective by LingNoi · · Score: 1

      I prefer to comment on stories and not my rhetorical technique, so I won't be watching for responses to this post. If you'd like to discuss it further, feel free to e-mail me at waltergr@aol.com.
      Oh man I don't know what is worse...

      1) You gave up on your argument because you know you were wrong
      2) You think OOXML is well.. an open format.. *pssthaha*
      3) You use AOL

      the horror...
  18. Surely we all saw this coming by bersl2 · · Score: 2, Interesting

    While I think that the "loss of life, etc." part is a bit overboard, since nobody builds a mission-critical system on top of Excel (or do they...), I do think that the criticism is appropriate.

    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.

    1. Re:Surely we all saw this coming by Anonymous Coward · · Score: 0

      If you'd look around, you would find that people DO build "mission critical" stuff on top of Excel. I don't know if people have actually gotten killed because of Excel, but there are many cases where companies and people have lost a lot of money over Excel. Most of the time it's dumb user using wrong tool to do wrong things, and failing at it, so MS is pretty much immune.

      Smart people don't use it for anything critical, but world is full of dumb people. MS is happy to provide them the tools to do dumb things, as that is proven to generate tons of revenue for them.

    2. Re:Surely we all saw this coming by RuBLed · · Score: 2, Informative

      My dear friend, I am quite sure that at the very least, you are not a reader of http://worsethanfailure.com/ There's still hope and time for those who are yet to be welcomed to the fold. My friend, read and be enlightened...

    3. Re:Surely we all saw this coming by simong · · Score: 4, Informative

      Depends what you call mission critical. Excel was used in voting systems in the Scottish and local elections in the UK this year, and Diebold's GEMS system uses Access as a database. High tech indeed.

    4. Re:Surely we all saw this coming by yanagasawa · · Score: 1

      It may not be "loss of life", but multi-million dollar financial decisions are made every day based on the results of complex excel spreadsheets. I consider this mission-critical as would anyone with a stake in those decisions.

    5. Re:Surely we all saw this coming by Askmum · · Score: 1

      Groklaw had a good overview, way back in January:
      http://www.groklaw.net/article.php?story=200701230 71154671

    6. Re:Surely we all saw this coming by Anonymous Coward · · Score: 0

      Didn't NASA use Excel spreadsheets to predict the damage to the thermal tiles prior to and during Columbia's last mission? Their spreadsheets indicated that the minor amount of ice would not cause damage to the orbiter.... The rest is history.

    7. Re:Surely we all saw this coming by spune · · Score: 1

      State and local governments rely on Excel for financial management nationwide. I work in a financial unit of my state's department of child services, and if our Excel sheets were to calculate incorrectly there could be extremely inconvenient problems that could result in deaths through neglect.

    8. Re:Surely we all saw this coming by Macthorpe · · Score: 1
      No. In fact, you made that whole thing up.

      NASA scientists determined that a hole was punctured in the leading edge on one of Columbia's wings, made of a carbon-carbon composite. The hole had formed when a piece of insulating foam from the external fuel tank peeled off during the launch 16 days earlier, puncturing the edge of the wing. Hot gases, inaccurately described in initial reports as plasma, penetrated the interior of the wing, destroying the support structure and causing the rest of the shuttle to break apart during the intense heat of re-entry.
      --
      "It does not do to leave a live dragon out of your calculations, if you live near him." - Tolkien
    9. Re:Surely we all saw this coming by RAMMS+EIN · · Score: 1

      ``nobody builds a mission-critical system on top of Excel (or do they...)''

      A few weeks ago, I talked to a guy who works on systems that monitor patients in hospitals. According to what he told me, most of these systems are built around MS Access "databases".

      --
      Please correct me if I got my facts wrong.
    10. Re:Surely we all saw this coming by 6031769 · · Score: 1

      Excel was used in voting systems in the Scottish and local elections in the UK this year Look how well that went. This really is one of the scariest things about having non-technical people decide on a technological solution. I doubt they will even learn once there has been a directly attributable fatality.
      --
      Burns: We're building a casino!
      McAllister: Arrr. Give me 5 minutes.
    11. Re:Surely we all saw this coming by omz · · Score: 1

      Anybody keeping a comprehensive and up-to-date list (or list of lists) of specific things that are wrong with OOXML?

      Here you have one

      Other links:

      • BSI ( UK ISO's national body member ) expert panel wiki
      • file "v1 comments.zip" with 77 pages of comments ( 60 of them technical, general and editorial problems throughout OOXML ) partially reviewed by the USA panel ( most of them MS partners sended by MS, so don't expect a "deep" review there ) [note: this is an email attachment, open it with Thunderbird ]
  19. ODF doesn't even have a formula standard. by eggz128 · · Score: 1

    Yet, at any rate. IIRC it's a work in progress.

    http://wiki.oasis-open.org/office/About_OpenFormul a

    1. Re:ODF doesn't even have a formula standard. by bersl2 · · Score: 1
  20. Not a good thing, because it is not a free format. by master_p · · Score: 2, Insightful

    It may be open, but it is not free, i.e. the required changes can not be done by third parties or by a committee and then used by Microsoft. Microsoft wouldn't do anything that would hurt its embrace and extend business model, and OOXML follows that logic as well(it's so huge and flawed that no one dares using it).

  21. Deeply Flawed Spreadsheet Formulas? by phalse+phace · · Score: 2, Funny

    Billg: "That's the dumbest fucking idea I've heard since I've been at Microsoft."

  22. Heh... by nowhere.elysium · · Score: 1
    This almost reads like an old-school Mac evangelist taking FUD to the next level, doesn't it?*

    "...if implemented according to the standard, may cause loss of life, property, and capital..." OMGZ0RZ!!one!!eleventy!ROFL! MiCr0$0fT W1Ll PwN j00!

    Seriously though: If this OOXML system has so many holes in it, why haven't they just adapted the already-written Excel software that they have? Microsoft doesn't have the best track record when it comes to writing new stuff: if anything, they're famous for keeping legacy code, no? I'm just wondering why this isn't the procedure they're applying here, is all.

    *Disclaimer: I am not anti-Mac - I work as a Mac sysadmin. Just couldn't think of a better analogy.
    --
    http://xkcd.com/313/
    1. Re:Heh... by Aim+Here · · Score: 1

      "Seriously though: If this OOXML system has so many holes in it, why haven't they just adapted the already-written Excel software that they have?"

      Err, what makes you think the OOXML spec isn't just a backhand way of "documenting" whatever Microsoft Office does anyways? Some of the tags are dead giveaways: "autoSpaceLikeWord95", "useWord97LineBreakRules", "useWord2002TableStyleRules".

      The spec often refers to what various versions of Office do, without stating what that is. Probably much the same way that when reading Word 95 documents, Word 2008 will no doubt just ask some legacy DLL that the installer threw into c:\windows\system32...

    2. Re:Heh... by nowhere.elysium · · Score: 1

      Sorry - did you think that I'd actually RTFA? I was aiming for a throwaway smartarse comment, not anything insightful. I haven't had nearly enough sleep to be insightful.

      --
      http://xkcd.com/313/
  23. I never understand why people complain so much by pembo13 · · Score: 3, Insightful

    Let MS do exactly what they want, they seem quite successful at it, if it bites them in the butt, so be it. I would just like our own software freedoms to be preserved. I have no intention on producing anything with their format, I'm sure I'll eventually have to read it, but the chances that the receiver of a document is liable for inaccurate content within that document seems very low.

    What is the motivation, since I'm sure there must be a good one, to do this free work for MS?

    --
    "Thanks for all the money you paid to us. We've used it to buy off ISO among other things" -Microsoft
    1. Re:I never understand why people complain so much by m50d · · Score: 1

      To point out that while this may seem like a standardised format that anyone can use, in fact the standard is so useless that no-one but MS can handle the format, so that governments/etc. who want to standardise on an open format don't choose this one under the misapprehension that it's such a thing. Which matters if you want to be able to read the documents your government puts out.

      --
      I am trolling
    2. Re:I never understand why people complain so much by Anonymous Coward · · Score: 0

      the chances that the receiver of a document is liable for inaccurate content within that document seems very low.

      Apparently you've never dealt with the US Government.

  24. Implied warranty - fit for the purpose by QuestorTapes · · Score: 5, Interesting

    > ...in general:
    >
    > * 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_ 06.asp

    http://www.brajeshwar.com/finance/insurance/Liabil ity-Insurance.html

    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.

    1. Re:Implied warranty - fit for the purpose by Lockejaw · · Score: 1

      I can't remember buying software and not seeing "no warranty, express or implied" in the EULA. A ruling about waiving implied warranty (the concept also exists in the U.S.) would be really nice.

      --
      (IANAL)
    2. Re:Implied warranty - fit for the purpose by tinkerghost · · Score: 1

      The EULA doesn't apply until AFTER THE SALE. During the sale there is a legal requirement of Merchantablity. If a product is advertised for a purpose and sold as suitable for that purpose, then you have a minimum of deceptive advertising if it's knowingly not suitable for that purpose.

      AIUI, if this ever goes to a full court case in England, they would have to show that their software is for 'Entertainment value only'. Failing that, they would have to take responsibility for merchantablity or stop selling the product & issue a recall.

      Now, do you think that MS is going to rebrand Windows & Office as 'Entertainment Software'? How about stop selling everything but the Xbox & ZUNE? I see huge sums of money changing hands long before this ever gets near a judment.

    3. Re:Implied warranty - fit for the purpose by QuestorTapes · · Score: 1

      Yes, software manufacturers have so far gotten away with that. For most physical products, you can put a similar statement on the item, but unless you are selling a specifically discounted, reused, or remaindered item at a significant discount, you can't dodge the basic warranty of fitness.

      Thanks for your comments.

  25. The Dead by antonyb · · Score: 1

    According to Rob Weir's blog, Microsoft's 325-page OOXML specification for spreadsheet formulas is deeply flawed. So that's what the boys from the Grateful Dead are up to these days.... ant.
  26. Microsoft can't code by BillGatesLoveChild · · Score: 4, Interesting

    > From basic trigonometric functions that forget to specify units

    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!*

    1. Re:Microsoft can't code by sid0 · · Score: 1

      Name me one programming language that does not take trigonometric angles in radians.

    2. Re:Microsoft can't code by jkrise · · Score: 1

      Name me one programming language that does not take trigonometric angles in radians.

      That's the second time you're spouting this argument. We are not talking about a programming language, we are talking about a Document standard - see the difference?

      Name one math textbook which does not represent angles in degrees, specially wrt sin, cos and tan. It's always been in degrees, so your argument is pointless.

      --
      If you keep throwing chairs, one day you'll break windows....
    3. Re:Microsoft can't code by sid0 · · Score: 1

      My old 11th and 12th grade book. Almost every angle in the book is given in radians, and wherever the angle is mentioned in degrees the degree sign is given. A quiz in the book even has the old question: Which is bigger, sin(1) or sin(1 degree)? A full page mentions why when the unit of the angle is not mentioned, it is in radians. Essentially radians are dimensionless numbers.

    4. Re:Microsoft can't code by clickety6 · · Score: 2, Informative

      LOGO

      Example 1: a square

      FORWARD 100
      LEFT 90
      FORWARD 100
      LEFT 90
      FORWARD 100
      LEFT 90
      FORWARD 100
      LEFT 90

      --
      ----------------------------------- My Other Sig Is Hilarious -----------------------------------
    5. Re:Microsoft can't code by Alioth · · Score: 1

      It's utterly irrelevant whether programming languages use radians or not for trig functions - a standards document should leave nothing to assumption, and should specify. Even the humble Unix manpage specifies that the trig functions use radians, rather than have the programmer just assume that's so - as the very first thing in the description!


      SIN(P)

      NAME
                    sin, sinf, sinl - sine function

      SYNOPSIS
                    #include <math.h>

                    double sin(double x);
                    float sinf(float x);
                    long double sinl(long double x);

      DESCRIPTION
                    These functions shall compute the sine of their argument x, measured in radians. ...

    6. Re:Microsoft can't code by Anonymous Coward · · Score: 0

      The flaw in your logic is that the programmers are certainly not writing these specifications. Microsoft employs technical documenters who's job it is to write up these specs.

      In the help files for Excel 2007 Microsoft did explicitly mention the units for those trignometric functions as accepting and returning values in radians. They even go on to explain how they can convert from degrees to radians and back as well as providing several examples to demonstrate how to call the function in this way. Perhaps one group of technical documenters didn't talk to another group.

      That said, at least OOXML has specs for formulas. ODF doesn't have any specification for formulas at all, so it's effectively open season.

    7. Re:Microsoft can't code by MooUK · · Score: 1

      As you just said yourself: it had an entire PAGE saying that angles were in radians and why.

      If your maths textbook felt it needed pointing out, why should a standard - which should be pointing out every single thing possible - not state it?

    8. Re:Microsoft can't code by DevStar · · Score: 1

      EVERY math textbook I have (that I can recall), represents angles as radians. The one I happen to have on my desk is, PDEs for Scientists and Engineers by Farlow -- and this is an introductory shallow text (although very good), not some hardcore geek text.

      I haven't seen degrees used since about 7th grade -- seriously.

    9. Re:Microsoft can't code by jpbelang · · Score: 1

      > Even for the Windows API, the code trumped the documentation.

      The code always trumps the documentation, because nobody runs the documentation :-)

      --
      JP http://www.wearerite.com
    10. Re:Microsoft can't code by jrumney · · Score: 1

      Until recently DirectX needed three pages of goobleydo-gook to start up. These people just don't get APIs, period.

      Looking at things like DirectX, COM, etc, I think one thing that Microsoft do "get", is how lucrative training is. Without a course or two, you're completely lost trying to start out with most Microsoft technologies unless you stick with the boilerplate MFC code that VC++ generates for you and never try to do anything interesting.

      .NET seems to break that mold though, so maybe they see a threat somewhere - definitely not from the J2EE crowd, which is just as bad, but maybe from other things like ruby, python or some of the simpler Java APIs.

    11. Re:Microsoft can't code by Vexorian · · Score: 1

      Thanks for an utter dumb comment.

      Figure this out, common people use degrees, not radians, we got those little angle-measuring-devices-I-dont-know-how-they-call- them-in-english that use degrees, not radians, (note that using radians there would be franctly retarded considering the amount of decimals they would need).

      --

      Copyright infringement is "piracy" in the same way DRM is "consumer rape"
    12. Re:Microsoft can't code by Seraphim_72 · · Score: 1

      Take a deep breath and read your second sentence again. We are talking about Accountants, Managers, Secretaries, and others. To them, yes Farlow's book is a hardcore geek text. And to be honest, what kind of hardcore geek is using excel to make mission critical decisions about things like this anyway?

      Sera

      --
      Slashdot, where armchair scientists get shouted down and armchair theologians get modded up.
    13. Re:Microsoft can't code by Anonymous Coward · · Score: 0

      Postscript

    14. Re:Microsoft can't code by TheSciBoy · · Score: 1

      Seriously, I don't think that Microsoft writes these API's to be difficult. It is just impossible to produce good code with too many programmers. Once the size of a development team rises above 10, you stop having productive meetings and you have to divide the development into teams. Without one brilliant architect with the ability to hold the whole system in his head, there will never be one coherent vision in the software and the software will suck.

      That's why guys like Torvalds and whatshisname who made Delphi and now the C# object libraries make the big bucks. They're able to hold the whole system in their heads and can therefore drive their design home. Of course, this is only possible if the management recognize the need to pay for the rewriting of all those headstrong coders own visions of what the software should be.

      Software development can never be a democracy, it's a dictatorship and the trick is finding a good dictator. :) Of course, a good dictator has some trusted advisors, but ultimately he makes the decisions.

      P.S. I'm not a software dictator, but as a developer I've seen so many projects go down the toilet because of the lack of effective management by a headstrong software architect. Also, of course neither the two guys mentioned have every aspect of the system in their head, but they have the shape of it clear. They are also technologically knowledgable enough to see faults and how to fix them. Believe me, the software industry software giants all have this problem: too many developers and not enough software architects with the mandate to drive home their ideas. If there are any proper architects they're hogtied by demands for prompt software deliveries (without quality) and/or rediculous feature sets.

      --
      Badgers, we don't need no stinking badgers! - UHF
    15. Re:Microsoft can't code by Kazoo+the+Clown · · Score: 1

      Name me one programming language that does not take trigonometric angles in radians.

      Logo

    16. Re:Microsoft can't code by Anonymous Coward · · Score: 0
      I'm sure this will shock you, but word sizes in modern computers are multiples of eight bits, instead of the 6-9 bits of earlier computers. I'm sure that you will argue that this should be explictly stated in every standards document because computer architecture textbooks needed to point it out.

      If the text format is relevant as it is here, then yes. In this case the document is encoded in Unicode (any of the many Unicode encodings). Anything the implements the standard needs to automatically determine the encoding.

  27. TFA money quote by 12WTF$ · · Score: 1

    Microsoft seems especially proud of their work in this area, delusions of adequacy which seem unwarranted.
    --
    Cryonics - Keep cool and carry on.
  28. no units ... by Anonymous Coward · · Score: 2, Insightful

    From basic trigonometric functions that forget to specify units/i?

    Trignometric functions are unitless to begin with. They are ratios.

    1. Re:no units ... by Anonymous Coward · · Score: 0

      Trignometric functions are unitless to begin with. They are ratios.

      Ratios are not unitless, they are dimensionless. The ratio is the
      arc to side length (radians), and degrees units are a constant number
      of radians.

      Baby maths.

    2. Re:no units ... by bakes · · Score: 1


      The results are unitless. The parameters are not.

      --
      Ho! Haha! Guard! Turn! Parry! Dodge! Spin! Ha! Thrust!
  29. Ok, but... by hummassa · · Score: 1, Insightful
    TFA is not really impartial. Let's quote some:

    First, let's take the trigonometric functions, SIN (Part 4, Section 3.17.7.287), COS (Part 4, Section 3.17.7.50) and TAN (Part 4, Section 3.17.7.313). Hard to mess these up right? Well, what if you fail to state whether their arguments are angle expressed as radians or degrees? Whoops. Hmmm.
    Someone failed the math class where they explained that an angle is a "dimensionless derived unit" . Explaining, short version for the clicky-impaired: angles are the ratio between two measurements of length -- the length of an arc and the radius of said arc.
    It got off to a bad start. For the rest of it, it moans about bad revision and wrong formulas, with some reason, but without a lot of substance.
    I am pro-ODF, but this article is worthless.
    --
    It's better to be the foot on the boot than the face on the pavement. ~~ tkx Kadin2048
    1. Re:Ok, but... by jkrise · · Score: 4, Insightful

      Someone failed the math class where they explained that an angle is a "dimensionless derived unit" . Explaining, short version for the clicky-impaired: angles are the ratio between two measurements of length -- the length of an arc and the radius of said arc.
      It got off to a bad start. Technically that may be correct, but in reality, it is very common and practical to express angles in degrees. So, sin(30) = 0.5 and tan(90) = 1. Memorising the values of sin, cos and tan for 0, 30, 45, 60 and 90 degrees is a de-facto requirement to solve trig. problems in high school. Does Microsoft expect students to relearn all these convenient derievd units in radians, and go mad?

      A document standard is a practical necessity to express everyday ideas in a readable format. Not to be technically accurate and practically useless. Try typing HCl + NaOH --> NaCl + H2O in Office, and watch yourself breaking the monitor.

      --
      If you keep throwing chairs, one day you'll break windows....
    2. Re:Ok, but... by moranar · · Score: 1

      A little experiment for you:
      Take a scientific calculator
      input the expression "cos (2*PI)" (or the nearest equivalent syntax). Now press Exe, or =, or the equivalent. Which result did you get, 0.99399 or 1?

      Now, let's try again. This time, try "sin (PI/2)": is the result 0.0274 or 1?

      Now, having ascertained that dimensionless units, derived from something else or not, can indeed vary, and that your affirmations were meaningless, you can take your arrogance and shove it.

      --
      "I think it would be a good idea!"
      Gandhi, about Internet Security
    3. Re:Ok, but... by itlurksbeneath · · Score: 3, Insightful

      Dimensionless or not, in the real world (i.e. not in math class - and you really have to pick one way in math class, too), you have to pick one system of representing it and use that to send to your functions (see sin() as an example).

      That Wikipedia page you referred to us using the derived unit of "radians". There are a couple of different ways to represent that number - degrees, radians, grads. Hell, anybody that's ever used a calculator knows you have to use just one of those systems for your particular calculator.

      Nice try, but do a little more research before posting and blasting somebody's article with illogical arguments.

      --
      Have you ever considered piracy? You'd make a wonderful Dread Pirate Roberts.
    4. Re:Ok, but... by ericrost · · Score: 1

      Yes and that "dimensionless derived unit" that is the ratio between an arc and the radius of the arc is a radian. Another commonly used expression of angle is the degree.

      In most proper mathematical contexts, angles SHOULD be expressed in radians, but in a standard where there are multiple ways of expressing a value, the assumed units need to be specified. (See NASA misses mars because of cm vs inches)

    5. Re:Ok, but... by diskis · · Score: 1

      You fail math. Angles are indeed dimensionless. But someone says an angle is 90, it can be interpreted in two ways.
      The regular 90 degree right angle. Or a bit over 14 complete revolutions + some odd degrees, if we were talking about radians.

    6. Re:Ok, but... by Anonymous Coward · · Score: 0

      they explained that an angle is a "dimensionless derived unit" The radian, which is derived as you stated, is dimensionless, but there are multiple ways of measuring angles not all of which are radians or derived. Specificaions calling for an "angle" (especially those created in the non-SI US) must specify which method of angle measurement they are referring to.
    7. Re:Ok, but... by Anonymous Coward · · Score: 0

      Seriously, how did the parent get modded insightful? The status quo might be for the students to learn trigonometry using angles expressed in degrees - that doesn't mean its a good idea. As the GP mentioned, angles (as expressed in radians) are the ratio of a length of arc and the radius of the circle that contains said arc. In my opinion (and most mathematicians will agree with me), this makes radians the most natural representation of angles. Don't you want your children learning the most natural way of doing something? In fact, once those kids graduate to Calculus they'll find all the work they did with trigonometric functions using degrees pretty useless.

    8. Re:Ok, but... by theuedimaster · · Score: 1

      "Memorising the values of sin, cos and tan for 0, 30, 45, 60 and 90 degrees is a de-facto requirement to solve trig. problems in high school. Does Microsoft expect students to relearn all these convenient derievd units in radians, and go mad?"

      If you've taken pre-calc, you should know these units in radians already.

    9. Re:Ok, but... by CastrTroy · · Score: 1

      I think that every scientific calculator I've ever seen from the $10 cheapo calculators up to my TI-86 have a setting for whether your specifying angles in degrees, radians, or gradients (which i've never had a need to use). So basically, the answer to your question is, "it depends".

      --

      Anthropic principle: We see the universe the way it is because if it were different we would not be here to see it.
    10. Re:Ok, but... by Actually,+I+do+RTFA · · Score: 4, Funny

      Can someone help me? I want to take the sin of a right angle in Excel. Can someone tell me where the pi key on the keyboard is, so I can type in pi/2 radians?

      --
      Your ad here. Ask me how!
    11. Re:Ok, but... by daskinil · · Score: 1

      I just use Matlab, the only units you use there is radians. Although then again, I'm an engineer.

    12. Re:Ok, but... by M.+Baranczak · · Score: 3, Funny

      You need to buy a Greek keyboard for that. If you're doing advanced math, it's a worthy investment.

    13. Re:Ok, but... by Inda · · Score: 1

      You're in luck because you only have to use one hand, possibly one finger, and the key combinations are grouped quite close together.

      pi()

      It's a function because it returns something. Brackets and all that stuff. It returns the value of PI. Funny really. Who would have thought it?

      --
      This post contains benzene, nitrosamines, formaldehyde and hydrogen cyanide.
    14. Re:Ok, but... by chthon · · Score: 1

      I seem to remember that all the trig math exercises and examples I had in school where in radians...

    15. Re:Ok, but... by Anonymous Coward · · Score: 0

      On a Mac, it's option-p (or option-P for uppercase).

    16. Re:Ok, but... by Tony+Hoyle · · Score: 1

      At school (didn't go as far as maths degree but could have done) they never taught us about the existance of radians. I learned about them when I first got a ZX81 and just considered it a quirk of the language.. always seem them as a computing thing not a real world thing - I've never heard them mentioned.. in fact this article is the first time I've heard the term in years!

      Not sure why anyone would want to work on something that relies on multiples of an indefinable number (3.141somethingsometinh) when you can just say 360 degrees in a circle just like the rest of the world.

    17. Re:Ok, but... by Tony+Hoyle · · Score: 1

      WTF is a grad anyway? Even the windows calculator has it but to this day I've got now clue what you would use it for.

    18. Re:Ok, but... by agbinfo · · Score: 1

      I had a scientific calculator once.

      I could to do trig in radians, degrees or grads [400 grads=2pi radians]. All I had to do was press a button with "DRG" on it and it would switch between the different units [guess in those days angles had units].

      I also had this calculator [http://www.hpmuseum.org/img/28cs.jpg] and it's feature list [http://www.hpmuseum.org/features/28sf.htm] says that it supported 2 of those units.

      I'm pretty sure if I bought a scientific calculator today, I'd find a similar feature.

    19. Re:Ok, but... by Xerotope · · Score: 1

      Except for cosd, sind and tand And I was always told that engineers came up with gradians, but I have never seen them being used in any of my engineering classes.

    20. Re:Ok, but... by moranar · · Score: 1

      I know. It was exactly my point: you get a result you understand _precisely_ because you had to choose first or you could see the default, in my calculator a D, R or G (and usually, the default setting was degrees, not radiants). None of that "units don't matter" bullshit.

      You can obtain each result I cited, and they will be an error or not in your calculations according to what unit you were thinking of. "cos 45" is a valid expression in both radiants and degrees, but only one of them is the right result in a problem.

      --
      "I think it would be a good idea!"
      Gandhi, about Internet Security
    21. Re:Ok, but... by El+Cabri · · Score: 1

      In high school I memorized the values of trig functions for 0, pi/3, pi/2 and pi. And in particular, I learned that pi/2 (90 degrees) is not in the domain of tan, which was one less value to memorize.

    22. Re:Ok, but... by vigmeister · · Score: 1

      Memorising the values of sin, cos and tan for 0, 30, 45, 60 and 90 degrees is a de-facto requirement to solve trig. problems in high school This is only required in certain curricula and definitely NOT required in American high schools. More importantly, although our teachers (in India) asked us to memorize them, for the longest time, I used geometric construction theories/visualization to figure these values out on the fly (that way I could remember how to construct an equilateral triangle and derive values of the sin,cos and tan of things. Even now, when I've had a break from doing trig for a while, I visualize the triangle to do a quick check.

      As an aside, regardless of the accuracy of OOXML, the mathematical foundation of several CS majors is often rusty when it comes to engineering/scientific applications (understandably so since they do not use certain concepts often). For example, this guy I was working on a project with was finding stresses based on some code I had written and could not for the life of him figure out why he was getting a 3x3 matrix. This was independent of the fact that he knew perfectly well what a tensor was. This disconnect helps keep 'engineers who can program' employed and has mandated the development of programs in Computational Sciences and Engineering in places like UIUC and Gatech (these are the 2 programs I want to apply to for grad school, there ought to be other ones)

      P.S. Are you sure you memorized them right? Visualize a (90,90,0) triangle. Hint: tan(90)!= 1
      (hehehe... just ragging on you for yer typo)

      Cheers!
      --
      Atheist: Buddhist in a Prius
    23. Re:Ok, but... by itlurksbeneath · · Score: 1
      Just a different way to divide up a circle. Makes a right angle a nice even 100 grads.
      • Degrees: 0 - 360 degrees, right angle 90 degrees (historical and popular)
      • Radians: 0 - 2(pi) radians, right angle pi/2 radians (mathematically convenient)
      • Gradians: 0 - 400 gradians, right angle 100 grads (historical, SI related and mostly not used)
      --
      Have you ever considered piracy? You'd make a wonderful Dread Pirate Roberts.
    24. Re:Ok, but... by rossifer · · Score: 1

      A grad, or gradian, is 1/400 of a full rotation and is nearly useless for angles since it's not evenly divisible by 3, 6, 9, or 12, with 12 being the most important divisor in that list (even division by 12 means that you can represent all of the angles in a bisected equilateral triangle (30-60-90 triangle) using integer values).

      The grad first appeared in France, and was only ever adopted in a few countries for specialized tasks (artillery, surveying) and except for French artillery, appears to be a dead unit.

      It was believed that an angle unit with right angles of 100 units would make mental math easier (if you're facing 115 grad clockwise from due North, then you're 15 grad clockwise from due East). However, if you're frequently doing navigation or other cartographic-related tasks, it turns out that you quickly adapt to the mental math required to understand 90 degree right angles and angle division is much easier.

      Regards,
      Ross

    25. Re:Ok, but... by SEMW · · Score: 1

      Can someone help me? I want to take the sin of a right angle in Excel. Can someone tell me where the pi key on the keyboard is, so I can type in pi/2 radians? How the heck did you get modded insightful? You type it in Excel exactly the same way that you typed it in your question -- a P followed by an I. Duh.

      So =SIN(PI()/2) returns 1, exactly as you'd expect it to. (=SIN(PI()) returns 1.22515E-16, but that's floating point calculations for you).

      If you really want to work in degrees, the RADIANS function converts from degrees to radians, so =SIN(RADIANS(90)) would return 1.
      --
      What's purple and commutes? An Abelian grape.
    26. Re:Ok, but... by DragonWriter · · Score: 1
      Someone failed the math class where they explained that an angle is a "dimensionless derived unit" [wikipedia.org] .

      No, an angle isn't a "dimensionless derived unit", the "radian" is an SI unit which is a "dimensionless derived unit", but you still need to know which unit is being used when angles are specified. Angles are, in different contexts, expressed in a wide variety of different units (radians, degrees, gradians, and points, among others.)

      Explaining, short version for the clicky-impaired: angles are the ratio between two measurements of length -- the length of an arc and the radius of said arc.


      Actually, no. The radian is a measure of an angle which is the ratio between the length and the radius of the arc. There are other measures of angles besides the radian. You are confusing the definition of a particular measure with the thing measured, and probably shouldn't talk about other people failing math classes on the subject when they are right and you get it all wrong.
    27. Re:Ok, but... by Lord+Ender · · Score: 1

      anybody that's ever used a calculator knows you have to use just one of those systems for your particular calculator.
      I don't know where you get your calculators, but every calculator I've ever used has an option for switching between degree and radian mode.
      --
      A slashdotter who didn't build his own computer is like a Jedi who didn't build his own lightsaber.
    28. Re:Ok, but... by itlurksbeneath · · Score: 1
      Well, that's not quite what I meant. Let me rephrase that.

      anybody that's ever used a calculator knows you have to use just one of those systems at a time for your particular calculator.
      --
      Have you ever considered piracy? You'd make a wonderful Dread Pirate Roberts.
    29. Re:Ok, but... by Tacvek · · Score: 1

      Most curriculum's I have seen require you to know the so called 30-60-90 triangle and 45-45-90 triangle. One need not memorize anything in the case of the 45-45-90 triangle, as you can just decide that the 2 legs are '1', and from Pythagorean theorem to determine that the hypotenuse is sqrt(2). From that one has no problem with the trig values for 45 degrees and 90 degrees. However, a bit more memorization is required for 30-60-90 triangle. But I think you can see that knowing a really quick method to determine the value of the trig functions at those angles is basically equivalent to memorizing the values. Many students do memorize the values, but all I have memorized are the size relations of the 30-60-90 triangle, and just quickly picture a triangle when needed. (Although a few values have become memorized due to heavy use. I definitely never used rote memorization.)

      --
      Stylish sheet to fix many problems in Slashdot's D3: https://gist.github.com/801524
    30. Re:Ok, but... by SEE · · Score: 1

      Can someone tell me where the pi key on the keyboard is, so I can type in pi/2 radians? Option+P

      Oh, you're using Windows, not MacOS, BeOs, or OPENSTEP?

      McKeyboard or AfterStep, AltGR+P
      Unicode Extended (either) AltGR+H

      (No, Excel doesn't recognize it. But hey, it's easy to become able to type it.)
    31. Re:Ok, but... by DragonWriter · · Score: 1

      Not sure why anyone would want to work on something that relies on multiples of an indefinable number


      Pi is irrational, but it is rather clearly defined. Its rather natural to use in pure mathematics, though in many applications degrees or points or some other units are more natural for the domain.
    32. Re:Ok, but... by poopdeville · · Score: 1

      It's my understanding that they're mostly used in civil engineering. Things like road inclination are measured with grads. I've seen roadsigns in the UK that used the unit. I've also seen American roadsigns say "Caution: 15% Grade" or whatever.

      --
      After all, I am strangely colored.
    33. Re:Ok, but... by poopdeville · · Score: 1

      When you take grown up math classes, the angle between two points x and y is defined to be the solution theta to the equation: (/||x|| ||y||) = cos theta. Theta is a real number. It is dimensionless. It also happens to coincide with the radian.

      Mind you, the thing defined isn't "the measurement of the angle". It is the angle. Full stop.

      --
      After all, I am strangely colored.
    34. Re:Ok, but... by poopdeville · · Score: 1

      Shit. The equation is ()/ (||x|| ||y||) = cos theta.

      --
      After all, I am strangely colored.
    35. Re:Ok, but... by Anonymous Coward · · Score: 0

      Perhaps it works that way in the US, but i've got an engineer degree in Europe, and we never used degrees with trigo in math.
      Perhaps in Physics when doing practical computations, but in Maths i've always used sin(X * pi) and the likes...

    36. Re:Ok, but... by Anonymous Coward · · Score: 0

      tan(90) is not 1 but infinity

  30. EULA applies to a "standard"? by pedestrian+crossing · · Score: 1

    I don't think that you can apply a EULA to a standard. The product (MS-Office) yes, but the standard (OOXML) no.

    --
    A house divided against itself cannot stand.
    1. Re:EULA applies to a "standard"? by arivanov · · Score: 1

      If this is indeed the case the complaint that the standard is badly defined should have gone to the approving body during the consultation period. Now it is a bit late, but still possible to do this as this may require amending the standard. This has happened many times in the past. It is, in fact, quite common for standards to be amended or even withdrawn because of things like this.

      --
      Baker's Law: Misery no longer loves company. Nowadays it insists on it
      http://www.sigsegv.cx/
    2. Re:EULA applies to a "standard"? by leenks · · Score: 1

      Defining murder such that everyone has a common understanding of what is meant by the term is fine.

      Implementing murder is illegal.

    3. Re:EULA applies to a "standard"? by Anonymous Coward · · Score: 0

      The articles I read on this did indeed say that these were known issues, some of them have been known for over ten years in MS Excel's implementation of statistics. MS apparently created the 300+ pages of formula "standards" in large part by copying their help files, with little or nothing in the process allowed to review or improve the formulations.

      Fast tracking over 6,000 pages of "standard" is making it impossible to address all the issues caused by MS's rush to market. At least one writer indicated that they wanted to bring up some of these issues in the official meetings, but didn't because they ran out of time due to the numerous other issues being brought up.

  31. Article on BBC by H4x0r+Jim+Duggan · · Score: 2, Informative

    The BBC have published an article by FSFE also explaining the general problems of MS's non-open OOXML format (and proprietary formats in general).

  32. Trust your tools, but only so far. by nikolajsheller · · Score: 1

    As a developer I occasionally find myself questioning my tools.
    A compiler/linker may contain errors, the IDE may do funny things etc.
    Admittedly most of the time it's because I've missed something somewhere, but there have been occasions where the tools have been at fault.
    The software is ultimately written by humans and will as such necessarily contain errors, and should therefore not be implicitly trusted.

    Concerning the Pentium bug: there are plenty of bugs in processors. Ask NASA. They refuse to use anything but old, thoroughly tested hardware that won't suddenly show unexpected behavior, ruining an expensive mission. The shuttles stopped using magnetic core memory in 1990. http://en.wikipedia.org/wiki/Space_Shuttle

    -Nikolaj

  33. News?? by kauttapiste · · Score: 0, Redundant

    Uh, oh. Microsoft's specification is flawed? To whom good sir is this news?

    Slashdot's slogan "News for nerds" would imply that anything posted on Slashdot is 'news', which usually is characterised by 'information'. Shannon's information theory dictates that in order for something to contain information, the probability of you not knowing the value of the message being passed is high. The probability of MS's specification being flawed and dangerous: approaching 1. Ergo, this is not news!

    Oh and don't get me even started on the "Stuff that matters" part here..

  34. Shame?! by krygny · · Score: 5, Insightful

    "Shame on all those who praised and continue to praise the OOXML formula specification without actually reading it."

    Reminds me of something I once heard a congressman rationalize in reference to a bill he just voted for containing several lame provisions (many with which he did not even agree): "Do you have any idea what reading a bill like that would entail?" I do. It would entail you doing your fucking job.

    --
    Research shows that 67% of those who use the term "research shows", are just making shit up.
    1. Re:Shame?! by Anonymous Coward · · Score: 0

      To a congressman who justifies not reading a bill he voted for via:
      Do you have any idea what reading a bill like that would entail?
      an appropriate response would be:
      Without reading it,do you have any idea what passing a bill like that would entail?

    2. Re:Shame?! by joeljkp · · Score: 1

      That's why congresspeople have trusted staffers that study these issues and go through the relevant bills. I sincerely doubt that any one person could read, much less study and understand, every bill that comes before the Congress.

      --
      WeRelate.org - wiki-based genealogy
  35. Rotation of print sample by Anonymous Coward · · Score: 0

    Why is it "rotate 90degrees clockwise" then? Why not "pi/2"?

    "Slashdot requires you to wait between each successful posting of a comment to allow everyone a fair chance at posting a comment.

    It's been 48 minutes since you last successfully posted a comment"

  36. That's where we have to wait what ISO does by Lonewolf666 · · Score: 1

    Assuming Rob Weir is right, I certainly hope that ISO insists on fixing OOXML, and rejects it as ISO standard if it is not fixed.

    But that remains to be seem, maybe Microsoft has enough clout to get it approved anyway. It seems that ECMA did not care much about quality when accepting OOXML, lets hope ISO does better.

    --
    C - the footgun of programming languages
  37. This from MS? by Anonymous Coward · · Score: 0

    A warning from the guys who brought us Executable Code via Outlook Express and infected web pages via ActiveX controls?

    Talk about hypocrisy . . .

  38. Guess what? by sid0 · · Score: 3, Informative

    Type in =SIN(30 degrees) if you want degrees. I'm sorry, Excel doesn't pander to high school students. In the real world, when the sine of an angle is mentioned, it is SUPPOSED to be radians. Every programming language I know accepts arguments for trig functions as radians.

    The article, or at least this part, is FUD.

    1. Re:Guess what? by jkrise · · Score: 1, Redundant

      I'm sorry, Excel doesn't pander to high school students. In the real world, when the sine of an angle is mentioned, it is SUPPOSED to be radians. Every programming language I know accepts arguments for trig functions as radians.

      Why is there a 'Student Edition' of MS Office at 80% discounts if MS doesn't pander to high school students?

      Every high school I know teaches angles in degrees, not radians. When someone changes their stance completely, we say "It's a U turn or a 180-degree shift" Should we say 1.55 radians shift instead?

      The default value for angles ought to be degrees, radians could be an option to cater to specific situations. Getting Microsoft to do normal things would mean a 180 degree shift in their philosophy, though.

      --
      If you keep throwing chairs, one day you'll break windows....
    2. Re:Guess what? by kryten_nl · · Score: 3, Insightful

      Just because a certain feature is the de facto standard, doesn't mean it shouldn't be included in a standards document to combat ambiguity.

      Btw, comparing Excel (Excel users) to a programming language (programmers) is a stretch at best.

      --
      For the perfect anti-Unix, write an OS that thinks it knows what you're doing better than you do and let it be wrong.
    3. Re:Guess what? by sid0 · · Score: 1

      As I said, type in =SIN(30 degrees)! So the sine function effectively accepts both radians and degrees.

      Touche on the high school part, forgot about that. :) The main customers are of course still enterprises. I still think the default argument should be radians.

      BTW, my high school in India always taught me radians as the default argument. Guess US school standards are falling. I swear, the level of the SAT is going down at least. I had a chat with someone here who scored 4750 (I-2350, II-2400) last year and he said that the Math II paper was ridiculously easy.

    4. Re:Guess what? by Anonymous Coward · · Score: 0

      They teach trig/angles with degrees in the UK as well. They may use radians at degree level (but I didn't do a Maths degree), and I think they were mentioned at A Levels, but the standard in the vast majority of education is to use degrees. There may have been some mention of them at GCSE, but that was six years ago for me now so I forget the details

      How many protractors have you seen that measure in radians? Personally, I've seen none. Probably mainly because degrees are easier to sub-divide (90 for a quarter, 45 for an eight, you only reach fractions at a 16th, and 360 is divisible by far more numbers to give round figures for other denominator values).

    5. Re:Guess what? by jkrise · · Score: 1

      BTW, my high school in India always taught me radians as the default argument. Guess US school standards are falling. I swear, the level of the SAT is going down at least.

      If you read my posting history, you will notice that I'm an Indian too... and what you have just said above is pure bullshit. Even in India, every math book specifies angles in degrees, not radians. And if MS Office expects me to type sin(30 degrees) instead of the convenient sin(30), I would rather not use it for arithmetic.

      And Excel is meant for convenience to the layman, it is not intended for scientists.

      --
      If you keep throwing chairs, one day you'll break windows....
    6. Re:Guess what? by gkhan1 · · Score: 1

      Every high school I know teaches angles in degrees, not radians. When someone changes their stance completely, we say "It's a U turn or a 180-degree shift" Should we say 1.55 radians shift instead?

      I haven't taken trig in more than a decade, but since when is 180 degrees the same as 1.55 radians? It's a much more memorable number than that, since 360 degrees = 2*pi radians, 180 degrees = pi radians. Seriously, that is not hard to remember.

    7. Re:Guess what? by sid0 · · Score: 1

      Bullshit? Really?

      Understanding ISC Mathematics (part 1, for class 11), by M.L. Aggarwal: "If an angle is given without measuring units, it is in radians." As I said, almost every angle in the book is in radians. A table is given in the very first chapter, and only that mentions "30 degrees or pi/6". Face it, sin(30) isn't 1/2. I remember my teacher deducting marks for not writing the degree sign once.

      The double standard baffles me: if Office took its angles in degrees, half of you would be jumping all over it, claiming radians as the standard.

    8. Re:Guess what? by Anonymous Coward · · Score: 0

      The point is not whether the angle should be expressed in degrees or radians, but that the specification should say which is used. "The real world" uses whatever it feels like; the C math library uses radians, mechanical drawings use degrees. My calculator defaults to degrees, but I'll write a Fourier expansion using sin() in radians. The conversion is easy enough, as long as I know which version is expected, but it's not "supposed" to be one or the other.

    9. Re:Guess what? by Anonymous Coward · · Score: 0

      As I said You? Have you been submitted to ECMA for review? We're talking about an international standard here, one that people who don't even know who you are will implement, for a product whose major market probably doesn't even know what a radian is and just wants to put in the numbers they have on their little plastic protractor.

      We haven't even started talking about the errors in the statistical formula and so on. What a quandary, do you assign this task to the guy who knows his statistics and who gets it "wrong" because they didn't follow the standard, or the guy who took a class in statistics 10 years ago and who thinks mean is the opposite of nice, who will get it wrong because the standard is wrong? If the standard specifies an entirely incorrect formula, if you use the right one, can you even claim you're compliant?
    10. Re:Guess what? by Phisbut · · Score: 1

      In the real world, when the sine of an angle is mentioned, it is SUPPOSED to be radians. Every programming language I know accepts arguments for trig functions as radians.

      While I agree with you, try this: Go around and ask every CEO, accountant and other-Excel-user what's the angle in the corner of the wall. See how many (or few) say it's 90 degrees, and how many even know it's PI/2.

      MMMMmmmmmmmmm... half a pie...

      --
      After 3 days without programming, life becomes meaningless
      - The Tao of Programming
    11. Re:Guess what? by Random832 · · Score: 1

      =SIN(30 degrees) What version of excel is this?

      --
      We've secretly replaced Slashdot with new Folgers Crystals - let's see if it notices.
    12. Re:Guess what? by sqlrob · · Score: 1

      Then why, pray tell, isn't that in the standard?

    13. Re:Guess what? by azrider · · Score: 5, Informative

      Touche on the high school part, forgot about that. :) The main customers are of course still enterprises. I still think the default argument should be radians.
      Who cares whether the default argument is degrees or radians. Two things are missing from the quoted "specification" document:

      1: What is the default argument

      2: Is the specification consistent across all functions which use this type of value as an argument

      A specification which conforms to neither proper or common usage is worse than no specification at all

      This is what Rob Weir was saying.

      --
      And ye shall know the truth, and the truth shall make you free.
      John 8:32(King James Version)
    14. Re:Guess what? by Anonymous Coward · · Score: 0

      Heck, go ask any programmer, and you'll still probably get "90 degrees" unless they just finished reading a discussion like this.

    15. Re:Guess what? by hey! · · Score: 1

      You are heading off on a tangent.

      We are talking about the proposed standard. The job of an interoperability standard is to remove ambiguity. Therefore all inputs and outputs should be unambiguously specified. Nothing should be left up to the judgment of the implementor if it alters the semantics of a document. There are two reasons for this. First, it avoids mistakes when documents are shared. Secondly, it creates a level playing field; with an ambiguous "standard", the "right" way would be the way Excel does it. So the only product that could be guaranteed to be "right" is Excel.

      If I were implementing the standard, and I came upon trigonometric functions, I would immediately ask whether they should be in terms of degrees or radians. In the absence of further data, I would make the assumption that it was radians, on the theory that most users of trig functions in a spreadsheet are likely to be doing engineering or science. But it is not true that radians are "more correct". They are less arbitrary, it is true, in that they lead to the simplest calculations of mathematical formulae. If I had to send a radio transmission to an unknown alien civilization, I would specify angle in radians.

      However -- radians are impractical for use by mechanics,artificers and architects, in that all the most important and commonly used angles are irrational numbers. These angles are nice whole numbers as degrees: 30, 60, 90, 180,360. Note because of the importance of 30 degrees, you really want the angle 2*pi to be an integral multiple of 12 in any system of angle measurement.

      If your high school taught you to use radians, somebody is being a bit hyper-cautious about making sure you don't end up as some kind of mechanic. Learning to use degrees doesn't hobble you in the least in the higher mathematics, but learning to think of angles exclusively in radians would definitely hobble you in a career like carpentry.

      --
      Post may contain irony: discontinue use if experiencing mood swings, nausea or elevated blood pressure.
    16. Re:Guess what? by frankie · · Score: 1
      1. MSO Student Edition is mainly intended for college students, not high school.
      2. You must know some sucky high schools. I learned both degrees and radians back then, and I sure as hell covered them both (strongly stating that radians are the more important form) when I was a high school math teacher.
      3. 1.55 radians? Why in the world would you measure radians in decimal? Try pi/2. (stupid /. filter is blocking symbols)
      4. Degrees are an arbitrary cultural notion. The universe operates in radians.
    17. Re:Guess what? by Ash+Vince · · Score: 1

      When I studied Physics at Uni we did everything in Radians. Our advice was to set your calculator into radian mode and then never change it.

      The SI dirived unit of measurement for angles is the Radian. This is because it has a logical meaning. See this link for the definition:
      http://en.wikipedia.org/wiki/SI_derived_unit

      Degrees of an ark however are an arbritary unit. Someone decided there would be 360 degrees in a circle but they could just as easily have decided that there were 400 or 64.

      --
      I dont read /. to RTFA, I read /. to offend people in ignorance.
    18. Re:Guess what? by Anonymous Coward · · Score: 0

      I never got radians in high school in the US, only degrees. I didn't see radians until I got to college.

    19. Re:Guess what? by Hoi+Polloi · · Score: 4, Informative

      The number 360 isn't arbitrary. It stems from mesopotamia and the need to represent numbers as fractions. People needed a number that could be divided by 2, 3, 4, 10, 12, etc easily in one's head yet big enough to provide small fractions.

      From wikipedia:

      "The number 360 as the number of 'degrees' (i.e. smallest practical sub-arcs) in a circle, and hence the unit of a degree as a sub-arc of 1360 of the circle, was probably adopted because it approximates the number of days in a year. Its use is often said to originate from the methods of the ancient Babylonians. Ancient astronomers noticed that the stars in the sky, which circle the celestial pole every day, seem to advance in that circle by approximately one-360th of a circle, i.e. one degree, each day. Primitive calendars, such as the Persian Calendar used 360 days for a year. Its application to measuring angles in geometry can possibly be traced to Thales who popularized geometry among the Greeks and lived in Anatolia (modern western Turkey) among people who had dealings with Egypt and Babylon.

      Another motivation for choosing the number 360 is that it is readily divisible: 360 has 24 divisors (including 1 and 360), including every number from 1 to 10 except 7. For the number of degrees in a circle to be divisible by every number from 1 to 10, there would need to be 2520 degrees in a circle, which is a much less convenient number.

      Divisors of 360: 1, 2, 3, 4, 5, 6, 8, 9, 10, 12, 15, 18, 20, 24, 30, 36, 40, 45, 60, 72, 90, 120, 180, 360"

      --
      It is by the juice of the coffee bean that thoughts acquire speed, the teeth acquire stains. The stains become a warning
    20. Re:Guess what? by MajinBlayze · · Score: 1

      You are heading off on a tangent. Oh! the Irony

      Sorry, I'm bored.
      --
      "Hate is baggage. Life's too short to be pissed off all the time." Danny Vinyard -American History X
    21. Re:Guess what? by Hotawa+Hawk-eye · · Score: 1

      Why is there a 'Student Edition' of MS Office at 80% discounts if MS doesn't pander to high school students?
      Because they're pandering to college students? I imagine the percentage of high school students who need/want their own copy of Office is lower than the percentage of college students who need/want their own copy.

      When someone changes their stance completely, we say "It's a U turn or a 180-degree shift" Should we say 1.55 radians shift instead?
      No. 2*pi radians is 360 degrees, so pi radians is 180 degrees. We could say they made a pi-radians shift. pi/2 radians (or approximately 1.55 radians) is 90 degrees.

      The default value for angles ought to be degrees, radians could be an option to cater to specific situations.
      If you're solving introductory geometry problems in school, you're probably using degrees. If you're using calculus or working in physics or engineering, you're probably using radians.
    22. Re:Guess what? by DrXym · · Score: 2
      Type in =SIN(30 degrees) if you want degrees. I'm sorry, Excel doesn't pander to high school students. In the real world, when the sine of an angle is mentioned, it is SUPPOSED to be radians. Every programming language I know accepts arguments for trig functions as radians.

      That's a ridiculous thing to say. We are talking about a specification that applications are meant to IMPLEMENT, not second guess. If a function takes radians it should just say it.

    23. Re:Guess what? by SEMW · · Score: 1

      As I said, type in =SIN(30 degrees)! On my version of Excel, at least, that doesn't work. The help file tells me to use the RADIANS function (which converts from degrees to radians) inside the Sin function, so the correct formula if you like using degrees would be, for 30 degrees, =SIN(RADIANS(30))
      --
      What's purple and commutes? An Abelian grape.
    24. Re:Guess what? by sid0 · · Score: 1

      My REALLY, REALLY bad. :( I was simply thinking of something entirely different. The correct formula is SIN(RADIANS(30)), which is indeed a lot more clunky than SIN(30 degrees). Sorry.

    25. Re:Guess what? by sid0 · · Score: 1

      Yes, correct. I'm really sorry for the wrong information.

    26. Re:Guess what? by Anonymous Coward · · Score: 0

      Even with its astronomical basis, the number 360 is still arbitrary. Would that number make any sense on a planet without a revolution of ~360 days?

    27. Re:Guess what? by ajs318 · · Score: 1

      Every programming language I know accepts arguments for trig functions as radians.
      Then you've obviously never used PostScript.

      I once wrote a bit of PostScript under the assumption that arguments to sin and cos were meant to be in radians (because, as you said, that's the way it's done in other languages ..... then again, in other languages you write the name of the function first and then the arguments, so perhaps I should have been just a teeny-weeny bit suspicious). It took me a long time to work out why my rotated objects were not rotating as much as I was expecting!

      I took some small consolation from thinking that I probably was not the first person this had happened to, nor would I be the last.
      --
      Je fume. Tu fumes. Nous fûmes!
    28. Re:Guess what? by Hoi+Polloi · · Score: 1

      I was under the assumption that we were only talking about systems developed on planet earth and not alternate universes, aliens, Star Wars, etc.

      --
      It is by the juice of the coffee bean that thoughts acquire speed, the teeth acquire stains. The stains become a warning
    29. Re:Guess what? by trewornan · · Score: 1

      180 degrees is pi radians you dumb shit.

    30. Re:Guess what? by LiquidFire_HK · · Score: 1

      I notice you are using the decimal system. How is that any less arbitrary than a full circle being 360 degrees?

    31. Re:Guess what? by trewornan · · Score: 1

      Sadly this is probably true. All my maths teachers (after infant school) automatically used radians and rarely mentioned degrees. But that was back when we had O'levels instead of GCSEs and A'levels were difficult. I assume it's all been dumbed down now and that's why you think radians is degree level maths. You can't do calculus using degrees.

      As far as division goes, it's no more difficult to subdivide radians than anything else 1 degree is pi/180 radians after all, 90 degrees is pi/2, 60 degrees is pi/3 and so on - it's trivially easy to convert but why bother?

    32. Re:Guess what? by Achromatic1978 · · Score: 1

      Why is there a 'Student Edition' of MS Office at 80% discounts if MS doesn't pander to high school students?

      To advertise academic discounts? This is a specious comment. Above and beyond that, you can aim something at students, without aiming at the lowest common denominator. Should Word's dictionary also have cartoon images with definitions and things like "A is for Apple", too?

      Every high school I know teaches angles in degrees, not radians.

      Perhaps in Junior High. Anywhere where you're expected to having a working knowledge of 'real' trigonometry (for me, 10th grade math) DEFINITELY taught radians, extensively.

    33. Re:Guess what? by Achromatic1978 · · Score: 1

      Wow, UK standards are falling too - in Australia if you want to get into university with a high school pass in two of the three math options, you'd better know and understand radians.

    34. Re:Guess what? by Anonymous Coward · · Score: 0

      If you had paid attention to the GP post, then yes it would if you were using a base-10 (decimal) number system.

    35. Re:Guess what? by DragonWriter · · Score: 1

      Type in =SIN(30 degrees) if you want degrees. I'm sorry, Excel doesn't pander to high school students.


      The UI of Excel is not the issue.

      The issue is the specification of the OOXML format.

      The fact is there are many different units used for measuring angles (radians, degrees, grads, points, etc.), and radians aren't the only one. The argument is that the format specification should specify the unit if correct and consistent implementation requires a particular unit.

      Every programming language I know accepts arguments for trig functions as radians.


      IIRC, most dialects of Logo and some of BASIC accept arguments for trig functions as degrees.

      Not that what programming languages accept is particularly relevant to what the format specification should specify, since presumably OOXML implementation behavior on this point should not be unspecified and dependent on the programming language used in the implementation.
    36. Re:Guess what? by a.d.trick · · Score: 1

      Actually, it's still arbitrary because there's no intrinsic connection between 360 and a circle. It might be a very convenient arbitrary number, but it's still arbitrary. That said, arbitrary constants are pretty common, even in the sciences. There aren't many people who would contest the widespread usage of base 10.

    37. Re:Guess what? by Anonymous Coward · · Score: 0

      The double standard baffles me: if Office took its angles in degrees, half of you would be jumping all over it, claiming radians as the standard.

      The issue isn't that radians are the units used. The issue is that no units are specified in the standard.
      ie it's up to the people doing the implementation to choose... see the problem?

    38. Re:Guess what? by Ash+Vince · · Score: 1

      Wow, so it is pretty far from being a prime number.

      But it still has not basis in the physical world or in geometry. The radian on the other hand actually relates to pi so is thoroughly based in pythagorean geometry.

      Also, I found the following page on wikipedia which suggests that the persian calendar was pretty imprecise and does not always contain the same number of days in a year:

      http://en.wikipedia.org/wiki/Iranian_calendar

      So by your logic maybe we should have used 365.242199 degrees to make up a circle instead.

      The fact is the radians actually have a meaning and are thoroughly useful. That fact that most people stop learning long before they need them is pretty irrelevant to those people who cannot do without them. It's like saying that mph is an acceptable measure of speed in relation to light in a vacuum.

      --
      I dont read /. to RTFA, I read /. to offend people in ignorance.
    39. Re:Guess what? by Anonymous Coward · · Score: 0

      The number 360 isn't arbitrary. It stems from mesopotamia and the need to represent numbers as fractions.

      Heh. Yes, and that makes it arbitrary, even if it has mnemonic value.

    40. Re:Guess what? by gnasher719 · · Score: 1

      '' Sadly this is probably true. All my maths teachers (after infant school) automatically used radians and rarely mentioned degrees. But that was back when we had O'levels instead of GCSEs and A'levels were difficult. I assume it's all been dumbed down now and that's why you think radians is degree level maths. You can't do calculus using degrees. ''

      All GPS systems use degrees to specify locations.
      Ever used a mitre saw? It uses degrees in angles.
      What angle is the roof of your house? Radians or degrees?
      Ever seen a road that goes up at a 0.1 radians angle? I haven't.

    41. Re:Guess what? by gnasher719 · · Score: 1

      '' Degrees of an ark however are an arbritary unit. Someone decided there would be 360 degrees in a circle but they could just as easily have decided that there were 400 or 64. ''

      Full angle = 360 degrees = 400 grad = 2pi rad.

      Just type "grad" into wikipedia.

    42. Re:Guess what? by mgv · · Score: 2, Funny

      Type in =SIN(30 degrees) if you want degrees. I'm sorry, Excel doesn't pander to high school students. In the real world, when the sine of an angle is mentioned, it is SUPPOSED to be radians. Every programming language I know accepts arguments for trig functions as radians.


      But the difference with the microsoft OOXML is that the units are sensed automagically as part of the result computations. The use of radians rather than degrees is specified by a combination of having administrator privileges, the instillation of visual studio, and a low user id on slashdot. In the absence of these features, the units are assumed to be specified in degrees.

      Michael
      --
      There is no cryptographic solution to the problem where the intended receiver and the attacker are the same entity.
    43. Re:Guess what? by Ash+Vince · · Score: 1

      Not sure what your point was I afraid. Any chance of a more in depth explanation.

      I did on the other hand look grad up on wikipedia for amusement. I have never had to work in gradians since I do not know of any field that uses them. I was however aware that there were 2pi radians in a circle since you would be hard pressed to study physics and not get that hammered into you.

      --
      I dont read /. to RTFA, I read /. to offend people in ignorance.
    44. Re:Guess what? by Hoi+Polloi · · Score: 1

      My comment was about the use of the term "arbitrary", nothing else. My point is not that it has anything to do with great precision, or that it the best choice or anything like that. My point is that there was logic behind it and that it wasn't pulled out of thin air (as implied by the parent comment). Its origin is a matter of historical development, like bronze preceding iron. The use of a 360 degree system was also much more user friendly to the average person who didn't have a decimal system and it is easier to work with than an irrational number like pi.

      --
      It is by the juice of the coffee bean that thoughts acquire speed, the teeth acquire stains. The stains become a warning
    45. Re:Guess what? by Ash+Vince · · Score: 1

      The use of a 360 degree system was also much more user friendly to the average person who didn't have a decimal system and it is easier to work with than an irrational number like pi.

      Why? Apart from just the fact that it is the system people are used to using. Personally I would find it easier it there were 10 or 100 to make it more like the decimal system if it was going to be an arbitrary number. I also still maintain that the choice of 360 is arbritary as it was not chosen for any logical reason other than it was close to the number of days in a year. If it was exactly the number of days it would be less arbitrary, but it it is not.

      --
      I dont read /. to RTFA, I read /. to offend people in ignorance.
    46. Re:Guess what? by Hoi+Polloi · · Score: 1

      Then based on your logic a base 10 decimal system is totally arbitrary too.

      --
      It is by the juice of the coffee bean that thoughts acquire speed, the teeth acquire stains. The stains become a warning
    47. Re:Guess what? by Ash+Vince · · Score: 1
      --
      I dont read /. to RTFA, I read /. to offend people in ignorance.
  39. Calculator in Windows 2000 does not... by Lonewolf666 · · Score: 1

    By default, the calculator in Windows 2000 uses degrees. Enter "30", press "sin" and you get 0.5. To be fair, at least it displays the argument format via a set of radio buttons (where it can be altered as well).
    From this, I infer that it is not always assumed at Microsoft that trig functions take arguments in radians. So if the same corporation presents a "standards" document where the argument format is undefined, I'd also ask for clarification ;-)

    --
    C - the footgun of programming languages
  40. This is to be expected... by rsmoody · · Score: 3, Interesting

    After all, they did not BUY this from someone else. They came up with it on their own. We all know, Microsoft's best products were purchased from someone else. Excel for example.

    --
    45 5F E1 04 22 CA 29 C4 93 3F 95 05 2B 79 2A B2
    1. Re:This is to be expected... by Politburo · · Score: 1

      This is not supported by wikipedia.. do you have a link to support your claim?

  41. Assumption is the mother.... by splutty · · Score: 1

    Okay. Nice rant. However, let me capitalize this for the mentally impaired: DO NOT ASSUME ANYTHING IN A STANDARD DEFINITION.

    That's the whole idea. A standard is meant to *AVOID* the pitfalls of assumption (which tend to be different for different people)

    So uhm. Get real.

    And if you're the professional you say you might possibly be, then your calculator example is even more retarded, since any sort of professional scientific calculator *will* actually tell you what baseX it's currently working in. (Mine sure as hell does). Most even have default buttons to switch it to Base2, Base8, Base10 and Base16.

    --
    Coz eternity my friend, is a long *ing time.
  42. Giving OO a bad name spin Dr at work by Anonymous Coward · · Score: 0

    Seems pretty obvious its PR stunt to drag the term 'OO' down. Come on, microsoft coming out with an Open Source project.... give me a break. That would scare the hell out of their corporate consumers.

    Even if its not a PR stunt, it will probably bring some negative connotations on the term 'OO'.

  43. Mars probes anyone? by splutty · · Score: 1

    Aha. You very nicely forgot the whole incident of NASA losing a Mars probe due to someone 'forgetting' whether it was centimeters or inches as their base unit...

    --
    Coz eternity my friend, is a long *ing time.
    1. Re:Mars probes anyone? by Anonymous Coward · · Score: 0

      Heh, no I didn't forget that. I'll repeat:

      "If they don't, then they are likely unqualified to do what they are doing, and no amount of precision in the standard will help them."

      In this case you proved my point. The distinction between inches and centimeters is very well known to NASA. No ambiguity there. But the people who designed the probes navigation system were so utterly incompetent that all the knownledge in the world about inch-centimeter conversion wasnt able to help them. There wasnt a breakdown of basic computer programming principles - the failure was human error.

      Similarly anyone who thinks a trig function in excel will accept a degree argument instead of radians isnt going to bother to look up the specs and see what he or she SHOULD use. They will just use degrees and fuck it up. Such people are unqualified/idiots, and *no amount of precision in the standard will help them*!

  44. Someone else failed the math class by giafly · · Score: 3, Insightful

    Someone failed the math class where they explained that an angle is a "dimensionless derived unit".
    If you must quote Wikipedia, please read it first. This article refers to the "SI system of measurement units" which measures angles in units of radians: "The unit of angle is the angle subtended at the centre of a circle by an arc of the circumference equal in length to the radius of the circle. There are 2 radians in a circle."

    Other measurement systems use different units for angles, for example degrees.

    In short, a thing being dimensionless does not mean no units are used to measure it.
    --
    Reduce, reuse, cycle
    1. Re: Someone else failed the math class by giafly · · Score: 1

      Errata: There are 2pi radians in a circle. F*ing copy-and-paste deleted the pi symbol. I wonder if anyone else will notice?

      --
      Reduce, reuse, cycle
    2. Re: Someone else failed the math class by stupid_is · · Score: 1

      Of course not, this is /. - we don't read the content. We just try and make an "all your XXX are belong to us", "in soviet russia..." or "1.2.3.Profit!!" jokes from whatever post there is, or just invent a stupid position and arbitrarily quote wiki to justify it. Shit, I've got a doctorate in maths and didn't notice until reading your post

      --
      -- Intelligence is soluble in alcohol
    3. Re: Someone else failed the math class by TheRaven64 · · Score: 1

      We didn't notice, because we're so used to Slashcode eating unicode characters that we mentally filled it back in for you.

      --
      I am TheRaven on Soylent News
    4. Re: Someone else failed the math class by Chelloveck · · Score: 1

      Of course not, this is /. - we don't read the content. We just try and make an "all your XXX are belong to us", "in soviet russia..." or "1.2.3.Profit!!" jokes from whatever post there is, or just invent a stupid position and arbitrarily quote wiki to justify it. Shit, I've got a doctorate in maths and didn't notice until reading your post

      All your trig are belong to us!

      In Soviet Union, angles measure you!

      1. Implement basic math functions using unspecified units.
      2. ???
      3. Profit!

      --
      Chelloveck
      I give up on debugging. From now on, SIGSEGV is a feature.
    5. Re:Someone else failed the math class by Lord+Ender · · Score: 2, Funny

      If you must quote Wikipedia, please read it first.
      He did, but I changed it after he posted but before you posted.
      --
      A slashdotter who didn't build his own computer is like a Jedi who didn't build his own lightsaber.
  45. MS Office approx. Reference Implementation by BarneyRubble · · Score: 1

    I agree with the general point that the spec. should be more carefully defined.
    However, in practise does MS office not act as a reference implementation to clear
    up ambiguities?

    1. Re:MS Office approx. Reference Implementation by Lonewolf666 · · Score: 3, Informative

      -Which version of MS Office (including level of Service pack)?
      -And who guarantees that the "reference implementation" is still available 5 years from now? (hint: Microsoft tends to discontinue sale of its products after a few years).

      --
      C - the footgun of programming languages
    2. Re:MS Office approx. Reference Implementation by gnasher719 · · Score: 2, Interesting

      '' I agree with the general point that the spec. should be more carefully defined.
      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.

  46. Radians vs Degrees by BillGatesLoveChild · · Score: 1

    Amen. Radians are used for number crunching, but Geographic Information Systems lean towards degrees, military systems measure depression in mils and the steepness of roads is measured as a gradient. And as you say, textbooks use degrees and that's what most people learn. Many people won't even know what a radian is. Given that and the target audience of Excel, I would have guessed Excel's trig functions to be in degrees. (They're actually radians).

    A spec is supposed to call this stuff all out clearly. It's not supposed to be left as guesswork for the reader.

    1. Re:Radians vs Degrees by Anonymous Coward · · Score: 0

      Amen. Radians are used for number crunching, but Geographic Information Systems lean towards degrees, military systems measure depression in mils and the steepness of roads is measured as a gradient.


      Do military systems measuring depression and geographic information systems make use of sin, cos, atan, etc?? Convention is that trig functions take radians as the default. Whenever you see degrees or grads uses, it's specified as such (e.g. via the degree symbol). When units aren't specified, radians are assumed.

      But it doesn't really matter in the long term as far as OOXML ratification by ISO goes, because it's so simple to change the spec to address this stuff. It has no effect on existing implementations.

      Rob Weir has been trying to kill off OOXML for months now, and he's resorting to this shows that he's running out of ammo fast. At first he was trying to point out problems that were unfixable and would kill off the format. He failed at that. Now he's having to resort to problems he finds that are fixable merely by adding a few sentences to the spec. "The default unit for trig functions is radians." Yep, that's certainly going to kill off the format - NOT. ECMA, which now owns the spec, will simply add sentences like that if necessary, end of story. Don't kid yourself into thinking this is the kind of thing that will kill off the format (which is the real goal of slashdotters).
  47. Because the OpenFormula isn't in the spec? by Anonymous Coward · · Score: 1, Insightful

    And the spec is going to include it. Maybe that is why ODF doesn't supply it.

    So, rather than get it WRONG, they are leaving it out.

    "Slashdot requires you to wait between each successful posting of a comment to allow everyone a fair chance at posting a comment.

    It's been 54 minutes since you last successfully posted a comment"

    1. Re:Because the OpenFormula isn't in the spec? by ray-auch · · Score: 1

      So, rather than get it WRONG, they are leaving it out.

      In the example I quoted, that is exactly what MS did - they left the type of the argument to Sin() undefined - ie. not "wrong", just left out. Just like ODF did.

    2. Re:Because the OpenFormula isn't in the spec? by Anonymous Coward · · Score: 0

      > In the example I quoted, that is exactly what MS did - they left the type of the argument to Sin() undefined - ie. not "wrong", just left out. Just like ODF did.

      That's the wrong way to leave it out. Ever hear how a little knowledge can be trouble? A badly broken spec isn't necessarily better than a good one that's almost done.

  48. Re:Amuritans! You get the leaders you desserve! by Anonymous Coward · · Score: 0

    Sounds good to me... Sounds like I, for the most part, would have voted the same ways... and #26 is definitely a plus! almost always a persons real feelings on true civil liberties is inverse of what the bigoted and unbalanced socialist aclu would "rate" them. and by all means drill in ANWR!!!! Please!

  49. Re: Circular Reference Implementation by JetScootr · · Score: 3, Insightful

    Absolutely not. A standards specification should stand on its own, or reference other standards. "MS office" is an implementation, not a standard. It can't be used to define a standard any more than the wheelbase of your car can define what a roadway should be.
    Further, if ooxml is as "free" as MS would have politicians believe, then referring back to a proprietary product destroys that "freedom". (It's really not free, anyway, but just for the sake of discussion...)

    --
    Pavlov wouldn't be so famous if he'd used a can opener instead of a bell.
  50. Re: Circular Reference Implementation by BarneyRubble · · Score: 2

    Again i agree that in an ideal world it should stand on it own. But absolutely defined specs are hard (see spec for kilogram for example) hence the need for reference implementations.
    I guess my real point is pragmatically with the spec + office(to clear up a few ambiguities ) it should be able to create compatible programs.
      Is it is ideal? No. Is it workable? probably?

  51. Re:Amuritans! You get the leaders you desserve! by Anonymous Coward · · Score: 0

    How can a 'pro-life' government be such a killing machine? It was elected by hypocrits and is run by hypocrits.

    Just goes to show you:

    hypocritical citizens + democracy = hypocritical government

    garbage in, garbage out.

  52. tan(90 degrees) != 1 by fintux · · Score: 1

    You have to memorize the results again even when using degrees, because tan(90 degrees) is not 1. It is undefined.

    And of course, the results are the same, no matter whether using radians or degrees as units. For example, 180 degrees = pi radians, so sin(180 degrees) = sin(pi) = 0.

  53. now arriving at Dallas-Fort Worth... by rubberglove · · Score: 4, Funny

    Think doctors and malpractice lawsuits. Texas just put a cap on malpractice lawsuit awards and doctors are flooding there, sure to drive health care costs down.
    "Hi everybody!"
    "Hi Doctor Nick!"
    1. Re:now arriving at Dallas-Fort Worth... by gartogg · · Score: 1

      Does anyone pay attention to how much money has been put into an astroturfing campaign to "prove" that doctors are going under because of malpractice? Did anyone notice that insurance companies donate literally billions of dollars to campaigns over the past decades to get this passed?

      "The Bush administration largely gets it backwards, they say health care is expensive because of lawsuits. I say lawsuits are expensive because of our health care system." William M. Sage, Columbia University law professor and physician.

      --
      I'm a concientious .sig objector.
    2. Re:now arriving at Dallas-Fort Worth... by t0rkm3 · · Score: 1

      That's funny. My family doctor, who has been my doctor for 17 yrs, is also a lawyer. He is a great doctor and is very popular with his clients. He also still does housecalls. Oddly enough, he said the biggest problem he has with being a doctor is the cost of malpractice insurance, and the number of patients who can't afford his regular office rates because of the cost of doing business. Luckily, he gets a lot of help from patients and charitable institutions to continue working with those who cannot afford to pay their way.

      His brother, also a lawyer and doctor, got out of medicine because of the risk and cost. He practices contract law or some such now.

    3. Re:now arriving at Dallas-Fort Worth... by RexRhino · · Score: 2, Insightful

      "The Bush administration largely gets it backwards, they say health care is expensive because of lawsuits. I say lawsuits are expensive because of our health care system." William M. Sage, Columbia University law professor and physician. Mr. Sage might be a law professor and physician, but he is obviosly not an economist. You have to be pretty foolish to believe that making doctors pay millions in insurance premiums, and driving thousands out of the medical field for fear of lawsuits, wouldn't make health care more expensive.

      Name dropping Bush is a nice touch too... usually when people can't make a coherent arguement, they throw the word "Bush" into their sound bite, because Bush is extremly unpopular and that is enough to make people lose their ability for critical thought. I mean, why didn't he mention Hitler while he was at it? Or Satan?

      Did anyone notice that insurance companies donate literally billions of dollars to campaigns over the past decades to get this passed? The Trial Lawyers of America, the political action group that represents ambulance chasers, gives 50% more campaign donations that the rest of the insurance, medical, and pharmicutical industry combined. They are the single largest donator to political campaigns in America. However many "billions" you think that the insurance companies spend, multiply that by several times and that is what the Trial Lawyers spend! http://www.triallawyersinc.com/healthcare/hc07.htm l
    4. Re:now arriving at Dallas-Fort Worth... by node+3 · · Score: 2, Insightful

      Mr. Sage might be a law professor and physician, but he is obviosly not an economist. You have to be pretty foolish to believe that making doctors pay millions in insurance premiums, and driving thousands out of the medical field for fear of lawsuits, wouldn't make health care more expensive. Yeah, when you require such an important job be done right, *of course* it's going to cost more. At least, up front. In the long term, however, it's much, much better.

      Capping medical malpractice awards is another way of saying, "limiting the rights of the victim". Aren't you conservatives supposed to be all in favor of victim's rights? If your doctor screws up, don't you think you have rights to compensation under the law? Capping compensation is like capping prison sentences. It's like saying, no matter how bad your actions are, you can only be punished so far. For a group that so strongly supports the death penalty, being against having to pay for the damage you've caused seems absurd to the extreme.

      How would you feel if everything was capped like this? If your building contractor was similarly capped? Did his malpractice cost you $100 million? Tough, you can only get $200k from him, regardless of whether he was entirely at fault, and found negligent at his profession. That would be insane. How much worse when it's something to do with your health!

      The Trial Lawyers of America There is absolutely *NOTHING* wrong with being a trial lawyer. To be against them is to basically be against the JUDICIAL system. How insane is that?

      You used the derogatory term "Ambulance Chasers" to refer to trial lawyers. If they have a case, if there was fault worthy of a trial, what is *wrong* with seeking to make the guilty party pay? If it weren't for trial lawyers, the US would be a much more dangerous place to live.

      I have absolutely no doubt that if someone's actions caused you significant loss of health, *YOU'D* hire the best trial lawyer your money could buy.
    5. Re:now arriving at Dallas-Fort Worth... by RexRhino · · Score: 1

      Yeah, when you require such an important job be done right, *of course* it's going to cost more. At least, up front. In the long term, however, it's much, much better. Actually, doing a job to too high standards can kill people, if resources are limited. For example, if MRI machines need to be made to insanely perfect specifications, because one or two mis-diagnosis can bankrupt the company with lawsuits - And because of the extremly high standards, there is a shortage of MRI machines that leave thousands of people without the MRIs they need (as is a huge problem here in Canada) - It is protecting those one or two people at the expense of thousands. A company can't get sued for making a product too expensive for all but a handful of people to afford, but they WILL get sued, for hundreds of millions, for even the tiniest mistake... which means that companies are going to err on the side of making a few very very very expensive machines, instead of mass-production that can fill the needs of everyone. Millions of people are being harmed by this kind of thing, not only in the United States, but other countries since medical equipment is a global market.

      Capping medical malpractice awards is another way of saying, "limiting the rights of the victim". Aren't you conservatives supposed to be all in favor of victim's rights? If your doctor screws up, don't you think you have rights to compensation under the law? Capping compensation is like capping prison sentences. It's like saying, no matter how bad your actions are, you can only be punished so far. For a group that so strongly supports the death penalty, being against having to pay for the damage you've caused seems absurd to the extreme. Where the hell did I say I was a conservative? I believe the rights of the accused trump any right of the alleged victim, and I oppose the death penalty. I believe what Blackstone said: "It is better that ten guilty persons escape than that one innocent suffer." That includes doctors. I am all for capping prison sentences for everything but murder and rape... saying that you can only be punished so far sounds like a very fair and sensible thing to do for all but the most extreme crimes.

      If people want protection, let them go to a doctor who is bonded. The surety bond is a long established concept that would be extremly popular if it wasn't so easy to sue people.

      If it weren't for trial lawyers, the US would be a much more dangerous place to live. Yeah... cause you know, places that aren't lawsuit crazy, like France, or Germany, or Canada, are just sooooo much more dangerous than the United States. Please!

      If they have a case, if there was fault worthy of a trial *ALL* cases go to trial. Someone sued their doctor for prescribing them drugs that "disrupted their psychic powers", and that went to trial - it cost the doctor tens of thousands to defend themself from the most rediculous claims. Since it costs tens or hundreds of thousands of dollars to defend yourself against malpractice suits, preditory lawyers go after doctors for just under what it would cost to fight in court. In many cases, even though the accusation holds no merit, it is easier for the doctor to pay the $50,000 to the telephone psychic who claims she can no longer read minds than to fight it for years in the courts. The vast majority of cases that go to trial are not worth of a trial, but because the TLA have such a stranglehold on the political process (they are the biggest lobbiests in Washington), they get away with murder.

      I have absolutely no doubt that if someone's actions caused you significant loss of health, *YOU'D* hire the best trial lawyer your money could buy. You are missing the point. The vast majority of medical lawsuits involves cases where someone never suffered any significant loss of health, and the doctor wasn't responsible. It is just a legal protection scheme, kinda like with the Mafia, except the extortionists are too cowardly and spineless to do it the old fashion way.
    6. Re:now arriving at Dallas-Fort Worth... by Anonymous Coward · · Score: 0

      Maybe Dr. Jack Kervorkian could get an job down there...

    7. Re:now arriving at Dallas-Fort Worth... by node+3 · · Score: 2, Interesting

      Actually, doing a job to too high standards can kill people That's not what we're talking about. We're talking about malpractice insurance. If the standards are set to high, that's the problem with the standards, not the insurance itself.

      I believe the rights of the accused trump any right of the alleged victim We're not talking about the accused. We're talking about the guilty. If you're found *guilty* of malpractice, you must pay, and there should be no artificial cap--you pay what you deserve to pay. Until you're found guilty, you most certainly deserve rights to protect you from malicious or unmerited persecution. It seems to me you are focusing on the wrong part. There's (seemingly) a flaw in the first half (the part *before* you're found guilty), yet you think that, due to this, you should apply the fix to the second part (the part *after* you're found guilty).

      I am all for capping prison sentences for everything but murder and rape... saying that you can only be punished so far sounds like a very fair and sensible thing to do for all but the most extreme crimes. So do I. Unfortunately for you, that's not what I argued against. I argued against limiting damages (punishment) before even taking into account the nature and severity of the wrongdoing.

      If people want protection, let them go to a doctor who is bonded. They can do this now. This is also the case with auto insurance. You can be bonded, or you can buy insurance. But mandatory insurance (or bond) makes us all safer.

      Yeah... cause you know, places that aren't lawsuit crazy, like France, or Germany, or Canada, are just sooooo much more dangerous than the United States. Please! No, I said, "If it weren't for trial lawyers, the US would be a much more dangerous place to live." Are you saying France, Germany and Canada all do not have trial lawyers? Interesting. How do they settle civil disputes?

      *ALL* cases go to trial. No they don't.

      [about whether you'd pay for a trial lawyer's services] You are missing the point. No, that's *exactly* the point. You decry them as an evil, yet you'd not hesitate for one moment to avail yourself of their services.

      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.

      The vast majority of medical lawsuits involves cases where someone never suffered any significant loss of health, and the doctor wasn't responsible. First off, did you just make that up? Second, even if it's true, do these cases result in the plaintiff winning? Third, isn't that fraud? And again, this does not indict insurance, it indicts flaws in the rules.

      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?
    8. Re:now arriving at Dallas-Fort Worth... by Fred_A · · Score: 1

      eah... cause you know, places that aren't lawsuit crazy, like France, or Germany, or Canada, are just sooooo much more dangerous than the United States. Please!
      But they are !
      Especially Europe !
      Those places will contaminate you win un-american ideas ! I have several US friends who came here and now don't want to go back. Those bastards, taking jobs from honest Europeans just because they find life more comfortable here... They drink our beer and date our women and yet we still pay for their medical bills.

      We should sue them, that's what I say !
      --

      May contain traces of nut.
      Made from the freshest electrons.
    9. Re:now arriving at Dallas-Fort Worth... by Zeinfeld · · Score: 1
      Mr. Sage might be a law professor and physician, but he is obviosly not an economist. You have to be pretty foolish to believe that making doctors pay millions in insurance premiums, and driving thousands out of the medical field for fear of lawsuits, wouldn't make health care more expensive.

      A very substantial fraction of health care lawsuits goes to the cost of healthcare. That is particularly the case with multi-million dollar malpractice suits. The juries award damages because they know its the only way the kid born with a congenital condition is going to get health care.

      And then the trial lawyers fees mark cost that up by another 60-80%.

      The EULA issue is irrelevant though. Damages are only due if negligence can be proved and that is pretty hard to do with software. In particular you have to prove that the cost of avoiding the software error was less than the expected harm times the probability of the harm (the Hands formula). Microsoft spends billions on software testing and they have state of the art software processes. To prove a negligence case you would need smoking gun type evidence where a bug was reported, there was a reason to expect specific harm and nothing was done to correct the problem in a timely fashion.

      Call me skeptical but I don't see much chance of anyone winning a case like that very often. If they did the trial lawyers would have been over it ten years ago.

      --
      Looking for an Information Security student project suggestion?
      Try http://dotcrimeManifesto.com/
    10. Re:now arriving at Dallas-Fort Worth... by Anonymous Coward · · Score: 0

      But the cost of malpractice insurance has very little to do with lawsuits, and more to do with bad investments by the insurer. They blame the lawsuits so they can have lawsuit caps implemented, which lowers their risk immensely.

    11. Re:now arriving at Dallas-Fort Worth... by RexRhino · · Score: 1

      That's not what we're talking about. We're talking about malpractice insurance. If the standards are set to high, that's the problem with the standards, not the insurance itself. No, because it is the lawsuits that are setting the "standards". They are setting De Facto standards, impossibly high standards you need to meet in order not to get sued... circumventing the democratic process which sets De Jure standards.

      So do I. Unfortunately for you, that's not what I argued against. I argued against limiting damages (punishment) before even taking into account the nature and severity of the wrongdoing. No, Civil suits do not have the same sorts of protections for the accused that criminal law has... therefore, damages should be limited regardless of the nature and severity of wrongdoing. If I am accused in a criminal court, the prosecution (the state) has to pay my legal fees... I have the right to silence... I have the right to a speedy trial... I have a whole slew of rights to protect me. If you want to punish people to an extreme level, a level which can destroy the lives of the accused on par as a criminal conviction, then you should do that to the standards of criminal law - the person is innocent until proven guilty beyond any reasonable doubt first and foremost.

      No, I said, "If it weren't for trial lawyers, the US would be a much more dangerous place to live." Are you saying France, Germany and Canada all do not have trial lawyers? Interesting. How do they settle civil disputes? Are you saying that the Association of Trial Lawyers of America are active in France, Germany, or Canada?

      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? Do you even know who the Association of Trial Lawyers of America are? They don't represent all trial lawyers, they specificly represent plaintiff tort lawyers, especially the "Ambulance Chaser" types. They called themselves the "Association of Trial Lawyers of America", because it sounds better than the "Ambulance Chasers of America". But even then, they had some serious PR issues as the ATLA is pretty much associated with frivolous lawsuits, so they changed their name to the "American Association for Justice".

      In conversations about politics, when people refer to the "Trial Lawyers", it means the ATLA or AAJ or whatever they changed their name to this month... these are specificly the lawyers who sue people. These lawyers are the single most powerful lobby group in the United States. Like I said, they give 50% more campaign funds than the entire medical industries combined! They give more money than any other industry in America. They do more lobbying than the entire Military-Industrial complex. They are the largest campaign contributor to the Democratic party, and one of the largest campaign contributors to the Republican party. If you listen to a political program, or read political blogs, or even watch CNN, you would know that when people talk about the "Trial Lawyers" in the context of American politics, they are refering to this huge political lobby group that represents ambulance chasers. I shouldn't have to be explaining this to you, you should be able to do a Google search on your own if you don't understand.

      So enough of the useless "You are saying all trial lawyers are evil?" stuff. I suspect you knew exactly what I mean, and are pretending not to understand in order to push the discussion into a different direction.
    12. Re:now arriving at Dallas-Fort Worth... by aevans · · Score: 0

      Why are they called trial lawyers when most of them never work on a single case that could even go to trial? They are tort lawyers and only pursue suits and maybe contract disputes, both civil cases withouth trials, plaintiffs, or defendants.

    13. Re:now arriving at Dallas-Fort Worth... by gowen · · Score: 1

      Capping compensation is like capping prison sentences. It's like saying, no matter how bad your actions are, you can only be punished so far.
      I'm Scooter Libby, and I endorse this sentiment.
      --
      Athletic Scholarships to universities make as much sense as academic scholarships to sports teams.
  54. WARNING: Do not use in medical device! by Anonymous Coward · · Score: 0

    Oh,

    And you can't use Office in a medical device or nuclar recator, either:

    http://office.microsoft.com/en-us/products/HA10210 3171033.aspx

  55. MS claims this is a FULLY DEFINED STANDARD by tinkerghost · · Score: 5, Informative

    When other people claim a standard is fully defined, it means that all the standard use cases are defined* - units, expected parameters, optional parameters, etc. In the real world, nobody uses radians. Radians are used by engineers & scientists. Pilots, backyard builders, school children, and the occasional office worker use degrees.

    To be honest, nobody cares if OOXML defines SIN(x) to take radians, degrees, gradians, or hyperbian-arc-vectors. What we care about is that someplace in the fully defined standard, OOXML needs to say:

    DEFINE: SIN(x[,unit])

    • SIN: geometric function dictating the height of a right triange with a hypotonous of 1 and an angle of x.
    • x: parameter describing the angle to be operated on by the sin function
    • unit - optional: one of a predescribed list of standard descriptors for angle:
      1. D: Degree - unit of angle defined as 1/360th of a full circle
      2. R: Radian - defined as the angle at which the length of an arc is the same as the radius of the arc. 1/2Pi of a full circle ~ 57.3 degrees
      3. G: Gradian - unit of angle defined as 1/400th of a full cicle.
      Missing unit parameters are defaulted to Radians. Unknown unit parameters will result in a type error.

    That's how a proper standard useable for international work in multiple fields is defined. You do not just dump your US help file into the standard & call it done. I have had to deal with a lot of standards, both Military and Industrial, the OOXML standard is well below the grade of the average Mil or Ind standard.

    That's before you get to the point of inclusions in the standard like "Must Replicate Office 98 Behaviour for this feature". Now, if there was a reference to another standard that defined Office 98 behaviour, then it's not a problem. However, I don't see a reference included in the OOXML standard. Worse, for dates, OOXML defines the proper behaviour as their broken implimentation of the Gregorian Calendar - a direct conflict to the existing ISO standards.

    I don't care who sponsored this standard, it's not a properly writen standard. It has huge holes & it's contradictory to several existing standards. Either one should get it rejected. If MS cleans it up so it meets the actual requirements of a "STANDARD" then they should get approved. If they leave it as the crap heap it is, it should be rejected.

    *- if passing sqr(-6) as a unit works in the implimentation, that's not the standards problem. However, if the standard fails to mention the default unit type & the existance of the unit parameter, then there's an issue.

    1. Re:MS claims this is a FULLY DEFINED STANDARD by advocate_one · · Score: 2, Informative

      pilots use degrees yes, however, the software in the navigation computers is using radians... and there's all sorts of conversion shenanigans going on between different units communicating with each other... you may find this hard to believe, but the system I'm currently working on transmits position from the GPS to the Inertial navigation unit in radians, between the INU and the navigation computer in degrees, internally in the navigation computer, all calculations are done in radians, it is displayed in degrees to the pilot on his multi function displays, but transmitted to the Head up display in radians and yet again displayed there in degrees...

      --
      Donald 'Duck' Dunn: We had a band powerful enough to turn goat piss into gasoline.
    2. Re:MS claims this is a FULLY DEFINED STANDARD by tinkerghost · · Score: 1

      you may find this hard to believe,
      Refering to my initial statement :

      I have had to deal with a lot of standards, both Military and Industrial

      I would believe you if one of the pieces required the angle to be described in # of 00 shot to form an arc on a circle the diameter of a 40# cannonball - with a clearly defined composition of the cannonball to ensure referential integrity.

      I said specs & standards are supposed to be fully described, not sane.

    3. Re:MS claims this is a FULLY DEFINED STANDARD by Lord+Ender · · Score: 1

      You said engineers do not exist in the real world, and you take yourself seriously? Pft.

      --
      A slashdotter who didn't build his own computer is like a Jedi who didn't build his own lightsaber.
    4. Re:MS claims this is a FULLY DEFINED STANDARD by advocate_one · · Score: 1

      it would help if you had replied to my post and what I actually wrote, not what you think I wrote...

      --
      Donald 'Duck' Dunn: We had a band powerful enough to turn goat piss into gasoline.
  56. Re:Confused? by Anonymous Coward · · Score: 0

    You mean like supporting the iraq war then not supporting it? Yea, who would support idiots like that...

  57. Is it better to have a faulty car by Anonymous Coward · · Score: 0

    than no car at all?

    No, it is safer to have no car.

    Is it better to have false security or no security? No security is generally held to be better.

    "Slashdot requires you to wait between each successful posting of a comment to allow everyone a fair chance at posting a comment.

    It's been 41 minutes since you last successfully posted a comment"

  58. Re:Confused? by DavidTC · · Score: 1

    Um, no, the subject was the fact that he's basically admitted to visiting a prostitute at the exact same time he was ranting and raving about how gay marriage would destroy straight marriage.

    --
    If corporations are people, aren't stockholders guilty of slavery?
  59. Huh degrees by matt+me · · Score: 1

    Degrees? Great choice. It's not subjective: it neatly fits the 360 days in a year.

    1. Re:Huh degrees by janrinok · · Score: 2, Funny

      Are there only 360 days in your year? Don't you find that calendars are difficult to buy?

      --
      Have a look at soylentnews.org for a different view
  60. Trust in spell chekers?!! by Bill,+Shooter+of+Bul · · Score: 1

    * We trust our spell checkers to check properly

    I did and thats why I go a C in English, because, ironically, my English teacher wouldn't accept the English spellings of words that my cheap o spell checker changed the USA spellings to ( color to colour, tire to tyre, meter to metre, ect).

    --
    Well.. maybe. Or Maybe not. But Definitely not sort of.
  61. Re:Amuritans! You get the leaders you desserve! by Anonymous Coward · · Score: 0

    A Republican senator has apologised for "a very serious sin in my past" after his phone number was linked to an alleged Washington prostitution ring.

    At least the guy got laid, unlike you, a hairy-palmed, masturbating little troll who sits around waiting to post crap on here, while stroking your tiny dick with rusty tweezers.
    What an effing head case.

  62. Conceded :) by sid0 · · Score: 1

    OK, OK, after further reading NOW I understand the argument, that a spec shouldn't leave anything to doubt.

    The AVEDEV function is implemented correctly in Excel 2007. I just checked.

    Yes, yes, Microsoft and ECMA rushed it. :)

    1. Re:Conceded :) by gnasher719 · · Score: 1

      '' The AVEDEV function is implemented correctly in Excel 2007. I just checked. ''

      Not according to Microsoft's new standard.

  63. and you fail CS 101. by twitter · · Score: 1

    Someone failed the math class where they explained that an angle is a "dimensionless derived unit"

    When you give the user the choice of commonly used alternatives, your program should remember what they chose. Overloading functions has been around for a very long time and it's shocking that M$ could screw something so fundamental.

    --

    Friends don't help friends install M$ junk.

    1. Re:and you fail CS 101. by Achromatic1978 · · Score: 1
      Unsurprisingly, what you state has pretty much nothing to do with the issue at hand. The functions are consistent, they use the same units. YOU, as a programmer, AS YOU SHOULD, should not imply conversions in units that are not implied in the functions, or otherwise. If you have a value of, say "0.8", returned by a trig function, and then you multiply by 1000 to convert mm to m, you're at fault for failing the fundamental issue at hand, not the language for saying "Hey, you used a unit of radians in a distance function!".

      But that's of no matter to you, is it? Far easier to "BLAME MICRO$OFT!"

  64. M$ statement at Beuro of Indian standards by anivararavind · · 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

    Here (Page 4, item 9b) M$ repeats again the same affirmation: "Ecma 376 contains full documentation for spreadsheet formulas"

    F

    ull 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

    Two beautiful points in MS response:

    OOXML does not have a large number of features but is "feature rich".

    "The statement was not that the size is due to the large number of features but "feature rich". The size of the document is also due to the fact that it is a fully defined specification." (note, OOXML is incomplete, inconsistent, and lacks semantic, ie, it is a street directory without a map)

    6000+4000 pages of OOXML specifications are needed because MS couldn't be bothered to ask Oasis to define spreadsheet formula's

    "As an example, which was cited in the meeting but has not been captured in the minutes, is the specification for implementing formulas in Spreadsheets which is not present in ODF. In this case what would spreadsheet formula specifications be considered as if not a point of standardization."
  65. An example: STUPID_FUNCTION (ceiling) by anivararavind · · Score: 1

    Some of those errors are quite stupid other are probably less of a problem, following is a demonstration on one function (ceiling) http://www.openmalaysiablog.com/2007/07/mathematic ally-.html

  66. Lies, damned lies, and Excel by Anonymous Coward · · Score: 0

    It's not like Microsoft is well known to the accuracy of the calculations in Excel to begin with, let alone how they translate to other formats. Here is a link to an (old) article discussing the suitability of excel for statistical calculations. If you search for references to the accuracy of calculations in excel, it becomes clear that this is not excel's stong point.

    http://gcrc.ucsd.edu/biostatistics/Excel.pdf

  67. Did you read the article at all? by twitter · · Score: 1

    The functions are consistent, they use the same units. YOU, as a programmer, AS YOU SHOULD, should not imply conversions in units that are not implied in the functions, or otherwise.

    They are neither defined nor consistent and God help you if you try using the OOXML conversion function because it too is ill defined and wrong. They got it wrong BECAUSE they assumed so much and did not document any of it. Rob Weir documents the mistakes he found in painstaking detail. There will surely be more.

    --

    Friends don't help friends install M$ junk.

    1. Re:Did you read the article at all? by Achromatic1978 · · Score: 1
      Bullshit. It's apparently you who didn't read the article:

      First, let's take the trigonometric functions, SIN (Part 4, Section 3.17.7.287), COS (Part 4, Section 3.17.7.50) and TAN (Part 4, Section 3.17.7.313). Hard to mess these up right? Well, what if you fail to state whether their arguments are angle expressed as radians or degrees? Whoops. Same problem for the return value of the inverse functions, ASIN (Part 4, Section 3.17.7.12), ACOS (Part 4, Section 3.17.7.4), ATAN (Part 4, Section 3.17.7.14), and ATAN2 (Part 4, Section 3.17.7.15). It is hard to have interoperable versions of these functions if the units are not specified. What kind of review in Ecma would miss something so simple?

      Units should be specified at least in spec - this is indeed an issue.

      But point me to ONE SINGLE INSTANCE where the above even REMOTELY implies that the different functions use inconsistent units.

      Go on, do it.

  68. Look at me! I can quote Wikipedia! by Anonymous Coward · · Score: 0

    > Someone failed the math class where they explained that an angle is a "dimensionless derived unit". Explaining, short version for the clicky-impaired: angles are the ratio between two measurements of length -- the length of an arc and the radius of said arc.

    Yeah, but what does that mean, exactly? Sure, they're not measured in m/s or something, but riddle me this: how many of 'em are in a circle?

    2*pi? 360? 400? (radians, degrees & gradians, if you're wondering)

    Oh, does that make just a tiny bit of difference? Might that just be the tiniest bit important? I mean, do you really think that sin(90) is the same in radians as it is in degrees? Next you'll tell me that you don't know that arcsin isn't even a function unless you take a branch cut of it and that it matters which one you take. Unless you like getting all your calculations wrong and making mathematicians tear their hair out.

    But who am I kidding? You can pull quotes off of Wikipedia without understanding them at all! Me? Well, I cheated in some of my classes, so I probably don't even deserve this Bachelor of Science degree I have in mathematics. And I clearly don't know anything about them.

  69. Every college grade maths book, maybe by Anonymous Coward · · Score: 0

    But you will have learned 90 degrees WAAAAY before the number "pi" turns up, never mind "pi by 2".

    What are latitudes measured in? Degrees.

    What are trajectories measured in? Degrees.

    When you were introduced to the trig functions YOU WILL have concerned yourself with "degrees" used as the argument. Advanced maths people who are using taylor expansion (or maybe physicists who are advanced enough to do "rough approximation" and this really is degree level stuff nowadays) will use radians because NOW it makes sense. When you start with integrals of cyclic functions, you'll again use radians because it makes the maths easier.

    But it WILL NOT be ALL MATHS BOOKS using radians. IT will be degrees and LATER ON when you're going in to advanced maths you will do radians because rather than using rote memory (or calculators), you'll be having to express equations and transform them, when the movement to units of radians removes a lot of redundant constant multipliers.

  70. Re:Confused? by Anonymous Coward · · Score: 0

    shut the fuck up

  71. Biased Iraqis by fritsd · · Score: 1
    So are you saying is that the Iraqi Bureau of Standards will vote *for* this OOXML "standard" because of historical precedent? ;-D

    (just kidding, and besides, Iraq doesn't seem to currently be a member of JTC1/SC34)

    --
    To be, or not to be: isn't that quite logical, Slashdot Beta?
  72. Oh, my... by hummassa · · Score: 1

    my point (if it didn't come all clear like I thought it would) is that when nothing else is said angles are measured in m/m, i.e., radians; not in (pi/180 m/m == degree) or in (pi/200 m/m == grad).

    --
    It's better to be the foot on the boot than the face on the pavement. ~~ tkx Kadin2048
  73. Re:Amuritans! You get the leaders you desserve! by 5of0 · · Score: 0, Offtopic

    What the crap? Killing machine? Are you referring to the couple of elk that would be inconvenienced by drilling AMWR? Cause last I checked, people were pretty upset about gas prices...and I'm sorry, but inconveniencing (and, yes, perhaps even killing) a few animals that I consider meat (note the part about them being animals...you know, the things we eat?) doesn't bother me too much when the result is oil from our own soil, and reducing our dependency on oil from the Middle East.

    And the ACLU hates him? Good, cause I hate the ACLU. Stopping some crazy, expensive governmental plans for oil reduction that is doomed to failure? Sounds good to me.

    Somehow, berating a REPUBLICAN senator for voting very...umm...REPUBLICAN seems kind of idiotic. Kind of like criticizing /. for having a bias towards tech/geeky news. It's stupid.

    Oh, and GP: in case you hadn't made the connection, the sin he was talking about was...prostitution. Not voting to kill elk. Just wanted to make that clear.

    Oh, and by the way, I'm a grammar nazi - and it's hypocrite. And yes, I do think less of you and your comment because you can't spell right, or at least put forth the effort use a spell checker (Google Toolbar? FF2.0?).

    --
    You all have Oo.o and Firefox, so get World Wind.
  74. Small correction: by marcosdumay · · Score: 1

    "Now that MS are the only ones who are allowed to change the standard"

    They can't change the standard anymore. It's on fast-track, and the correction time has passed. Microsoft simply ignored all contradictions reported, making no correction.

    Nobody can change it now, it will be accepted or rejected as is.

  75. maybe.... by Anonymous Coward · · Score: 0

    ...if they didn't drink the beer, and refrained from intimate contact with your women, they wouldn't get sick and need healthcare? ;)

  76. Re:Not a good thing, because it is not a free form by krasmussen · · Score: 1

    Just that should be enough to deny it ISO certification.

  77. lol Microsoft by Anonymous Coward · · Score: 0

    I keep thinking about that Microsoftie who told the guy who was leaving 'my Dad died and it didn't affect my productivity'. He probably produced shit like OOXML instead of visiting his dying Dad.

  78. Dang...AC by 5of0 · · Score: 1

    That was the funniest thing I've read in a long time, and it can't be modded up. Sad.

    --
    You all have Oo.o and Firefox, so get World Wind.
  79. No more than you by dedazo · · Score: 1

    Since you can't even figure out simple arithmetic rounding.

    --
    Web2.0: I love when people Flickr my cuil and digg my boingboing until my google is reddit and I start to yahoo
  80. Re: Not workable at all. by JetScootr · · Score: 1
    "Ideal world" nothing. True industry standards are a reality in many industries including the software industry (ASCII, TCP/IP, FORTRAN(1), C, etc). "Ambiguities" should NEVER be written into a standard. As TFA says, ODF working groups couldn't finish the formulas for the standard, so that part was omitted from the standard for the time being.

    Kilogram: good example.

    The latest NIST work [...] confirms the institute's 1998 results using the same method while reducing the measurement uncertainty by about 40 percent, thanks mainly to improvements in the hardware used in the experiments.
    The spec is "hard" because it is constantly refined to real-world acheivable precision, adding a few more decimal places every few years. This sometimes requires re-defining it as some real-world item that can be exactly reproduced anywhere. Precise laboratory definition provides more than a standard measure of weight, it also provides a standard measure of the quality of the laboratories that work to the standard. The whole purpose of any standard is (should be) to remove ambiguity.
    Real standards are NOT hostage to the whim of a single company, but instead are guided by the whole industry. By referencing Office, MS can change the "standard" without going thru a standards process or industry body. And MS can do it without notice, since many of MS' licenses allow unnotified software updates.
    Saying that the standard will "reference MS office" is no different than saying that MS Office IS the standard.


    1."Consistently separating words by spaces became a general custom about the tenth century A.D., and lasted until about 1957, when FORTRAN abandoned the practice." --Sun FORTRAN Reference Manual
    --
    Pavlov wouldn't be so famous if he'd used a can opener instead of a bell.
  81. Re:Confused? by Anonymous Coward · · Score: 0
    Funny, I thought liberals were in favor of legalized prostitution.

    Oh yes, and we also favor free crack for elementary school kids. It helps promote the homosexual agenda.

  82. In defense of degrees by FuzzyDaddy · · Score: 1
    Degrees are used in mechanical drawings, and for good reason. The problem is rounding. If I put 60 degrees in a mechanical drawing, it will be exactly 1/6th of a circle. In radians, it would be 1.047197... if someone rounded off to 1.05, there could be serious misalignment issues. Radians are easier to calculate with, and degrees are better at expressing integral fractions of a circle.

    Back in the day, when I worked for an IC maker, we got a bunch of TSOP parts (with very fine lead spacing) back from the packaging house. They were unusable because whoever did the drawing didn't carry enough precision when translating from inches to millimeters, so the pins were not spaced correctly. Rounding matters.

    --
    It's not wasting time, I'm educating myself.
  83. Software error losses by Svartormr · · Score: 1

    Loss of Mariner 1 in 1962. Loss of the Mars Climate Orbiter in 1999. Mistakes in the control software design led to situations where these spacecraft were lost.

    1. Re:Software error losses by Discoflamingo13 · · Score: 1

      To nitpick, the Mariner 1 incident is a confluence of hardware/system/software errors, and the Mars Climate Orbiter is a Lockheed Martin software error/NASA integration error. If, in the fifty years of NASA's existence, these are the only field-reportable software errors you can name off the top of your head, its seems disingenuous to accuse NASA's software engineers of "repeated incompetence".