The time stamp format proposed here does not include time zone and daylight saving time. So it can be ambiguous and may cause interoperability problems between different time zones.

A notion of time zone and daylight saving can be added or the current time can be calculated from UTC internally and stored as UTC time stamps in the serialized form.

Part 4, Section 3.17.4.2

te

Proposed Disposition of DIS 29500 Comment IR-0044 (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: CH-0010 , GR-0024 , IR-0045

Tag and Go

No Comments

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

  • 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)