Submission + - OOXML's "Formula for Failure" (robweir.com)
Xenographic writes: "As Microsoft fights for the standardization of it's OOXML document format, one of it's most touted strengths is the documentation of its formulas. But how good are they, really? According to Rob Weir, OOXML's formula specification is very wrong. In short, there are many locale issues and several numerical functions don't match the mathematical definitions at all. Even if you don't care about OOXML vs. ODF at all, it's probably still worth a read if you're like me and want to know why some of your old Excel spreadsheet formulas never came out right."