• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Value of a date in Numbers
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Value of a date in Numbers


  • Subject: Re: Value of a date in Numbers
  • From: KOENIG Yvan <email@hidden>
  • Date: Wed, 4 Feb 2009 22:24:51 +0100


Le 4 févr. 2009 à 18:16:31, Michelle Steiner a écrit :

On Feb 4, 2009, at 9:14 AM, KOENIG Yvan wrote:

and: Do dates stored in iCal follow this standard?

The Advanced panel of Numbers' preferences has a checkbox item, "Turn on Time Zone Support"; here is what "help" has to say about it:

Are you writing about iCal or about iCal?

iCal.

-- Michelle

Thanks

So we are always with an odd behavior.

The creation/modification date is not ruled by the program but by the operating system.

In Numbers '08, the format used to tore the date_time values contained the GMT offset
but we where unable to test the way it exported: no AppleScript's support.


In Numbers '09 datetime are stored an other way. We are back to the count of seconds.
This time the point of departure is 1/1/2001.


In the new Index.xml file, I didn't saw any information about GMT but my guess is that it uses the value used by the system clock.

But maybe I missed something.
The Index.xml file for a document with two dates and one word
(helping to locate the cells description) contains: 1 074 077 ASCII characters !


Yvan KOENIG (from FRANCE mercredi 4 février 2009 22:24:45)




_______________________________________________ Do not post admin requests to the list. They will be ignored. AppleScript-Users mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden
References: 
 >Value of a date in Numbers (From: Michelle Steiner <email@hidden>)
 >Re: Value of a date in Numbers (From: Luther Fuller <email@hidden>)
 >Re: Value of a date in Numbers (From: Michelle Steiner <email@hidden>)
 >Re: Value of a date in Numbers (From: Luther Fuller <email@hidden>)
 >Re: Value of a date in Numbers (From: "Mark J. Reed" <email@hidden>)
 >Re: Value of a date in Numbers (From: Luther Fuller <email@hidden>)
 >Re: Value of a date in Numbers (From: Michelle Steiner <email@hidden>)
 >Re: Value of a date in Numbers (From: KOENIG Yvan <email@hidden>)
 >Re: Value of a date in Numbers (From: Michelle Steiner <email@hidden>)

  • Prev by Date: Re: path to a script
  • Next by Date: unable to execute javascript via applescript in acrobat - result "undefined"
  • Previous by thread: Re: Value of a date in Numbers
  • Next by thread: Re: Value of a date in Numbers
  • Index(es):
    • Date
    • Thread