Re: Value of a date in Numbers
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 17:14:50 +0100
On 4 févr. 2009, at 16:48:25, Michelle Steiner wrote:
On Feb 4, 2009, at 8:32 AM, Luther Fuller wrote:
Now, back to the original problem: Do dates stored in Numbers
follow this standard?
Numbers apparently treats the displayed time in a cell as being
GMT, but reports it to Applescript as local time.
It's the opposite.
Numbers displays local time but sends GMT to AppleScript.
It is 17h06:29. The cell B9 contains =NOW()
the log returns:
tell application "Numbers"
get value of cell "B9" of table 1 of sheet 1 of document 1
date "mercredi 4 février 2009 18:06:29"
end tell
When changing the time zone in System Preferences, the date/time
displayed in Numbers does not change, but the date/time it reports
to Applescript does change.
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?
I don't see an Advanced Preferences Panel in Numbers.
So, at this time I understand that those exchanging time values
between Numbers and iCal may set iCalthe way it receive correct
values but
this is useless for exchanges between Numbers and AppleScript.
To change the time zone for an event:
<step_1.gif>
Choose iCal > Preferences, click Advanced, and select the “Turn on
time zone support” checkbox.
Yvan KOENIG (from FRANCE mercredi 4 février 2009 17:14:33) _______________________________________________
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