The "combined date and time representation" is broken in Switzerland and all other locales which switch to day-light-saving time and back, on those days which are 23 hours or 25 hours long instead of the usual 24 hours.
Acknowledged

This problem is most easily avoided by always using UTC for the "combined date and time rep-resentation".
Clarify the behaviour on transitions to daylight saving time and back.

Part 4,
3.17.4.3

te

Proposed Disposition of DIS 29500 Comment CH-0010 (Modified: 2008-01-02) While we understand the comment, and agree that there is no way in SpreadsheetML to designate or differentiate between “standard time” and “daylight savings time” in those locations where time shifts are used, we do not plan to make any changes to the specification to support “daylight savings time.” SpreadsheetML assumes that all times are specified using UTC or using time zone offsets from UTC as specified by ISO 8601. If ISO 8601 is updated with a standard representation for differentiating “standard” and “daylight savings” time, we recommend that the SpreadsheetML specification be updated to match. Note that we do understand the importance of supporting ISO 8601 date and time formats (including time zones), and have added support for specification of UTC dates and times using an ISO 8601 format in response to several other comments, including AU-0017 and JP-0071. Similar Comments: GR-0024 , IR-0044 , IR-0045

Tag and Go

No Comments

Sorry, the comment form is closed at this time.

  • Argentina (1)
  • Australia (30)
  • Austria (1)
  • Belgium (1)
  • Brazil (64)
  • Bulgaria (3)
  • Canada (79)
  • Chile (217)
  • China (1)
  • Colombia (237)
  • Czech Republic (75)
  • Denmark (168)
  • Ecma (76)
  • Ecuador (1)
  • Finland (15)
  • France (592)
  • Germany (162)
  • Ghana (12)
  • Greece (113)
  • India (82)
  • Iran (58)
  • Ireland (12)
  • Israel (33)
  • Italy (2)
  • Japan (82)
  • Jordan (1)
  • Kenya (81)
  • Malaysia (23)
  • Malta (5)
  • Mexico (7)
  • New Zealand (54)
  • Norway (12)
  • Peru (10)
  • Philippines (7)
  • Poland (4)
  • Portugal (118)
  • Singapore (2)
  • South Africa (17)
  • South Korea (25)
  • Spain (1)
  • Switzerland (19)
  • Thailand (1)
  • Tunisia (3)
  • Turkey (1)
  • UK (635)
  • Uruguay (18)
  • USA (288)
  • Venezuela (73)