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: Tue, 3 Feb 2009 16:56:15 +0100
Le 3 févr. 2009 à 16:40:34, email@hidden a écrit :
From the numbers and the standard additions dictionary:
AppleScript knows nothing of time zones.
Yet, the current date osax command returns the date using the time
zone specified set in the mac's preferences.
So the date class is time zone neutral but current date commands
knows about time zones.
This may be worth a bug/feature request for numbers.
ES
As I wrote, it's already reported.
Your tracking number for this issue is Bug ID# 6524573.
When I run this kind of script in France
on doYourDuty(c, r, t, s, d) (*
c = columnIndex
r = rowIndex
t = table's name
s = sheet's name
d = document's name *)
tell application "Numbers" to tell document d to tell sheet s to tell
table t to set o to value of cell r of column c
end doYourDuty
on a cell containing the date_time January 12, 2009 10:10:10 AM
as you may check, the Index.xml file contains the correct:
<sf:t sf:s="SFTCellStyle-1" sf:w="127.58994" sf:h="14"><sf:ct
sfa:s="24 janvier 2009 10:10:10:46"/></sf:t>
tell application "Numbers"
get value of cell 6 of column 2 of table "Tableau 1" of sheet
"Feuille 1" of document "Sans titre"
date "lundi 12 janvier 2009 11:10:10"
end tell
The code grabbing the date_time value fails to take care of the
Summer Hour
It's a bit annoying !
I posted in my late message a link to a script describing my own
workaround.
Yvan KOENIG (from FRANCE mardi 3 février 2009 16:56:12) _______________________________________________
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