Categories
- Chronicles (59)
- Community and Society (90)
- Ecology & Environment (12)
- Essays (32)
- Events (25)
- Gourmet (30)
- Info & Biz Technology (289)
- Linux & Open Source (103)
- Linux Journal Index (14)
- Mobility (19)
- Multimedia (17)
- OpenDocument Format (64)
- Web 2.0 (68)
- Linux & Open Source (103)
- Metaphysics (32)
- Misc (8)
- Music & Podcasts (39)
- Podcast: brazilian jazz (8)
- Podcast: general (13)
- Travels (67)
- Central Asia 2007 (29)
- Vegetarianism (10)
Short updates
The OOXML Date Bug
6
comments
By AviPublished:
Sun, 16 Mar 2008 10:16:43 +0000
Published:
16 Mar 2008
Published:
10:16 am
Categories: OpenDocument Format
Tags: lang:en tech:ok

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.