OpenDocument Format

The OOXML Date Bug

OOXML Date Bug

This is an example of an old Excel bug that was transported to OOXML for “compatibility” reasons.

In new OOXML, there are several non-standard ways to represent dates. The main one is this, that requires that 1900 is a leap year contradicting the Gregorian calendar, used for centuries now.

More info on this in a post by Rob Weir.

6 comments to The OOXML Date Bug

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>