Re: [office] Date and Timezone: draft text

From
David A. Wheeler <>
Date
2008-07-06T17:33:36+00:00
ID
Thread
Re: [office] Date and Timezone: draft text
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