BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

OpenXML Spreadsheet Formulas Called into Question

| by Jonathan Allen Follow 128 Followers on Jul 11, 2007. Estimated reading time: 1 minute |

Rob Weir has called the spreadsheet formulas into question. Lost in the posturing and grandstanding are some serious holes in the specification.

The first example is the SIN function:

Description: Computes the sine of x.

Notice there is no mention of what units the parameter x expects. While you can figure out that it expect radians from the examples, it is never explicitly stated.

The next mistake cited by Rob Weir is quite amusing.

The AVEDEV function (Part 4, Section 3.17.7.17) should return the average deviation of a list of values. However, the formula given for this function is actually for calculating the number of combinations of n things taken k at a time. Nice formula, though. Jakob Bernoulli would be proud. But anyone using an OOXML spreadsheet application based on this standard will be perplexed at the values returned by their AVEDEV function. Did these formulas get any expert review in Ecma?

Internationalization also raises questions.

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!

Rob Weir lists several more problems with the OpenXML spec in his blog An Antic Disposition.


Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Response from Microsoft by Jonathan Allen

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

1 Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT