Re: [office] Date and Timezone: draft text

["David A. Wheeler" <dwheeler@dwheeler.com>]

Rob Weir:
>However, I do not recommend doing this for ODF 1.2.  First, no existing
> spreadsheet application does timezone calculations with datetime values.
> Second, our goal for the first release of OpenFormula was to precisely
> and accurately describe the way spreadsheet formulas currently work.

Agree.

> David, I wonder if we want to explicitly state that the OpenFormula dates
> are explictly in UTC instead of "unspecified time zone"?  This would give
> us something definite to work with if we decided to add timezone
> sensitivity in a future version.

I think that's WORSE.  Almost no spreadsheet documents actually
use UTC, so it would be a lie.  It'd also make it hard to add real
timezone support later.


--- David A. Wheeler