• 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 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
  • Follow-Ups:
    • Re: Value of a date in Numbers
      • From: Michelle Steiner <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>)

  • Prev by Date: Re: Value of a date in Numbers
  • Next by Date: Re: Value of an empty cell in Numbers
  • Previous by thread: Re: Value of a date in Numbers
  • Next by thread: Re: Value of a date in Numbers
  • Index(es):
    • Date
    • Thread